Continuing Education Microsoft Access Certificate Courses

Module 1: Navigation and Dialog Boxes

Introduction to Microsoft Access; What are Access Database Objects and File Types?; Starting and Exiting the Application; Exploring the Access Application Window; Completing Dialog Boxes; Opening and Closing a Database; Getting Help While You Work

Module 2: Objects in Microsoft Access

Examining Database Objects; Looking at Other Objects; Grouping Database Objects; Managing Data; Editing Data in Datasheet View

Module 3: Tables and Fields in Databases

Creating a Database; Creating Tables; Setting Field Properties; Lookup Fields and Indexes; Modifying Tables and Fields

Module 4: Handling Data and Queries

Sorting and Filtering Data; Displaying and Formatting Data; Using Queries to Retrieve Data; Finding Duplicates and Creating a Query in Design View

Module 5: Microsoft Access Forms and Design

Understanding and Creating Forms; Using the Form Wizard; Modifying and Customizing Forms; Using Form Layout and Design Tools; Formatting and Modifying Form Properties

Module 6: All Sorts of Reports!

Understanding Reports; Creating a Report; Using the Report Wizard; Using the Label Wizard; Understanding the Layout and Design Views; Using the Ribbon’s Report Layout Tools; Using the Ribbon’s Report Design Tools; Formatting Reports and Modifying Report Properties; Printing a Report

Module 1: Database Relationships in Microsoft Access

Understanding Database Relationships; Defining a Database Relationship; Viewing Existing Relationships; Viewing Data in Related Tables and Enforcing Referential Integrity; Modifying Table Design

Module 2: Finding and Cleaning Up Your Data

Selecting Data from Tables; Calculating Fields; Understanding Joins; Finding Unmatched Records; Creating Parameter Queries; Creating Action Queries; Summarizing and Grouping Data; Creating a Crosstab Query; Optimizing a Query

Module 3: Advanced Forms and Formatting in MS Access

Creating Advanced Forms; Naming Controls, Applying Conditional Formatting, and Changing the Tab Order; Using Advanced Controls; Creating and Modifying a Subform; Creating a Switchboard Form; Modifying a Switchboard Form

Module 4: Complex Reports and Specialty Commands

Creating Complex Reports; Embedding Objects in a Report, Applying Conditional Formatting, and Using the Find Command; Working with Subreports; Charting Data; Creating PivotTables and PivotCharts

Module 5: Importing and Data Collection PLUS Introducing SharePoint

Importing Data; Linking Data from an External Source; Exporting and Merging; Saving Database Objects and Databases; Data Collection; Introducing Microsoft SharePoint

Module 6: Macros for the Microsoft Access Database

Creating and Using Macros; Working with Macros; Maintaining a Database; Splitting a Database and Error Checking; Optimizing and Documenting a Database