| Introduction
to Access XP - Level 1A (3.5 hours) $20 Fee covers both Level 1A and 1B Schedule - Registration Form |
Learn basic database design concepts, learn how to create a table as well as add, change and delete information. You will learn how to query a table to find and display your data. Prerequisite: Familiarity with Windows 2000 or Windows XP. | |
| Introduction to Access
XP - Level 1B (3.5 hours) $20 Fee covers both Level 1A and 1B Schedule - Registration Form |
This session builds on Level 1A. You will learn how to create and use a form to add data to your tables, create and use reports, and how to export data to Excel for further manipulation. Prerequisite: Access Level 1A. | |
| Access XP - Using Advanced
Query Features (2.0 hours) Schedule - Registration Form |
Learn to join tables and perform calculations in a query; run a cross tab and parameter query; and use action queries to update and append data to a table. Prerequisite: Access 2000 Level 1A & 1B or equivalent experience. | |
| Access XP - Creating Custom
Forms and Subforms (2.0 hours) Schedule - Registration Form |
This session will review Form creation using the Design view and the Reports Wizard. In additional you will learn to display and add records to a related table using a subform. Prerequisite: Access 2000 Level 1A & 1B or equivalent experience. | |
| Access XP - Creating Custom
Reports (2.0 hours) Schedule - Registration Form |
This session will review Report creation using the Design view and the Reports Wizard. Additional topics covered will be: customizing headers and footers; adding calculated values, forcing pagination and working with subreports. Prerequisite: Access 2000 Level 1A & 1B or equivalent experience. | |
URL:
http://www.siue.edu/TECHTRAINING/AccessDesc.htm
Published by:Technical
Training/Office of Information Technology