Front Runner Training

Learn what you wish you'd known yesterday!

Toll-Free: 1-877-999-0155

  • Home
  • Custom Training
    • Adobe Software Training
      • Adobe Acrobat Training
      • Adobe Captivate Training
      • Adobe FrameMaker Training
      • Adobe Illustrator Training
      • Adobe InDesign Training
      • Adobe Photoshop Training
    • Microsoft Software Training
      • Microsoft Excel Training
      • Microsoft Word Training
      • Microsoft PowerPoint Training
      • Microsoft Office 365 Training
      • Microsoft Access Training
      • Microsoft Project Training
  • Consulting
  • Software
  • Resources
    • Frequently Asked Questions
    • Tips & Tricks
    • Articles
  • About Us
    • Contact Us
    • Testimonials
    • Terms and Conditions
      • Refund / Cancellation Policy
      • Privacy Policy
  • Three Hour Virtual Training Sessions
You are here: Home / Microsoft Software Training / Microsoft Access Training

Microsoft Access Training

Convenient one, two or three day onsite or online courses.

Flexible scheduling to suit your timing requirements.

Choose the topics you need to get your job done.

Microsoft Access – Introductory

Topic 1: Overview of Microsoft Access 2013, 2010 & 2007
•    Database Concepts, terms & conventions
•    Basics concept & objects in Access 2013, 2010, 2007
•    Initial Access database planning and design

Topic 2: Microsoft Access tables – the basic building blocks
•    A typical Access table (records & fields)
•    Creating a table with the wizard
•    Creating a table in design view
•    Adding the Access Primary key (this is used to keep unique records)

Topic 3: Working with Microsoft Access tables
•    Modifying table fields in Design view
•    Searching for records
•    Applying filters & sorts to records

Topic 4: Creating Select Queries to extract select information
•    Adding an Access Select Query for specific fields
•    Adding criteria to a Select Query see only some records
•    Expression (formulas in queries) to add calculations
•    Having multiple tables in a query
•    Select, Make Table, Append, Delete & Crosstab Queries

Topic 5: Creating Forms for easy data entry
•    Creating a new form using the Form Wizard
•    Using the form to modify data
•    Switch to the Form Design view
•    Using a form to locate information
•    Creating Multiple-Table Forms

Topic 6: Creating Access Reports for Data Output
•    Creating reports with the Report Wizard
•    Adding calculations (SUM, COUNT etc.) to reports
•    Editing the report header & footer

Topic 7: Maintaining, Repairing & Compacting a Database
•    Creating an Access database from a template
•    Managing a database and its objects
•    Database maintenance options

Microsoft Access – Advanced

Topic1: Principles of Database Table Design
•    Why Normalize Data
•    Normalizing Data for First, Second and Third Normal Forms

Topic 2: Table Relationships in a Relational Database
•    Creating Table relationships (one to many, one to one etc)
•    Primary keys and foreign keys
•    Using the Access Tools to see table relationships
•    Referential Integrity with table relationships

Topic 3: Access Table Design Techniques
•    Formatting fields
•    Applying Data Validation
•    Adding an Index
•    Input masks & default values

Topic 4: Advanced Select Queries
•    Calculated Fields in Access Queries
•    Creating Multiple-Table Queries
•    Creating Parameter queries

Topic 5: Form Design Customization
•    Customizing the form layout (to enhance usage)
•    Adding Calculations to a form
•    Adding Combo Boxes for form navigation
•    Adding labels etc.

Topic 6: Exporting Access Data to Excel, PDFs etc
•    Export data to Excel and using Pivot tables
•    Import data from Excel

Topic 7: Customizing Advanced Reports
•    Customizing a Report Created by the Report Wizard
•    Summary Options in reports
•    Creating grouping in Access reports

Microsoft Courses Training

Microsoft Excel Training

Microsoft Word Training

Microsoft PowerPoint Training

Microsoft Office 365 Training

Microsoft Access Training

Microsoft Project Training


We accept PayPal:

© 2025 · Front Runner Training a div. of Front Runner Publishing Solutions Inc.