Featured Courses

• A+ / Network+
• CCNA
• CEH (Ethical Hacker)
• Security+
• MS Office 07 - MCAS
• MCITP - Server Admin

Contact ACE

Academy of Computer Education ® 

Maryland Campus
7833 Walker Drive, Suite 520C
Greenbelt, Maryland 20770
Phone: (301) 220-2802
Toll-Free: (877) 564-TRAIN
Fax: (301) 220-3814

Get Directions

Virginia Campus
45195 Research Pl, Suite 120
Ashburn, VA 20147
Phone: (571) 209-9234
Toll-Free: (877) 774-9234
Fax: (571) 209-9238

Get Directions

Email: click here

Category: Desktop Applications  |  Vendor: Microsoft Corporation

Classrooms in Greenbelt, MD (Washington, DC) &
Ashburn, VA (Northern Virginia | Dulles Corridor)

- OR -
Custom Group Training At Your Facility

Microsoft Access 2007 Training Course (MS Access) for the Microsoft Certified Application Specialist

The Microsoft Access hands on training program is designed to prepare the student for the Microsoft Certified Application Specialist (MCAS) exam for Access. This program replaces what used to be called the Microsoft Office Specialist (MOS). In fact, Microsoft has designed the MCAS Access to include all levels of usability of the program. Microsoft previously had three levels of Access training, now with the changes for the 2007 product, there is only one level and one test.

You also have the option of taking a one day, MS Access Basic User Class. The full two day program, however, offers a more extensive coverage of Microsoft Access and demonstrates the tricks, shortcuts and time saving tools of the program. The full two day class prepares you for the MCAS Access certifcation and makes you the "go-to" person in your office for MS Access.

Topics and Course Content
After completing Access training course, students will understand and be able to implement the following skills:

• Planning and Designing Databases
  Determine appropriate data inputs/outputs for your database, Create table structure, Establish table relationships
• Working with Access
  Use the Microsoft Office Assistant, Select an object using the Objects Bar, Print database objects (tables, forms, reports, and queries), Navigate through records in a table, query, or form, Create a database (using a wizard or in-design view)
• Building and Modifying Tables
  Create tables by using the Table Wizard, Set primary keys, Modify field properties, Use multiple data types, Modify tables using Design View, Use the Lookup Wizard, Use the Input Mask Wizard
• Building and Modifying Forms
  Create a form with the Form Wizard, Use the Control Toolbox to add controls, Modify Format Properties (font, style, font size, color, caption, etc.) of controls, Use form sections (headers, footers, and detail), Use a Calculated Control on a form
• Viewing and Organizing Information
  Use the Office Clipboard, Switch between object views, Enter records using a datasheet, Enter records using a form, Delete records from a table, Find a record, Sort records, Apply and remove filters (filter by form and filter by selection), Specify criteria in a query, Display related records in a subdatasheet, Create a calculated field, Create and modify a multitable select query
• Defining Relationships
  Establish relationships, Enforce referential integrity
• Producing Reports
  Create a report with the Report Wizard, Preview and print a report, Move and resize a control, Modify Format Properties (font, style, font size, color, caption, etc.), Use the Control Toolbox to add controls, Use report sections (headers, footers, and detail), Use a Calculated Control in a report
• Integrating with Other Applications
  Import data to a new table, Save a table, query, or form as a Web page, Add Hyperlinks
• Using Access Tools
  Print database relationships, Back-up and restore a database, Compact and repair a database

Layout and Pricing
1 Day Basic Access User Class (8 hours) - $275
2 Day Full Access Usability Certification Class (16 hours) - $525
1 Certification Exam (Optional) - $100

The Academy of Computer Education has the distinction of being recognized as an official Microsoft IT Academy. The Microsoft IT Academy program is a global IT learning solution that connects educators, students, and communities. Learn more about the features and benefits of the Microsoft IT Academy program.

**Federal, State, Local and Government Employees can have your organization purchase this class with our GSA Contract #GS-35F-0431S.

***Please note that Microsoft is replacing the former Microsoft Office Specialist (MOS) with the MCAS. Go here if you are looking to take the full Microsoft Office Training Class in Maryland and Virginia.

News Related to Access 2007

There are no current articles related to this course. Please check back soon!