Access 2016

Microsoft Office Access 2016 Part 2

$0.00 

Digital Courseware

Practical Exercise Files

In stock

Add to wishlist
Categories: , .

In this courseware, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

Objectives:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Customize reports to organize the displayed information and produce specific print layouts.

Related Products

  • word 2016

    Microsoft Office Word 2016 Part 2

    $0.00 

    After you master the basics of using Microsoft Word 2016 such as creating, editing, and saving documents; navigating through a document; and printing, you are ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization.

    The Microsoft Office Word 2016 Part 2 courseware focuses on Creating professional-looking documents that can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization.

    Objectives:

    • Organize content using tables and charts.
    • Customize formats using styles and themes.
    • Insert content using quick parts.
    • Use templates to automate document formatting.
    • Control the flow of a document.
    • Simplify and manage long documents.
    • Use mail merge to create letters, envelopes, and labels.
    Add to CartShow details
  • excel-2016

    Microsoft Office Excel 2016 Part 3

    $0.00 

    This courseware builds off of the foundational and intermediate knowledge presented in the Microsoft Office Excel 2016 Part 1 and Part 2 to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel Expert Exam.

    Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

    Objectives:

    • Work with multiple worksheets and workbooks.
    • Use Lookup functions and formula auditing
    • Share and protect workbooks.
    • Automate workbook functionality.
    • Create sparklines and map data.
    • Forecast data.
    Add to CartShow details
  • excel-2016

    Microsoft Office Excel 2016 Part 1

    $0.00 

    This courseware aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel Expert Exam.

    Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

    Objectives:

    • Get started with Microsoft Office Excel 2016.
    • Perform calculations.
    • Modify a worksheet.
    • Format a worksheet.
    • Print workbooks.
    • Manage workbooks.
    Add to CartShow details
  • Windows 10

    Introduction to Personal Computers Using Microsoft Windows 10

    $0.00 

    Whether you are new to computers or have used them in the past, this courseware will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows 10 interface. This courseware will help you to define what a PC is, and familiarize you with the Windows 10 user interface and its basic capabilities. In this courseware, you will explore Windows 10 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users.

    Objectives:

    • Access Windows 10.
    • Use Windows apps and desktop applications to complete day-to-day tasks, including installing new apps and multitasking with multiple programs.
    • Work with files and folders by using File Explorer and OneDrive.
    • Use Cortana as your virtual personal assistant and use Edge for web browsing.
    • Customize the Windows 10 environment.
    • Install and remove printers and peripheral devices.
    • Use Windows 10 security features to create more secure passwords and protect your device against common attacks.
    Add to CartShow details