Microsoft Access
Training

Instructor-led Access classes in Los Angeles

Training is hands-on and all classes are taught
by experienced database developers.

Suitable for Access 2016, 2019 & 365 users.

MS Access Software Satisfaction Guaranteed

What's Included

  • A printed Access training manual
  • Certificate of course completion
  • Guaranteed small class sizes
  • FREE repeat valid for 6 months
  • Class times are 9.00am to 4.00pm

Looking for an online class?
Onsite Access training available countrywide.

Microsoft Access Course Outlines

Access Fundamentals

Access Fundamentals

This class is suitable for trainees new to Microsoft Access. After this class you will have a very good working knowledge of Microsoft Access, including how to design and build an efficient relational database, construct data fields and tables, run queries, design forms and build reports.

2 Days $895

Detailed Course Outline Hide outline

Database Fundamentals
  • Understanding general database terms
  • Database management systems
  • Table Overview
  • Data types
  • Table metadata
  • Queries and SQL
  • SQL Statements
  • Relational databases
  • Flat file databases
  • NoSQL databases
  • Advantages of relational databases
  • Access interface and objects
  • New databases
  • Existing databases
  • The navigation Pane
  • Access objects: Tables, Queries, Forms and Reports
Database Design
  • Fundamentals of efficient design
  • Modeling
  • The logical model
  • The physical model
  • Normal forms
  • Creating and Modifying databases
  • Choosing data types: Numeric, String, Other
  • Constraints
  • Changing table structure
  • Changing data types
  • Adding and deleting fields
  • Relationships and Keys
Tables
  • Creating a simple table
  • Creating tables in Design View
  • Creating fields
  • Creating fields in Datasheet view
  • Creating fields in Table Design view
  • Setting a Primary Field
  • Data Validation using Field Properties
  • Setting validation rules
  • Setting table-level validation
  • Relationships and keys
  • The importance of primary keys and indexes
  • Deciding whether you need unique indexes
  • Creating relationships
Queries
  • Creating basic queries
  • Select queries
  • Action queries
  • Adding data sources to a query
  • Selecting query fields
  • Query criteria
  • Adding mutiple criteria conditions
  • Parameter queries
  • Total queries
  • Cross tab queries
  • Append queries
  • Update queries
  • Delete queries
  • Modifying queries
  • Sorting query results
  • Query field formatting
  • Using calculated fields
  • Creating calculated Yes/No fields
  • Calculated text fields
Forms
  • Creating simple forms
  • Basic form design options
  • Bound and unbound form controls
  • Using the Form Wizard
  • Form Design
  • Displaying form properties
  • Form sections
  • Form controls
  • Adding bound controls to a form
  • Adding controls form the field list
  • Types of controls
  • Test box and label controls
  • List controls
  • Adding a command button
  • Changing the layout of controls
Reports
  • Creating Reports
  • Report basics
  • Setting up data sources
  • Filtering and ordering reports
  • Automatic report generators
  • Using the Report Wizard
  • Report Controls
  • Calculated fields
  • Grouping and summarizing
  • Formatting Reports
  • Report Page Setup options
  • Images and other objects
  • Themes

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Detailed Course Outline Hide outline

Advanced queries
  • Grouping and summarizing
  • About grouping
  • Building totals queries
  • Totals query design
  • Where totals
  • Expression totals
  • Common aggregate functions
  • Updating, deleting, and relationships
  • Referential integrity
  • Cascading practices
  • About cascading deletes
  • Allowing deletes in key fields
  • Allowing updates in key fields
  • Indexing for performance
  • About indexes
  • How an index works
  • Index planning
  • Creating indexes in tables
  • Setting index properties
  • Maximizing performance
  • Specialized query types
  • Pass-Through Queries
  • Data Definition Query
Advanced forms
  • About subforms
  • Creating the main form and subform using the Form Wizard
  • Creating a subform using the SubForm Wizard
  • Using an existing form as a subform
  • Nested subforms
  • Linking forms
  • Main form–subform data relationships
  • The hyperlink control
  • Adding a hyperlink to a form
  • The Web Browser control
  • The attachment control
  • Managing attachments in a form
  • The chart control
  • Specialized form types
  • About navigation forms
  • Creating a navigation form
  • Modal dialog forms
  • Creating a database start-up form
Advanced reports
  • About subreports
  • Subreport record sources
  • Main and subreport with the same record source
  • Main and subreport with related record sources
  • Using an unbound main report as a container
  • Advanced grouping
  • Date ranges
  • Running sums
  • Advanced formatting
  • Banded reports
  • Formatting and design options
  • Showing Username name
  • Using a logo
  • Showing and hiding for printing
Macros
  • Creating a macro
  • Planning macros
  • Using the Macro Builder
  • Using Macro Builder features
  • Embedded macros
  • Assigning macros to events
  • Data macros
  • Using variables
  • Variable scope
  • Choosing variable sources
  • When to use variables
  • Creating macros with variables
  • Troubleshooting macros
  • Error handling basics
  • Stepping through macros
  • Displaying variable values
  • Using the OnError action
  • Using the MacroError Object
  • Designing robust macros
  • Logging Debug info
Importing and exporting data
  • Data exchange basics
  • Choosing which parts of Access to use
  • Other database applications
  • OCDB databases
  • Saving import and export procedures
  • Import options
  • Export basics
  • Exchanging data with other Access databases
  • Linking to Access tables
  • Importing data in Access
  • Exporting Access objects
  • Exchanging data with Excel
  • Importing from Excel
  • Linking to Excel data
  • Appending Excel data
  • Exporting data to Excel
  • Using Text and XML data files
  • Exporting to text files
  • Exporting to XML
  • Importing from text files
  • Importing from XML files
Database management
  • Preparing and running Compact & Repair
  • Running Compact & Repair automatically
  • Restoring a database
  • Other maintenance tasks
  • Encrypting a database
  • Creating an executable file
  • Documenting the database structure

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Package deals

Access Training Package - 2 Levels

$1145

Book both our Access classes and save $200.

Call us

(888) 815-0604

STILL NEED APPROVAL?

Want to reserve a seat but you still need to obtain approval?

No problem, simply call us and we will provisionally hold a seat for you.
There is zero risk, if you don't get approval, we simply cancel the reservation.

Access training reviews

Access classes - 5 rating

Access classes rating: 4.8 stars from 1932 reviewers

Free Repeat

We recognize that Microsoft Access is a complex program, and that trainees may benefit from repeating the class. Included in your course price is a FREE Repeat valid for 6 months. Often the repeat class can be with a different trainer too.

Class guarantee

Our Walk Away, No Hard FeelingsTotally Outrageous Guarantee

Microsoft Access is not for everyone. If you decide that after half a day in class that the software is not for you, we will give you a complete refund. We will even let you keep the hard-copy training manual in case you want to give it another go in the future.

Group Access Training

We offer group training in Access. This can be delivered onsite at your premises, at our training center in Los Angeles, or via webinar.
Fill out the form below to receive pricing.

Step 1: Choose your Training Format

Step 2: Choose your Course/s

Step 3: Enter Details

Access Training FAQ

Training Connection is dedicated to providing the best Microsoft Access training classes in Los Angeles. Please find answers to some of our most frequently asked Access training related questions below, or contact us should you require further assistance.

Resources

Microsoft Access Tutorials

In this section you will find step-by-step how to tutorials on Microsoft Access.

Read more
Cheatseet & Shortcuts

Useful Access cheatseets, and shortcuts PDFs you can download free of charge.

Read more
Specialist

The complete guide on Microsoft Access certification in Los Angeles.

Read more