Microsoft Office 2016 Access Complete

Course details

Nowadays almost every job in the business world involves office products. Whether you’re an administrative assistant, office manager, sales professional or business manager, utilizing all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. The Microsoft Office 2016 Access Complete Video Course – Beginner, Intermediate & Advanced is designed to provide you all the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided into three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access.

COURSE CURRICULUM

Microsoft Access - Beginner

• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help and Configure Options in Microsoft Access
• Modify Table Data
• Sort and Filter Records
• Create Basic Queries
• Sort and Filter Data in a Query
• Perform Calculations in a Query
• Create Basic Access Forms
• Work with Data on Access Forms
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print
• Organize Report Information
• Format Reports

Microsoft Access - Intermediate

• Relational Database Design
• Create a Table
• Create Table Relationships
• Create Query Joins
• Relate Data Within a
• Work with Subdatasheets from
• Use Field Validation
• Use Form and Record Validation
• Create Parameter Queries
• Summarize Data
• Create Subqueries
• Create Action Queries
• Create Unmatched and Duplicate Queries
• Data Normalization
• Create a Junction Table
• Improve Table Structure
• Include Control Formatting in a Report
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report

Microsoft Access - Advanced

• Add Controls to Forms
• Enhance Navigation and Organization of Forms
• Apply Conditional Formatting
• Import Data into Access
• Export Access Data
• Link Tables to External Data Sources
• Create a Mail Merge
• Create a Macro
• Restrict Records by Using a Condition
• Validate Data by Using a Macro
• Automate Data Entry by Using a Macro
• Manage a Database
• Determine Object Dependency
• Manage a Database
• Determine Object Dependency
• Document a Database
• Splitting a Database for Multiple User Access
• Implement Security
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature
• Create a Database Switchboard
• Modify a Database Switchboard
• Set Start up Options

Updated on 11 June, 2018