In this two day course, participants will examine basic database concepts, and create and modify databases and their
various objects using the Access™ 2007 relational database application. This course is for the individual whose job
responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining
records; locating records; and producing reports based on the information in the database.
- Discuss basic database concepts
- Navigate the Microsoft Office Access 2007 environment
- Explore the Ribbon
- Determine fields and group fields into tables
- Normalize data
- Create a table relationship
- Sort and filter records
- Query a database using different methods
- Design rudimentary forms with the Form wizard
- Generate simple reports with the Report wizard
- Prepare a report for printing