Course ID: 21472 | Course Duration: 4 Days

Microsoft Access 2007 Basic Training Class

Course ID: 21472

Microsoft Access 2007 Basic Training Seminar

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.


	Agenda
	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.


	Pre-requisites
	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.