Comprehensive Microsoft Access 2010 Training

Delivery Options

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

Class Description

Class Overview

Class Goals

• Gain an understanding of database concepts and terminology.
• Learn about the Access interface.
• Learn to work with table views, queries, forms, reports, and macros and modules.
• Learn to plan a database.
• Learn database design fundamentals.
• Learn to work with forms and the Form Wizard.
• Learn to work with reports and the Report Wizard.
• 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. Overview of Databases and Access
   1. "Database" Defined
   2. Databases vs Spreadsheets
      1. Questions to Ask When Deciding Whether to Use a Spreadsheet or a Database
   3. Access vs Excel
      1. Discussion Questions
   4. "Relational Database" Defined
      1. Terminology
      2. Observations
   5. "Relational Database Management System" (RDBMS) Defined
   6. Access Is an RDBMS
   7. Benefits and Limitations of Access
      1. Discussion Questions
2. Quick Overview of the 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. Access Options Dialog Box
3. Tables and Their Views
   1. Table Definition and Purpose
   2. Datasheet View
4. Other Database Objects and Their Views
   1. Queries
      1. Definition and Purpose
      2. Types
      3. Views
   2. Forms
      1. Definition and Purpose
      2. Views
   3. Reports
      1. Definition and Purpose
      2. Views
   4. Macros and Modules
      1. Definition and Purpose
5. Fundamentals
   1. Questions to Ask Before You Start
      1. What Is the Purpose of the Database?
      2. Who Will Use the Database?
      3. What Kind of Output Is Needed from the Database?
      4. What Process Is the Database Replacing or Improving?
   2. Approaches to Database Design
      1. Top-Down Database Design
      2. Bottom-Up Database Design
      3. Reality
   3. Gather Information
      1. Discussion
   4. Normalization
      1. First Normal Form
      2. Second Normal Form
      3. Third Normal Form
   5. Table Relationships
      1. Relationship Types
6. Tables
   1. Creating an Access Database
   2. Data Types
   3. Create a Table in Design View
7. Forms
   1. One-Click Forms
      1. Basic Data Entry Form
      2. Basic Multi-Record Form
      3. Datasheet Form
      4. Split Form
   2. Form Wizard
      1. Create a Form with the Form Wizard
8. Reports
   1. One-Click Report
   2. Report Wizard
      1. Create a Report Using the Report Wizard
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.