Comprehensive Microsoft Access 2007 Training

Delivery Options

• Customized Onsite Training (4 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 restructure an existing set of data to improve the design of a database.
• Learn to use a variety of techniques to summarize and present data with queries.
• Learn to create and revise basic Access macros.
• Learn to create macros that improve data entry efficiency and integrity.
• Learn to improve the effectiveness of data entry in forms.
• Learn to improve the effectiveness of data displayed in reports.
• Learn to maintain an Access database by using various utility tools.
• Learn to share Access data with other applications.
• Learn to use VBA to automate a business process.
• Learn to create and modify a database switchboard, and set the startup options.
• Learn to secure databases.
• Learn to share databases using a SharePoint site.

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. Tables
      1. 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. Structuring Existing Data
   1. Analyze Tables
   2. Create a Junction Table
   3. Improve the Table Structure
10. 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
11. 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
12. Making Effective Use of Forms
    1. Display a Calendar on a Form
    2. Organize Information with Tab Pages
    3. Display a Summary of Data in a Form
13. Making Reports More Effective
    1. Include a Chart in a Report
    2. Print Data in Columns
    3. Cancel Printing of a Blank Report
    4. Create a Report Snapshot
14. 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
15. Integrating Access into Your Business
    1. Import XML Data into an Access Database
    2. Export Access Data to XML Format
    3. Export Data to the Outlook Address Book
    4. Collect Data Through Email Messages
16. Automating a Business Process with VBA
    1. Create a Standard Module
    2. Develop Code
    3. Call a Procedure from a Form
    4. Run the Procedure
17. Managing Switchboards
    1. Create a Database Switchboard
    2. Modify a Database Switchboard
    3. Set the Startup Options
18. Distributing and Securing Databases
    1. Split a Database
    2. Implement Security
    3. Set Passwords
    4. Convert an Access Database to an ACCDE File
    5. Package a Database with a Digital Signature
19. Sharing Databases Using a SharePoint Site
    1. Export a Table to a SharePoint List
    2. Import Data from a SharePoint List
    3. Publish a Database to a SharePoint Site
    4. Move a Database to a SharePoint Site
    5. Work Offline

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.