Microsoft Office Access 2010 Beginning Training

"Made the subject matter fun and was inclusive of all levels of participants."

-Pat Brannen, Atlanta, GA

Get your Training Quote

• Feb 09 - Feb 09, 2012
• Mar 15 - Mar 15, 2012
• Apr 22 - Apr 22, 2012
• May 20 - May 20, 2012
• Jun 17 - Jun 17, 2012
• Aug 26 - Aug 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.

This course is for students interested in designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It is a foundation for more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.

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

• identify the components of a database.
• organize and view data in tables.
• query a database.
• design forms.
• generate reports.

Course Content

Lesson 1: Getting Started with Access 2010

• Identify the Elements of the User Interface
• Identify the Tabs and Commands on the Ribbon

Lesson 2: Identifying the Components of a Database

• Database Concepts and Components of a Database
• Examine the Relational Database Design Process

Lesson 3: Organizing Data in Tables

• Create a Table
• Modify Table Data and Properties
• Create a Table Relationship

Lesson 4: Viewing Data in Tables

• Sort Records
• Filter Records
• View Data from Related Tables

Lesson 5: Querying a Database

• 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

• Create a Form
• View Data Using an Access Form
• Modify a Form

Lesson 7: Generating Reports

• View an Access Report
• Create a Report
• Add a Calculated Field to a Report
• Format the Controls in a Report
• Apply a Theme to a Report
• Prepare a Report for Print

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