Answer Quest offers training for the following classes:
Access 2013 Level 1

Course Objectives:

In this course, you will learn to create and manage a fundamental Access 2013 database. You will:

  • Navigate within the Microsoft Access application environment and create a simple database.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Create advanced queries, including action queries and parameter queries.
  • Create and format custom reports.
  • Customize Access configuration options

Course Content

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data
Topic B: Sort and Filter Records
Topic C: Create Lookups

Lesson 3: Querying a Database

Topic A: Join Data from Different Tables in a Query
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries
Topic B: Create Action Queries
Topic C: Create Unmatched and Duplicate Queries
Topic D: Summarize Data

Lesson 5: Generating Reports

Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print

Lesson 6: Customizing the Access Environment

Topic A: The Access Options Dialog Box

Appendix A: Microsoft Office Access 2013 Exam 77-424

Appendix B: Microsoft Access 2013 Common Keyboard Shortcuts

Access 2013 Level 2

Course Objectives:

In this course, you will work with relational database structure, relationships, efficiency, integrity, and customization. You will:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Share data among Access and other applications.
  • Customize reports to organize the displayed information and produce specific print layouts.

Course Content

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships

Lesson 2: Joining Tables

Topic A: Create Query Joins
Topic B: Join Tables That Have No Common Fields
Topic C: Relate Data within a Table
Topic D: Work with Subdatasheets
Topic E: Create Subqueries

Lesson 3: Organizing a Database for Efficiency

Topic A: Data Normalization
Topic B: Create a Junction Table
Topic C: Improve Table Structure

Lesson 4: Sharing Data Across Applications

Topic A: Import Data into Access
Topic B: Export Data to Text File Formats
Topic C: Export Access Data to Excel
Topic D: Create a Mail Merge

Lesson 5: Advanced Reporting

Topic A: Organize Report Information
Topic B: Format Reports
Topic C: Include Control Formatting in a Report
Topic D: Add a Calculated Field to a Report
Topic E: Add a Subreport to an Existing Report

Appendix A: Additional Reporting Options

Appendix B: Microsoft Office Access 2013 Exam 77-424

Appendix C: Microsoft Access 2013 Common Keyboard Shortcuts

Access 2013 Level 3

Course Objectives:

Upon successful completion of this course, students will be able to:

  • Customize a form layout to improve usability and efficiency of data entry.
  • Add user interface features to validate data entry.
  • Use macros to improve user interface design.
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
  • Lock down and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the startup options.

Course Content

Lesson 1: Implementing Advanced Form Design

Topic A: Add Controls to Forms
Topic B: Create Subforms
Topic C: Organize Information with Tab Pages
Topic D: Enhance Navigation of Forms
Topic E: Apply Conditional Formatting

Lesson 2: Using Data Validation

Topic A: Field Validation
Topic B: Form and Record Validation

Lesson 3: Using Macros to Improve User Interface Design

Topic A: Create a Macro
Topic B: Restrict Records Using a Condition
Topic C: Validate Data Using a Macro
Topic D: Automate Data Entry Using a Macro
Topic E: Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

Topic A: Link Tables to External Data Sources
Topic B: Manage a Database
Topic C: Determine Object Dependency
Topic D: Document a Database
Topic E: Analyze the Performance of a Database

Lesson 5: Distributing and Securing a Database

Topic A: Split a Database for Multiple User Access
Topic B: Implement Security
Topic C: Set Passwords
Topic D: Convert an Access Database to an ACCDE File
Topic E: Package a Database with a Digital Signature

Lesson 6: Managing Switchboards

Topic A: Create a Database Switchboard
Topic B: Modify a Database Switchboard
Topic C: Set Startup Options

Appendix A: Microsoft Office Access 2013 Exam 77-424

Appendix B: Microsoft Access 2013 Common Keyboard Shortcuts

Access 2010 Level 1

Course Objectives

Upon successful completion of this course, students will be able to:

  • Identify the basic components of an Access database.
  • Build the structure of a database.
  • Manage data in tables.
  • Query a database.
  • Design forms.
  • Generate reports.

Course Content

Lesson 1: Getting Started with Access Databases

Topic 1A: Identify the Elements of the Access 2010 Interface
Topic 1B: Identify the Components of a Database
Topic 1C: Examine the Relational Database Design Process

Lesson 2: Building the Structure of a Database

Topic 2A: Create a New Database
Topic 2B: Create a Table
Topic 2C: Manage Tables
Topic 2D: Establish Table Relationships

Lesson 3: Managing Data in a Table

Topic 3A: Modify Table Data
Topic 3B: Sort and Filter Records
Topic 3C: Work with Subdatasheets

Lesson 4: Querying a Database

Topic 4A: Create a Query
Topic 4B: Add Criteria to a Query
Topic 4C: Add a Calculated Field to a Query
Topic 4D: Perform Calculations on a Record Grouping

Lesson 5: Designing Forms

Topic 5A: Create a Form
Topic 5B: Modify the Design of a Form
Topic 5C: View and Edit Data Using an Access Form

Lesson 6: Generating Reports

