Access 2007 Basic August 12, 2009

Class Price: $350.00 Class Location: Mission Critical Systems Training Center
8:00 AM - 4:00 PM

Goal – Designed to teach the basics of Access; understanding its various components and creating and using a simple database. This course is recommended for all levels, even for frequent 2003 Access users. It will focus on working with the new 2007 tools to learn the new way to accomplish tasks that might have been done with older Access or programs.

Outline – Database concepts, Design vs. Datasheet view, database wizard, creating blank databases, creating tables, adding fields, identifying primary key fields, adding records, changing table designs, modifying field names, deleting and inserting fields, finding and editing records, sorting and filtering records, setting field properties, input masks, validation rules, indexes, creating Queries, filter queries, modifying query results, operations in queries, conditions (OR, AND), using calculators, Avg and Count functions, creating forms to enter data, formatting and customizing forms, using forms to find, sort and filter records, creating reports through the report wizard, field properties, using the Ribbon, navigating to accomplish tasks, Microsoft Office button.

Prerequisite – ability to use a mouse (click, double-click, right-click, click-and-drag) and ability to type on a keyboard, some use of another Microsoft Office application, such as Excel, to understand concepts like Ribbon and Office button.