Microsoft Office Access 2007 Beginning Training

"Fun, energetic - kept the class moving at a comfortable pace and made it interesting"

-Julie B, Coca Cola

Get your Training Quote

• Mar 26 - Mar 26, 2012

Can't travel or you want to stay with your family or business. No problem! Stay in your own city and save the additional expenses of roundtrip airfare, lodging, transportation, and meals and receive the same great instruction live from our instructors in our Live Instructor-Led Remote Classroom Training.

Remote Classroom Training

Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• design a simple database.
• build a new database with related tables.
• manage the data in a table.
• query a database using different methods.
• design forms
• generate reports.

Course Content

Lesson 1: Exploring the Access Environment

• Examine Database Concepts
• Customize the Access Environment
• Use an Existing Access Database

Lesson 2: Designing a Database

• Describe the Relational Database Design Process
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Normalize Data
• Designate Primary and Foreign Keys
• Determine Table Relationships

Lesson 3: Building a Database

• Create a New Database
• Create and Manage a Table
• Create a Table Relationship

Lesson 4: Managing Data in a Table

• Modify Table Data
• Sort Records
• Work with Subdatasheets

Lesson 5: Querying a Database

• Filter Records
• Create a Query
• Add Criteria to a Query
• Add a Calculated Field to a Query
• Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

• View Data Using an Access Form
• Create a Form and Using the Form Wizard
• Modify the Design of a Form

Lesson 7: Generating Reports

• Create a Report Using the Report Wizard
• Add a Custom Calculated Field to a Report
• Format the Controls in a Report
• Apply an AutoFormat to a Report
• Prepare a Report for Print

CED Solutions is your best choice for MS Access , MS Access training, MS Access certification, MS Access boot camp, MS Access certification training, MS Access certification course, MS Access course, MS Access class.