Access Boot Camp - AdvantEdge Training & Consulting
Loading Classes

« All Classes

  • This class has passed.

Access Boot Camp

January 30, 2023 @ 8:00 am - February 1, 2023 @ 4:00 pm


Microsoft Access Boot Camp Training

Class Duration: 3 days

AccessDo you need to master building and managing databases in a hurry?  Our Boot Camp is an intensive crash course in Access. You will start with the basics, such as navigation and basic forms, and work your way through to the advanced features of the application, such as macros and writing statements in SQL.  There will be ample of hands-on activities that allow you to be sure you have mastered each lesson, and our experienced educators will be there to lead you to a thorough understanding of the material. This intensive three-day Access Boot Camp will take you from beginner to master of this powerful database application.

Training Class Goal

Students who complete this Access Boot Camp will learn to navigate, build, and manage databases.  They will learn to work with forms, fields, records, and queries.  Students will be able to generate reports of their data, and give it visual impact with PivotTables and Charts.  They will understand how to use macros and to write statements in SQL, as well as to integrate internet applications into their databases.


Students should enter this Microsoft Access Boot Camp possessing intermediate computer skills, and have some experience with Microsoft Excel and other Microsoft Office programs.

Topics Covered

  • Design versus Datasheet View
  • Database wizard
  • Creating blank databases
  • Creating tables

Working with Fields

  • Adding fields
  • Identifying primary key fields
  • Adding records
  • Changing table designs
  • Modifying field names
  • Deleting and inserting fields


  • Finding and editing records
  • Sorting and filtering records
  • Setting field properties
  • Input Masks
  • Validation Rules
  • Indexes


  • Creating Queries
  • Filtering Queries
  • Modifying query results
  • Operations in Queries
  • Using Calculators
  • Average and Count functions
  • Creating forms to enter data
  • Formatting and customizing forms
  • Using forms to find, sort, and filter records
  • Creating reports through the report wizard
  • Field properties

Relational databases

  • Database normalization
  • Table Relationships
  • Referential integrity

Related Tables

  • Creating lookup fields
  • Modifying lookup fields
  • Sub-datasheets

Complex queries

  • Joining tables in a query
  • Using calculated fields
  • Summarizing and grouping values

Advanced form design

  • Adding unbound controls
  • Graphics
  • Adding combo boxes

Reports and printing

  • Customized headers and footers
  • Calculated values
  • Labels
  • Charts in forms and reports
  • Pivot Tables and Pivot Charts

Querying with SQL

  • SQL and Access
  • Writing SQL statements
  • Attaching SQL queries to controls

Advanced Queries

  • Creating parameter queries
  • Using Action queries


  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects

Advanced Macros

  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating the AutoKeys and AutoExec macros
  • Creating macros for data transfer

Importing, Exporting, and Linking

  • Importing objects
  • Exporting objects
  • Interacting with XML documents
  • Linking Access objects
  • Working with Windows SharePoint Services

Database Management

  • Optimizing resources
  • Protecting databases
  • Setting options and properties

Internet Integration

  • Hyperlink fields
  • Working with Outlook
  • Navigation Forms
  • Tabbed Forms
  • Switchboards
  • Splash Screens
  • Read-Only Forms
  • Workshop – Instructor led assistance on individual student databases

Get a database crash course with our Microsoft Access Boot Camp and go from novice to master in just five knowledge-packed days! Our courses are designed specifically for companies and their employees.



January 30, 2023 @ 8:00 am
February 1, 2023 @ 4:00 pm
Class Category:


The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available
If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top