MS Access - Level I, CMP961
In this introductory MS Access 2007 class, you will build tables, forms, reports and queries in an existing database with the new Field Insertion feature that streamlines data entry. Create table relationships to efficiently retrieve data from multiple tables and learn how to sort and modify table data. Create Queries to find and locate data by using query criteria, design forms to manipulate data, and develop reports to display data in attractive and useful layouts.
Prerequisites : Computer Basics and Working with Windows or Working with Vista. Experience in PC File Management or equivalent experience.
Classroom Hours: 10
Textbook: Purchase at the Rockville Campus Bookstore and bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
-
Course Objectives:
- Examine the basic database concepts and explore the Microsoft Office Access 2007 environment
- Design a simple database
- Build a new database wit related tables
- Manage data in a table
- Query a database using different methods
- Design forms
- Generate reports
Course Content
Lesson 1: Exploring the Microsoft Office Access 2007 Environment
- Examine Database Concepts
- Explore the User Interface
- Use an Existing Access Database
- Customize the Access Environment
- Obtain Help
Lesson 2: Building a Database
- Describe the Relational Database Design Process
- Define Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize Data
- Designate Primary and Foreign Keys
- Determine Table Relationships
Lesson 3: Building a Database
- Create a New Database
- Create a Table
- Manage Tables
- Create a Table Relationship
- Save a Database as a Previous Version
Lesson 4: Managing Data in a Table
- Modify table Data
- Sort Records
- Work with Subdatasheets
Lesson 5: Querying a Database
- Filter Records
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
- View Data Using an Access Form
- Create a Form
- Modify the Design of a Form
Lesson 7: Generating Reports
- View an Access Report
- Create a Report
- Add a Custom Calculated Field to a Report
- Format the Controls in a Report
- Apply an AutoFormat Style to a Report
- Prepare a Report for Print