Access 2007 Basic

 

Course Outline

 

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

 

 

Access 2007 Basic Course Details

Lecture Hours/Week:  6 hours – One Day Workshop

Lab Hrs/Week:

Contact Hours:  6

Course Description:  Learn the basics of creating a database using design and datasheet views, querying a database using the select query window, maintaining a database using the design and update features, publishing to the Internet using data access pages, and creating reports and forms with features like combo boxes.

Course Competencies:  Upon successful completion of this course, the student should be competent to perform the following tasks:

• 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 Requirements: 

Attendance Requirements:  80%

Evaluation Strategies/Grading:  Students evaluated by Instructor at completion of class

Entry-Level Skills: 

Prerequisites:  Windows

Co-Prerequisites:

Book/Instructional Material Requirements:  Access 2007 Basic Workbook

Method of Instruction:  Instructor Led; Hands-on environment