Microsoft Access Bootcamp

Access Training Course - Introduction: Complete Class Topics

Access Fundamentals

• Orientation to Microsoft Access
• Create a Simple Access Database
• Configuring Options in Microsoft Access
• Understanding the Help options

Working with Table Data in Access

• Modifying Table Data
• Sorting Records
• Filtering Records

Querying an Access Database

• Create Basic Queries in Access
• Sorting Data in a Query
• Filtering Data in Query
• Perform Calculations as part of a Query

Creating and Using Access Forms

• Creating Forms using Access
• Work with Data in Access Forms

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

Designing Relational Databases

• Fundamentals of Relational Database Design
• Creating Tables
• Creating Table Relationships

Joining Tables in Access

• Creating Query Joins
• Relating Data Within a Table
• Working with Subdata sheets

Using Access Data Validation

• Validating Fields
• Using options for Form and Record Validation

Creating Advanced Queries in Access

• Creating Parameter Queries
• Summarizing Data
• Creating Subqueries
• Creating Action Queries
• Creating Unmatched and Duplicate Queries

Organizing an Access Database for Efficiency

• Data Normalization
• Create Junction Tables
• Improving Table Structure

Using Advanced Reporting Techniques in Access

• Including Control Formatting in Reports
• Adding Calculated Fields to Reports
• Add a Subreport to Existing Reports