Basic Access 2007 Tables

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