Microsoft Access 2007 Introduction Training
|
|
Overview and objectives
This one-day Microsoft Access 2007 Training course covers the basic
functions and features of Access 2007. Students will learn how to design
and create databases; work with tables, fields, and records; sort and
filter data; and create queries, forms, and reports.
Target audience
You should be comfortable using a personal computer and Windows XP or
later. You will get the most out of this course if your goal is to
become proficient using the features of Microsoft Access, including the
tables, forms, reports, and filters.
Course prerequisites
Before taking this course, you should be familiar with personal
computers and the use of a keyboard and a mouse. Furthermore, this
course assumes that you've completed the Windows XP: Basic course (or
Windows Vista: Basic) or have equivalent experience.
Course objectives
-
Organize data efficiently by using a database management system; start Access and open Access databases; and use the Help feature.
-
Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
-
Modify a table's design; use the attachment data type; find and replace data; sort, filter, and delete records.
-
Set field properties, create input masks, and set validation rules.
-
Create queries, and sort and filter the results; modify queries; and perform operations in queries.
-
Create, modify, and work with forms; and use them to sort and filter records.
-
Create reports by using the Report button, the Report Wizard, Design view, Layout view, and queries; modify and print reports.
Course contents
Getting started • Database concepts • Exploring the Access
environment • Getting help
Databases and tables • Planning and designing databases • Exploring tables • Creating tables
Fields and records • Changing the design of a table • Finding and editing records • Organizing records
Data entry rules • Setting field properties • Working with input masks • Setting validation rules
Basic queries • Creating and using queries • Modifying query results and queries • Performing operations in queries
Using forms • Creating forms • Using Design view • Sorting and filtering records
Working with reports • Reports • Modifying and printing reports
