|
Provided by: Maverick Enterprises Get on Track with MS Access IntermediateAccess |
 |
Students will learn how to create table relationships, Set up input mask properties, work with look-up fields and subdatasheets, create multiple table queries and join queries, create Pivot Tables and Pivot Charts, and use hyperlink fields and data access pages. Basic knowledge of database design and Microsoft Access software is required.
|
|
||||||||||||||||||
Training
Provided by Maverick Enterprises
Get on Track with MS Access Intermediate
Table of Contents
Unit 1: Relational databases; Understanding database normalization, Relating tables, Implementing referential integrity and updates
Unit 2: Working with related tables; Lookup fields, Modifying Lookup fields, Subdatasheets
Unit 3: Complex queries; Multiple table queries, Joining tables in queries, Creating calculated fields, Summarizing and grouping values
Unit 4: Advanced form design; Adding controls to forms, Adding unbound controls, Adding Graphics, Adding calculated values, Adding combo boxes
Unit 5: Advanced reports; Customized headers and footers, Adding calculated values, Subreports
Unit 6: Charts; Charts in forms, Charts in reports
Unit 7: PivotTables and PivotCharts; PivotTables, Modifying PivotTables, Modifying PivotCharts
Unit 8: Internet integration; Hyperlink fields, Working with data access pages
Unit 1: Relational databases; Understanding database normalization, Relating tables, Implementing referential integrity and updates
Unit 2: Working with related tables; Lookup fields, Modifying Lookup fields, Subdatasheets
Unit 3: Complex queries; Multiple table queries, Joining tables in queries, Creating calculated fields, Summarizing and grouping values
Unit 4: Advanced form design; Adding controls to forms, Adding unbound controls, Adding Graphics, Adding calculated values, Adding combo boxes
Unit 5: Advanced reports; Customized headers and footers, Adding calculated values, Subreports
Unit 6: Charts; Charts in forms, Charts in reports
Unit 7: PivotTables and PivotCharts; PivotTables, Modifying PivotTables, Modifying PivotCharts
Unit 8: Internet integration; Hyperlink fields, Working with data access pages
About The Training Provider: Maverick Enterprises
Maverick Enterprises - Maverick Enterprises offers Business, Technology and Communications training for the generation leading the digital revolution. Rob White brings more than 20 years of Technology Consulting Experience to the table. He is a Novell Certified Network Engineer, and a Certified Microsoft Office Specialist.
For over 10 years, Rob has been performing workshops, seminars and conferences in Software...
