Access 2007, Intermediate
As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2007 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far, you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.
Audience
The target student for this course should be comfortable using a personal computer and Microsoft Windows XP or later. Students should also have some experience using Access 2007. They will get the most out of this course if their goal is to become proficient using more advanced Access features and functions, such as relating tables, referential integrity, joins, queries, forms, reports, charts, PivotTables, and PivotTable charts and forms.
- To ensure the successful completion of Microsoft Office Access 2007: Level 2, the completion of the Microsoft Office Access 2007: Introduction course or equivalent knowledge is recommended.
Upon successful completion of this course, students will be able to:
- Normalizing tables, analyze tables and view object dependencies, set table relationships, implement referential integrity between related tables, and set cascading deletes and updates.
- Create a lookup field and a multivalued field, modify lookup field properties, and use a subdatasheet to add data to related tables.
- Create join queries, create calculated fields in a query, and use queries to view summarized and grouped data.
- Add unbound controls, graphics, and calculated fields to a form; create multiple item forms, split forms, datasheet forms, and subforms.
- Add headers and footers in a report, use functions to add calculated values in a report, print table objects and database documents, and create labels.
- Create and modify charts in forms and reports.
- Create a PivotTable, modify a PivotTable, and create a PivotChart and a PivotTable form.
- CertBlaster preparation and materials also included.
- Unit 1: Relational databases
- Unit 2: Related tables
- Unit 3: Complex queries
- Unit 4: Advanced form design
- Unit 5: Reports and printing
- Unit 6: Charts
- Unit 7: PivotTables and PivotCharts
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.