Microsoft™ Access

Level 1

Prerequisites: Windows or Equivalent Experience

What is a Database Management System?

	Database Concepts and Terminology
	Access Terminology and Objects
	The Access Window and Environment
	Database Planning and Design
	Naming Conventions
	Planning a Database
	Rules for Database Design
	Relationship Concepts

Working With Tables

	Table Navigation
	Finding and Editing Records
	Undoing Changes
	Adding, Deleting and Copying Records and Values
	Filtering and Sorting
	Printing
	Shortcuts
	Creating and Modifying Tables
	Concepts and Design
	Table and Field Names
	Data Types and Field Properties
	Setting a Primary Key
	Modifying the Table Design

Working with Forms

	Form Navigation
	Sorting and Filtering Records Using a Form
	Finding and Editing Records
	Undoing Changes
	Adding and Deleting Records
	Shortcuts
	Creating and Modifying Forms
	Form Layouts
	Using the Form to Enter Data
	Modifying Form Design and Form Properties
	Adding, Deleting, and Moving a Field
	Adding and Modifying Labels

Working With and Creating Queries

	Selecting Fields and Using Selection Criteria
	Sorting With Queries
	Using Comparison and Selection Operators
	Using Conditional Logic
	Finding Null Values and Using Wildcards

Creating Reports

	Creating a Tabular Report
	Creating Reports With Groups and Totals
	Modifying and Printing a Report
	Creating Mailing Labels

You can print this page with your web browser  

[ Welcome ] [ Course Outlines ] [ Custom Classes ] [ Schedule ]

Send comments and questions to: info@ldiconsulting.com