Great class. I have been using Adobe Acrobat for over 10 years but I still learned a lot. -ARMY, Amy (Adobe Acrobat Pro DC BootCamp Live Hands-On Instructor-Led Training Class)
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.
Duration: 2 Days
Locations for Training:
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.
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.
The Microsoft Office Specialist (MOS) Certification demonstrates that you have the skills needed to get the most out of Office by earning this certification in a specific Office program.
If you choose the Certification Pack option in the pricing dropdown upon checkout, this Includes:
✓ Training Based on Exam Objectives (2 Day Class, Virtual Online Live Training–VOLT™)
✓ Online Test Prep Tool (Simulates actual test & provides targeted learning based on your assessed needs)
✓ Exam Voucher with 1 Free Retake (Scheduled at your convenience)
✓ Testing Proctor Fee (Only included if you take your test Online from home with ThinkB!G)
If you have a team of individuals, you can receive bulk discounts by doing your own Private training session & cover your specific learning objectives!
Great class. I have been using Adobe Acrobat for over 10 years but I still learned a lot. -ARMY, Amy (Adobe Acrobat Pro DC BootCamp Live Hands-On Instructor-Led Training Class)
“Very knowledgeable instructor who uses language everyone can understand. This class has inspired me to replace excel with data we are storing in a more manageable format.” – ArmyEd, Jim – (Microsoft Access Training Course)
Important Notice: Please avoid accessing ThinkB!G remote student computers on devices marked as classified or containing confidential information. Opt for an alternate computer for your training requirements, and for any specific class participation needs or inquiries, don’t hesitate to get in touch with
[email protected].
