Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced

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 Table.avi
• 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