|
Technology Training Centre ~ Excel Word Training in Edmonton Cancellation Policy
Description: Students enrolled in this course will learn to indentify the components of a database, open a table and find information stored in it, create and customize table designs, enter data and validate using input validation formulas, create relationships between tables to ensure data accuracy and deploy referential integrity. Other topics include creating forms for entering data into tables, creating, editing, running queries, creating, enhancing, and previewing reports, and importing/exporting data to and from various sources.
Course Content
The Basics
- Database Concepts
- Creating a Database
- Converting Access Files
- Working with Objects
- Using Access 2007 Help
Table Data
- Table Concepts
- Viewing Data in a Table
- Changing the Datasheet Appearance
- Entering and Editing Data
- Applying Filters
Table Design
- Creating a Table
- Changing the Table Design
Data Entry
- Data Entry Concepts
- Data Formats
- Input Masks
- Input Validation
- Adding Records
Relationships
- Relationships Between Tables
- Creating a Relationship
- Referential Integrity
- Removing a Relationship
- Printing Relationships
Creating and Using Forms
- Creating a Form Using AutoForm
- Creating a Form Using the Form Wizard
- Creating a Form in Design View
- Opening a Form
- Changing a Form Design
- Adding Controls
- Placing Controls
- Multiple-Choice Controls
- Error Checking
Queries
- Using the Query Wizard
- Creating a Query in Design View
- Selecting and Sorting in a Query
- Calculations
- Action Queries
- Parameter Queries
Reports
- Creating Reports
- Using the Report Wizard
- Previewing Reports
- Creating Reports in Design View
- Changing Report Design
- Control Operations
- Control Attributes
Importing and Exporting Data
- Importing and Exporting
- Importing a Text File
- Importing Data from an Access Database
- Exporting Data
- Troubleshooting Importing and Exporting Problems
Printing
- Printing Objects
- Print Preview
Pre-Requisites: Good understanding of Windows and Microsoft software.
Certificates offered: Certificate of completion
Duration Details: 2 days
9:00am - 4:00pm
Facility Location: Edmonton Training Center
B-11 Cameron Library
University of Alberta
Edmonton
Alberta
Canada
T6G 2J8
| 
