Access 2010 Basic

Prerequisites: Windows

Description: This ILT Series course, rated 5.0/5.0 in overall quality by ProCert Labs, covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.

This course will help students prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2010.

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