Access 2007: Level 1
Class Outline:
Description:
This 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. This course will help students prepare for the Access 2007 exam (70-605). For comprehensive certification training, students should complete Access 2007: Levels 1, 2 and 3.
Table of Contents:
Unit 1: Getting started
Topic A: Database concepts
Topic B: Exploring the Access environment
Topic C: Getting help
Unit 2: Databases and tables
Topic A: Planning and designing databases
Topic B: Exploring tables
Topic C: Creating tables
Unit 3: Fields and records
Topic A: Changing the design of a table
Topic B: Finding and editing records
Topic C: Organizing records
Unit 4: Data entry rules
Topic A: Setting field properties
Topic B: Working with input masks
Topic C: Setting validation rules
Topic D: Using indexes
Unit 5: Basic queries
Topic A: Creating and using queries
Topic B: Modifying query results and queries
Topic C: Performing operations in queries
Unit 6: Using forms
Topic A: Creating forms
Topic B: Using the Form Wizard
Topic C: Using Design view
Topic D: Finding, sorting, and filtering records
Unit 7: Working with reports
Topic A: Creating reports
Topic B: Modifying and printing reports
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.