Topic 6A: Create a Report
Topic 6B: Add a Control to a Report
Topic 6C: Format the Controls in a Report
Topic 6D: Enhance the Appearance of a Report
Topic 6E: Prepare a Report for Print

Appendix A: Microsoft Office Access 2010 Exam 77–885

Access 2010 Level 2

Course Objectives

Upon successful completion of this course, students will be able to:

  • Streamline data entry and maintain data integrity.
  • Join tables to retrieve data from unrelated tables.
  • Create flexible queries to retrieve data and modify tables.
  • Improve the functionality of Access forms.
  • Customize reports to organize the displayed information and produce specific print layouts.
  • Share data between Access and other applications.

Course Content

Lesson 1: Controlling Data Entry

Topic 1A: Constrain Data Entry Using Field Properties
Topic 1B: Establish Data Entry Formats for Entering Field Values
Topic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables

Topic 2A: Create Query Joins
Topic 2B: Join Tables That Have No Common Fields
Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Topic 3A: Set the Select Query Properties
Topic 3B: Retrieve Records Based on Input Criteria
Topic 3C: Create Action Queries

Lesson 4: Improving Forms

Topic 4A: Restrict Data Entry in Forms
Topic 4B: Organize Information with Tab Pages
Topic 4C: Add a Command Button to a Form
Topic 4D: Create a Subform
Topic 4E: Display a Summary of Data in a Form
Topic 4F: Change the Display of Data Conditionally

Lesson 5: Customizing Reports

Topic 5A: Organize Report Information
Topic 5B: Format Reports
Topic 5C: Control Report Pagination
Topic 5D: Add a Calculated Field to a Report
Topic 5E: Add a Subreport to an Existing Report
Topic 5F: Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

Topic 6A: Import Data into Access
Topic 6B: Export Data to Text File Formats
Topic 6C: Export Access Data to Excel
Topic 6D: Create a Mail Merge

Appendix A: Navigation FormsAppendix B: Microsoft Office Access 2010 Exam 77–885

Access 2010 Level 3

Course Objectives

Upon successful completion of this course, students will be able to:

  • Restructure data into appropriate tables to ensure data.
  • Dependency and minimize redundancy.
  • Write advanced queries to analyze and summarize data.
  • Create macros.
  • Customize reports by using various Access features.
  • Maintain your database using Access tools.

Course Content

Lesson 1: Structuring Existing Data

Topic 1A: Restructure the Data in a Table
Topic 1B: Create a Junction Table
Topic 1C: Improve the Table Structure

Lesson 2: Writing Advanced Queries

Topic 2A: Create Subqueries
Topic 2B: Create Unmatched and Duplicate Queries
Topic 2C: Filter Records Using Criteria
Topic 2D: Summarize Data Using a Crosstab Query
Topic 2E: Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro
Topic 3B: Attach a Macro
Topic 3C: Restrict Records Using a Condition
Topic 3D: Validate Data Using a Macro
Topic 3E: Automate Data Entry Using a Macro

Lesson 4: Creating Effective Reports

Topic 4A: Include a Chart in a Report
Topic 4B: Print Data in Columns
Topic 4C: Cancel Printing of a Blank Report
Topic 4D: Publish a Report as a PDF

Lesson 5: Maintaining an Access Database

Topic 5A: Link Tables to External Data Sources
Topic 5B: Manage a Database
Topic 5C: Determine Object Dependency
Topic 5D: Document a Database
Topic 5E: Analyze the Performance of a Database

Appendix A: Microsoft Office Access 2010 Exam 77–885

Access 2010 Level 4

Course Objectives

Upon successful completion of this course, students will be able to:

  • Share Access data with other applications.
  • Use VBA to automate a business process.
  • Create and modify a database switchboard and set the startup options.
  • Secure and distribute databases.
  • Share databases using a SharePoint site.

Course Content

Lesson 1: Integrating Access into Your Business

Topic 1A: Import XML Data into an Access Database
Topic 1B: Export Access Data to the XML Format
Topic 1C: Export Data to an Outlook Address Book
Topic 1D: Collect Data Through Email Messages

Lesson 2: Automating a Business Process with VBA

Topic 2A: Create a Standard Module
Topic 2B: Develop Code
Topic 2C: Call a Procedure from a Form
Topic 2D: Run a Procedure

Lesson 3: Managing Switchboards

Topic 3A: Create a Database Switchboard
Topic 3B: Modify a Database Switchboard
Topic 3C: Set the Startup Options

Lesson 4: Distributing and Securing Databases

Topic 4A: Split a Database
Topic 4B: Implement Security
Topic 4C: Set Passwords
Topic 4D: Convert an Access Database to an ACCDE File
Topic 4E: Package a Database with a Digital Signature

Lesson 5: Sharing Databases Using a SharePoint Site

Topic 5A: Export a Table to a SharePoint List
Topic 5B: Import Data from a SharePoint List
Topic 5C: Publish a Database to a SharePoint Site
Topic 5D: Move a Database to a SharePoint Site
Topic 5E: Work Offline

Answer Quest can teach all versions of this software. Please contact us for more information.