Advanced Microsoft Access 2010 Training

This 3 day Advanced Access 2010 training class is for people who intend to design databases at an advanced level and/or improve existing Access databases.

1. 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
2. Joining Tables
   1. Create Query Joins
   2. Join Tables with No Common Fields
   3. Relate Data within a Table
3. Creating Flexible Queries
   1. Set the Select Query Properties
   2. Retrieve Records Based on Input Criteria
   3. Create Action Queries
4. 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
5. 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
6. 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
7. Structuring Existing Data
   1. Restructure the Data in a Table
   2. Create a Junction Table
   3. Improve the Table Structure
8. 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
9. 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
10. 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
11. 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