Overview/Description
Microsoft Office Access 2007 makes it easy for you to create and manipulate database tables. You can choose between a Datasheet view and a Design view to create tables from scratch, or you can base your tables on one of the many pre-defined templates. The introduction of the Ribbon and contextual tabs in Access 2007 makes table creation even more intuitive, and provides you with easier data manipulation techniques. This course explains the use of table templates, Design and Datasheet views, field creation, data types, and modifiable properties, and demonstrates the use of masked input fields and indexing. The course also explores viewing, editing, navigating, sorting, finding, and filtering records, in addition to printing data and implementing and maintaining table relationships.

Target Audience
End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

Prerequisites
Familiarity with a Windows environment

Expected Duration (hours)
2.5

Lesson Objectives

Basic Access 2007 Tables
# create a table from a template in a given scenario
# identify the elements in an Access 2007 table
# identify the table templates
# create a table using Datasheet view
# create a table using Design view
# modify a table
# modify a table in Design view
# create a validation rule
# create a masked input field in a table
# apply indexing to a table
# create a table from a template
# modify a table
# create a table in datasheet view and add a validation rule
# create an input mask
# manipulate data in records in Access 2007
# view, edit, and navigate records
# sort and filter data
# find and replace data
# print records
# create a relationship
# filter table information
# create a relationship
# edit a relationship
# create a relational database in Access 2007