Course Length
Full day
Prerequisites
Windows Introduction or equivalent experience
Course Description
This class introduces participants to Access, a database management program used to store different types of information in an organized way so it can be easily and selectively retrieved. Users will create a new database and work with an existing database. Participants will learn how to manage and present the information using tables, queries, forms, and reports.
Course Topics
Getting Started
- Understand database types, relational databases, key fields, and relationships
- Plan, open, and trust a database
- Use the Ribbon, Quick Access Toolbar, and Access Help
- View, open, & close database objects
Tables
- Move and select in a table
- Modify and save a datasheet layout
- Change row height and column width
- Move, freeze, and hide columns
- Modify text, use Find, Replace, & Undo
- Add a total row to a table
- View or modify data in subdatasheets
- Sort and restore records in a table
- Add, edit, and delete table records
- Check spelling, print preview and print
- Delete a database object
Database Creation
- Create a new database
- Understand naming conventions
- Explore field definitions and data types
- Create tables and change views
- Modify a table in design view
- Add, move, and delete fields
- Change a field definition and properties
- Work with input masks
- Assign and delete a primary key
Forms
- Open a form and change views
- Navigate in a form and add records
- Create and save a form
- Sort, filter, edit, print, and delete records
- View a form record source
- Add a caption
Queries
- Run a saved query and change views
- Create, run, and save a select query
- Select columns & rows in the design grid
- Remove fields from the design grid
- Hide a field in the query results
- Sort records in a query
- Rearrange the order of the fields
- Use criteria, comparison operators, and wildcard characters
- Create calculated fields
- Create a “totals” calculation
- Create multi-table queries
- Display table names in the design grid
Reports
- Open a report and change the view
- Sort and remove a sort in a report
- Add bound and unbound controls
- Create and save reports
- Remove controls from a layout
- Select, move, resize, and delete field list controls
- Preview and print reports
- Change page setup
Importing and Exporting
- Import or link Excel data to Access
- Export Access data to Excel
What Participants Receive
Each participant receives a guide containing step-by-step instructions and practice exercises.
