Course Length
Full day
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 a database
- Display Backstage View
- Identify window elements
- Trust a database
- Use the Ribbon, Quick Access Toolbar, and Access Help
- View, open, & close database objects
Tables
- Move and select in a table
- Change row height and column width
- Save the datasheet layout
- Move, freeze and unfreeze fields
- Hide and unhide fields
- Use Find, Replace and undo
- Add a Total row
- View or modify data in a subdatasheet
- Sort and restore records in a table
- Filter records in a table
- Add, edit, and delete records
- Check spelling, print preview and print
- Delete a database object
Database Creation
- Create a new database
- Use naming conventions
- Explore field names, data types, and field descriptions
- Create tables and change views
- Open a table in Design view
- Add, move, and delete fields
- Change a data type for a field
- Change field properties
- Work with input masks
- Assign and delete a primary key
Forms
- Open a form and change form view
- Navigate in a form and add records
- Sort and filter
- Create and save a form
- Edit, print, and delete records
- Display the property sheet
- 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
- Remove a table from a query
- Display/hide table names in the Design Grid
Reports
- Open a report and change the view
- Display the property sheet in a report
- Create and save reports
- Add bound and unbound controls
- Modify report sections
- 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 a laminated reference card.
