Comprehensive Microsoft Access 2010 Training

Delivery Options

• Customized Onsite Training (3 days): Request a Proposal

Class Description

Class Overview

Class Goals

• Learn basic database concepts.
• Learn to design and create databases.
• Learn to create and manage tables.
• Learn to write queries to generate reports and to insert and modify data.
• Learn to create and customize forms.
• Learn to streamline data entry and maintain data integrity.
• Learn to join tables to retrieve data from unrelated tables.
• Learn to create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries
• Learn to write advanced queries to analyze and summarize data.
• Learn to improve forms.
• Learn to customize reports to organize the displayed information and produce specific print layouts.
• Understand how to maintain databases using Microsoft Office Access 2010 tools.
• Learn to share data between Access and other applications.
• Learn to restructure data into appropriate tables to ensure data dependency and minimize redundancy.
• Learn to create and revise Microsoft Office Access 2010 macros.

Class Outline

1. Introduction to Databases
   1. Database Layout
   2. Launching Access
   3. The Access Tab System
   4. Dialog Boxes
   5. Getting Help
   6. Creating a New Database
   7. Creating Databases Using Access Templates
   8. Opening a Database
2. Tables
   1. Database Design
   2. Creating Tables in the Table View
   3. Data Entry
   4. Creating Tables in the Design View
   5. Data Types
   6. Setting a Single-Field Primary Key
   7. Field Properties
   8. Data Display Format vs. Input Mask
   9. The Input Mask
   10. Data Entry Problems
   11. Entering and Editing Data
   12. Selecting Records
   13. Deleting Records
   14. Moving and Copying Records
   15. Pasting Records
3. Working with Tables
   1. Sorting Fields in Tables
   2. Deleting a Table
   3. Table Layout Changes
   4. Temporary Changes
   5. Freezing and Unfreezing Columns
   6. Modifying Table Structure (Fields)
   7. Find
   8. Replace
   9. Wildcards
   10. Modifying Table Data
4. Queries
   1. Data Queries
   2. The Simple Query Wizard
   3. The Design View
   4. Modifying the Query
   5. Using Basic Criteria
   6. Additional Criteria
   7. Parameters
   8. Multiple Object Queries
   9. Custom Calculations in a Query
   10. Grouping Fields
5. Action Queries
   1. Types of Query
   2. The Crosstab Query
   3. The Make Table Query
   4. The Delete Query
   5. The Update Query
6. Forms
   1. Forms
   2. Manipulating Data in the Form
   3. Creating a New Form
   4. Using the Form Wizard
   5. Creating a Form With a Subform
   6. Modifying and Redesigning the Form
   7. Modifying and Redesigning the Report
7. Introduction to Reports
   1. The Report Wizard
   2. Creating a Report with Summary Totals
   3. Using the Label Wizard
   4. Modifying and Redesigning the Report
8. Appendix A: Additional Features in Access 2010
9. Controlling Data Entry
   1. Constrain Data Entry Using Field Properties
   2. Establish Data Entry Formats for Entering Field Values
   3. Create a List of Values for a Field
10. Joining Tables
    1. Create Query Joins
    2. Join Tables with No Common Fields
    3. Relate Data within a Table
11. Creating Flexible Queries
    1. Set the Select Query Properties
    2. Retrieve Records Based on Input Criteria
    3. Create Action Queries
12. Improving Forms
    1. Restrict Data Entry in Forms
    2. Organize Information with Tab Pages
    3. Add a Command Button to a Form
    4. Create a Subform
    5. Display a Summary of Data in a Form
    6. Change the Display of Data Conditionally
13. Customizing Reports
    1. Organize Report Information
    2. Format Reports
    3. Control Report Pagination
    4. Summarize Report Information
    5. Add a Subreport to an Existing Report
    6. Create a Mailing Label Report
14. Sharing Data Across Applications
    1. Import Data into Access
    2. Export Data to Text File Formats
    3. Export Access Data to Excel
    4. Create a Mail Merge
15. Structuring Existing Data
    1. Restructure the Data in a Table
    2. Create a Junction Table
    3. Improve the Table Structure
16. Writing Advanced Queries
    1. Create SubQueries
    2. Create Unmatched and Duplicate Queries
    3. Group and Summarize Records Using Criteria
    4. Summarize Data Using a Crosstab Query
    5. Create a PivotTable and a PivotChart
17. Simplifying Tasks with Macros
    1. Create a Macro
    2. Attach a Macro
    3. Restrict Records Using a Condition
    4. Validate Data Using a Macro
    5. Automate Data Entry Using a Macro
18. Creating Effective Reports
    1. Include a Chart in a Report
    2. Print Data in Columns
    3. Cancel Printing of a Blank Report
    4. Publish Reports as PDF
19. Maintaining an Access Database
    1. Link Tables to External Data Sources
    2. Manage a Database
    3. Determine Object Dependency
    4. Document a Database
    5. Analyze the Performance of a Database

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Onsite course technical requirements and setup instructions.