This Introduction to Microsoft Access training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports. Our instructor-led online classes are conducted in the 2013 version of the software. Your instructor will point out the minor differences between versions where they exist. For our custom instructor-led online and onsite classes, we use the version of the software you use in your office.

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.

Class Outline

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
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
Tables and Their Views
1. Tables
  1. Definition and Purpose
  2. Datasheet View
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
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
Tables
1. Creating an Access Database
2. Data Types
3. Create a Table in Design View
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
Reports
1. One-Click Report
2. Report Wizard
  1. Create a Report Using the Report Wizard

Go To Top

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.

Potential Follow-on Classes

Advanced Microsoft Access 2007 Training

Similar Classes

Introduction to Microsoft Access

Go To Top

Quick Links

Locations

Where We've Trained
Some of the Cities in which Webucator has Trained:
1. Phoenix, AZ
2. Pittsburgh, PA
3. Portland, OR
4. Providence, RI
5. Raleigh, NC
6. Sacramento, CA
7. St. Louis, MO
8. San Diego, CA
9. San Francisco, CA
10. San Jose, CA
11. Santa Clara, CA
12. Seattle, WA
13. Sunnyvale, CA
14. Tallahassee, FL
15. Tempe, AZ
16. Toronto, ON
17. Tucson, AZ
18. Tulsa, OK
19. Virginia Beach, VA
20. Washington, DC
1. Fort Worth, TX
2. Hampton, VA
3. Hollywood, FL
4. Houston, TX
5. Huntsville, AL
6. Indianapolis, IN
7. Jacksonville, FL
8. Las Vegas, NV
9. Lexington, KY
10. Los Angeles, CA
11. Louisville, KY
12. Madison, WI
13. Memphis, TN
14. Milwaukee, WI
15. Nashville, TN
16. New York, NY
17. Oklahoma City, OK
18. Omaha, NE
19. Ottawa, ON
20. Philadelphia, PA
1. Amarillo, TX
2. Atlanta, GA
3. Aurora, IL
4. Austin, TX
5. Baltimore, MD
6. Beaumont, TX
7. Boston, MA
8. Buffalo, NY
9. Calgary, AB
10. Cary, NC
11. Chandler, AZ
12. Chicago, IL
13. Cincinnati, OH
14. Cleveland, OH
15. Colorado Springs, CO
16. Columbus, OH
17. Dallas, TX
18. Dayton, OH
19. Denver, CO
20. Detroit, MI
We have trainers all over North America.
1. Indianapolis, IN
2. Boston, MA
3. Silver Spring, MD
4. Portland, ME
5. Detroit, MI
6. Minneapolis, MN
7. Kansas City, MO
8. St. Louis, MO
9. Jackson, MS
10. Charlotte, NC
11. Nashua, NH
12. Atlantic City, NJ
13. Newark, NJ
14. Jersey City, NJ,
15. Reno, NV
16. Philadelphia, PA
17. Calgary, Canada
18. Toronto, Canada
1. Phoenix, AZ
2. Los Angeles, CA
3. Oakland, CA
4. San Diego, CA
5. San Francisco, CA
6. San Jose, CA
7. Santa Clara, CA
8. Sacramento, CA
9. Boulder, CO
10. Denver, CO
11. Hartford, CT
12. Fort Lauderdale, FL
13. Fort Myers, FL
14. Orlando, FL
15. Tallahassee, FL
16. Atlanta, GA
17. Boise, ID
18. Chicago, IL

Compare Us

Compare Webucator to leading Competitors

Training Options

Microsoft Partner

Watch 3-minute Demo Video
of Live Online Training:

Learn the benefits of online training with Webucator

Can't see this video?

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

Technology Training

Business Training

Introduction to Microsoft Access 2007 Training

Delivery Options

Volume Discounts

Webucator Vouchers

Software Assurance Training Vouchers