Access 2007 Basic
The target student for this course should be comfortable using a personal computer and
Microsoft Windows XP or later. Students will get the most out of this course if their
goal is to become proficient using the features of Microsoft Access, including the tables,
forms, reports, and filters.
After completing this course, students will know how to:
- 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.

