Comprehensive Microsoft Access Training (ACC501)

1. Access User Interface
   1. Access Ribbon
      1. File
      2. Home
      3. Create
      4. External Data
      5. Database Tools
      6. Contextual Tabs
   2. Quick Access Toolbar
   3. Object Navigation Pane
   4. Access Work Surface
   5. Database Objects
      1. Tables
      2. Queries
      3. Forms
      4. Reports
      5. Macros and Modules
   6. Access Process Overview
   7. Exercise: Navigating the Access Environment
   8. Creating a Database with a Wizard
2. Database Fundamentals
   1. Database Planning Questions
      1. Purpose of the Database
      2. Database Users
      3. Required Output
      4. Processes to Replace or Improve
   2. Exercise: Asking Planning Questions
   3. Database Design Approaches
      1. Top-Down Design
      2. Bottom-Up Design
      3. Practical Design Considerations
   4. Gathering Information
      1. Data Mapping
      2. Sample Data Map
   5. Naming Conventions
   6. Exercise: Gathering Information
   7. Normalization
      1. First Normal Form
      2. Second Normal Form
      3. Third Normal Form
   8. Table Relationships
      1. Relationship Types
   9. Exercise: Normalizing Data
3. Table Views
   1. Purpose of Tables
   2. Datasheet View
      1. Selection Tools
      2. Table Layout Tools
      3. Sorting and Filtering
      4. Printing Records
      5. Record Navigation
      6. Working with Records
   3. Exercise: Working with Tables in Datasheet View
   4. Design View
      1. Opening a Table in Design View
      2. Design View Layout
4. Creating Tables
   1. Creating an Access Database
   2. Exercise: Creating a New Database
   3. Data Types
   4. Exercise: Determining Data Types
   5. Creating a Table in Design View
      1. Deleting a Field
      2. Renaming a Table
   6. Exercise: Creating a Table in Design View
5. Introduction to Queries
   1. Query Purpose, Types, and Views
   2. Select Queries
   3. Criteria
   4. Logical Operators
   5. Grouping and Totals
      1. Totals Row and Group By
   6. Exercise: Creating Select Queries
6. Introduction to Forms
   1. Form Purpose and Views
   2. Modifying Forms
      1. Deleting Forms
      2. Removing Controls
      3. Formatting Forms
   3. Exercise: Adding Records in Form View
   4. Record Navigation
   5. Layout View and Design View
   6. One-Click Forms
      1. Basic Data Entry Form
      2. Basic Multiple-Record Form
      3. Datasheet Form
      4. Split Form
   7. Form Wizard
   8. Exercise: Creating a Form with the Form Wizard
7. Introduction to Reports
   1. Report Purpose and Views
   2. One-Click Reports
   3. Report Wizard
   4. Exercise: Creating a Report with the Report Wizard
8. Relationships
   1. Relationship Review
   2. Referential Integrity
   3. Creating Relationships
      1. Data Types and Relationships
      2. Formalizing Relationships Between Tables
   4. Naming Conventions
   5. Exercise: Creating Relationships
9. Advanced Queries
   1. Query Design View
   2. Select Queries and Criteria
   3. Logical Operators
   4. Parameter Queries
   5. Action and Specialized Queries
      1. Make-Table Queries
      2. Append Queries
      3. Update Queries
      4. Delete Queries
      5. Crosstab Queries
      6. Deleting and Renaming Queries
   6. Exercise: Creating Select and Action Queries
   7. Exercise: Creating a Parameter Query
10. Table and Data Exchange Functions
    1. Importing Data
    2. Linking Tables from External Sources
    3. Importing Tables from Other Databases
    4. Templates and Application Parts
    5. Exercise: Importing Data from Excel
    6. Exercise: Exporting Data to Excel
11. Advanced Forms
    1. Design View
       1. Form Sections
       2. Headers and Footers
       3. Logos and Titles
       4. Adding and Arranging Fields
       5. Spacing Objects
    2. Formatting
    3. Tab Order, Properties, and Controls
    4. Application Parts
    5. Subforms
    6. Modifying Forms
    7. Exercise: Creating Forms
12. Advanced Reports
    1. Design View
    2. Report Sections
       1. Report Header
       2. Page Header
       3. Group Header
       4. Detail
       5. Group Footer
       6. Page Footer
       7. Report Footer
    3. Adding Headers, Footers, Logos, Titles, and Fields
    4. Calculated Fields
    5. Arranging Fields and Resizing Sections
    6. Repeating Headings and Margins
    7. Grouping and Sorting
    8. Report, Section, and Object Properties
    9. Record Counts, Dates, and Page Numbers
    10. Controls and Printing
    11. Subreports and Application Parts
    12. Deleting and Formatting Reports
    13. Backgrounds, Images, and Themes
    14. Exercise: Creating Reports
13. Macros
    1. Macro Basics
       1. Opening Tables, Forms, and Reports
       2. Running Queries
       3. Printing Reports
    2. Running a Macro
    3. Exercise: Creating Simple Macros
14. Completing and Maintaining the Desktop Application
    1. Navigation Forms
    2. Running Macros from a Navigation Form
    3. Setting the Default Form
    4. Exercise: Creating a Navigation Form
    5. Splitting the Database
    6. Password Encryption
    7. Distributing the Front-End Database
    8. Database Maintenance
       1. Compact and Repair
       2. Backup and Recovery
       3. Backward Compatibility

Each student receives a comprehensive set of materials, including course notes and all class examples.

Experience in the following is required for this Microsoft Access class: