About This Training Course

In this Melbourne one-day Access 2007 Training Level 2 (Creating Smarter Databases) Training Course participants will cover such subjects as; Database normalization, Lookup fields, Joining tables in queries, Adding unbound controls, Customized headers and footers, Charts in forms, PivotTables and many more!

Subjects Covered

"* Relational databases
* Related tables
* Complex queries
* Advanced form design
* Reports and printing
* Charts
* PivotTables and PivotCharts"

Training Course Outcomes

"At the completion of this Access 2007 Training Level 2 (Creating Smarter Databases) Training Course, participants will be able to:

* Normalize 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."

Prerequisites

This Access - Level 2 (Creating Smarter Databases) Training Courseassumes a basic knowledge of Microsoft Access 2003, especially building a database file and data tables. It would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.

Other Information

"Advanced Training provides a range of computer training solutions offering flexible delivery methods, a cost effective approach, smooth implementation and an exceptional level of quality service.

Advanced Training Locations:

• Queen Street, Melbourne - Victoria
• Moore Street, Turner - Canberra
• York Street, Sydney - New South Wales
• Church Street, Parramatta - New South Wales
• Astor Terrace, Spring Hill - Brisbane, Qld
• Innovation House, Mawson Lakes - South Australia
• Patrick Street, Hobart - Tasmania
• St George's Terrace, Perth - Western Australia "