Duration & Times: 2 Days – 8:30AM-3:00PM EST
Locations for Training:
Course Description In this hands-on, two-day course, you will learn how to create and manage an Access database, and move into more advanced features that will allow you to optimize the database.
Optional Add-On Upon Checkout: The Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their Office skills and advance their careers. If you want to earn your MOS Access Certification, consider adding our Microsoft Access MOS Certification Pack to your training class. The Certification Pack gives you a test prep tool, a testing voucher with a free retake, and a proctor fee all included, to become a Microsoft Office Specialist in Access!
Note: This course covers the following Course Numbers:
• Access Part 1 Course Number: 091083
• Access Part 2 Course Number: 091084
Prerequisites: Students must have a good working knowledge of computers, operating systems, using a mouse, keyboard, standard menus and commands. Students must be able to open, save, and close applications and files, as well as navigate to other folders.
Required Technical Set-Up:
• Primary computer connected to a second monitor OR second computer to view instructor live
• Reliable High-speed internet connection
• Web Browser: Google Chrome Preferred (Alternative: Microsoft Edge)
• 3-Button Computer mouse
• Audio Speaker/Microphone (built-in to computer or external)
Microsoft Access Core Training & Certification Course Outline
1. Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database
Get Help and Configure Options in Microsoft Access
2. Working with Table Data
Modify Table Data
Sort and Filter Records
3. Querying a Database
Create Basic Queries
Sort and Filter Data in a Query
Perform Calculations in a Query
4. Using Forms
Create Basic Access Forms
Work with Data on Access Forms
5. Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
Organize Report Information
Format Reports
6. Designing a Relational Database
Relational Database Design
Create a Table
Create Table Relationships
7. Joining Tables
Create Query Joins
Relate Data Within a Table
Work with Subdatasheets
8. Using Data Validation
Use Field Validation
Use Form and Record Validation
9. Creating Advanced Queries
Create Parameter Queries
Summarize Data
Create Subqueries
Create Action Queries
Create Unmatched and Duplicate Queries
10. Organizing a Database for Efficiency
Data Normalization
Create a Junction Table
Improve Table Structure
11. Using Advanced Reporting Techniques
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Disclaimer: All course objectives and outlines are used as a guideline and are subject to change to ensure the latest information is covered to support real world use of the technology.
Software Versions: ThinkB!G open enrollment classes are taught on the most current version of software whenever possible. To request a specific version, please Contact Us or call us at 301-362-2250.
