Advanced Database with Access
CIS 167B
2-day
workshop, $215 +tax
9:00 am-4:00 pm
Students will learn how to solidify their basic Access skills and deepen their knowledge of Access by using advanced software features. Students should understand the basics of Microsoft Windows Office XP and Access. To acquire the Access basics, students should complete the Introduction to Database Management with Access course or have equivalent knowledge.
Skills developed in this course:
| Add and move fields in table design | Explore hyperlinks |
| Add graphics to a form or report | Explore Microsoft On The Web |
| Analyze table relationships | Explore replication |
| Change Startup options | Format reports |
| Change tab order in a form | Group records in reports |
| Create a combo box | Insert fields into table design |
| Create a command button on a form | Join tables in a query |
| Create a custom dialog box | Move controls and labels |
| Create a form based on joined tables | Normalize data |
| Create a macro for form properties | Open Access objects |
| Create a macro to open a form | Sort table records |
| Create a multi-parameter query | Specify field default value |
| Create a single-parameter query | Specify validation rules |
| Create a switchboard form | Specify validation text |
| Create action queries | Use cascade deletions |
| Create an index | Use cascade updates |
| Create hierarchical forms | Use forms to enter and edit data |
| Create queries with multiple criteria | Use junction tables |
| Design a table | Use referential integrity |
| Designate primary-key fields | Use the Input Mask Wizard |
| Determine table relationships | Use the Performance Analyzer Wizard |
| Enforce referential integrity | Use the Publish To The Web Wizard |
| Establish table relationships | Use the Report Wizard |
| Explore database concepts | Use the Table Analyzer Wizard |
| Explore database design | View objects in Datasheet View |
| Explore HTML format | View objects in Design View |
 |
|
 |
|
 |
|