MS Access - Level I, CMP961
In this introductory MS Access 2010 class, you will learn how to design and create databases. Work with tables, fields, and records, sort and filter data. Learn to 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.
This course uses a curriculum to prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, you should complete MC Access Level I, II, III.
Prerequisites : Computer Basics and Working with Windows or Working with Vista. Experience in PC File Management or equivalent experience.
Classroom Hours: 10
Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook, bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
-
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
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 Design view
Topic C: Sorting and filtering records
Unit 7: Working with reports
Topic A: Creating reports
Topic B: Modifying and printing reports