|
Technology Training Centre ~ Excel Word Training in Edmonton Cancellation Policy
Description: This course will take students further into the intermediate features of Access. Upon completion of this course students will understand inserting and deleting text into a document, enhancing tables by creating lookups, creating advanced forms by adding controls, subforms, calculations, and graphic images, and working with and creating web-based objects.
Course Content
Database Overview
Enhanced Tables
- Copying a Database
- Lookup Fields
- Creating a Lookup
Advanced Queries
- Query Overview
- The Query Wizard
- Nested Queries
- Query Joins
- Make Table Queries
- Append Queries
- Summary Queries
- Crosstab Queries
Advanced Forms
- Form Design
- Controls
- Form Properties
- Subforms
- Advanced Calculations
- Customizing Forms
Advanced Reports
- Designing Reports
- Sorting and Grouping
- Layout Properties
- Calculations
- Subreports
- Graphic Reports
- Chart Wizard
Supplemental Topics: Working with Web Tools
- Working with Web Pages
- Data Access Pages
- Hyperlinks
Pre-Requisites: Access 2007 – Level I or equivalent knowledge/experience
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
| 
