Advanced Database with Access
2007

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 and Access 2007. To acquire the Access basics, students should complete the Introduction to Access 2007 course or have equivalent knowledge.

Skills developed in this course:

• Add and move fields in table design
• Add graphics to a form or report
• Analyze table relationships
• Change Startup options
• Change tab order in a form
• Create a combo box
• Create a command button on a form
• Create a custom dialog box
• Create a form based on joined tables
• Create a macro for form properties
• Create a macro to open a form
• Create a multi-parameter query
• Create a single-parameter query
• Create a switchboard form
• Create action queries
• Create an index

• Create hierarchical forms
• Create PivotTable forms
• Create queries with multiple criteria
• Designate primary-key fields
• Design a table
• Determine table relationships
• Enforce referential integrity
• Establish table relationships
• Explore database concepts
• Explore database design
• Explore hyperlinks
• Explore HTML format
• Explore Microsoft On The Web
• Explore replication
• Format reports
• Group records in reports
• Insert fields into table design
• Join tables in a query
• Move controls and labels

• Normalize data
• Open Access objects
• Sort table records
• Specify field default value
• Specify validation rules
• Specify validation text
• Use cascade deletions
• Use cascade updates
• Use forms to enter and edit data
• Use the Input Mask Wizard
• Use junction tables
• Use referential integrity
• Use the Performance Analyzer Wizard
• Use the Publish To The Web Wizard
• Use the Report Wizard
• Use the Table Analyzer Wizard
• View objects in Datasheet View
• View objects in Design View