Introduction to Databases with Access
2007

2-day workshop, $249
9:00 am-4:00 pm

Students will learn how to design and create databases, tables, queries, forms, and reports. Training will be delivered in a student-directed, case-based, classroom-delivery learning model. Students should understand the basics of Microsoft Windows. Students will acquire the Access basics with the CustomGuide workbooks and in-class demonstrations.

Skills developed in this course:

• Add and move fields in table design
• Add graphics to reports
• Add records to a table
• Add totals to a report
• Change table column widths
• Create a command button on a form
• Create a database by using a wizard
• Create a simple macro
• Create forms
• Create queries with a calculated field
• Create queries with multiple criteria
• Create select queries
• Customize an order-entry form
• Delete records from a table
• Export data to Excel
• Format reports
• Group records in reports
• Import data into an Access table
• Insert fields into table design
• Join tables in a query
• Merge Access with a Word document
• Modify table data
• Move controls and labels
• Open a database
• Open Access objects
• Sort table records
• Use AutoReport
• Use Find in a table
• Use forms to enter and edit data
• Use the Report Wizard
• Use the Table Wizard
• Use Undo
• View objects in Datasheet View
• View objects in Design View