|
Provided by: Maverick Enterprises Get on Track with MS Access IntermediateAccess |
 |
Training
Provided by Maverick Enterprises
Students will learn how to set table relationships, work with Lookup fields and subdatasheets, create join queries, create PivotTables and PivotCharts, and use hyperlink fields and data access pages.
|
|
||||||||||||||||||||
Get on Track with MS Access Intermediate
Table of Contents
Unit 1: Relational databases; Database normalization, Relating tables, Implementing referential integrity
Unit 2: Working with related tables; Lookup fields, Modifying Lookup fields, Subdatasheets
Unit 3: Complex queries; Joining tables in queries, Creating calculated fields, Summarizing and grouping values
Unit 4: Advanced form design; Adding unbound controls, 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, PivotCharts
Unit 8: Internet integration; Hyperlink fields, Working with data access pages
Unit 1: Relational databases; Database normalization, Relating tables, Implementing referential integrity
Unit 2: Working with related tables; Lookup fields, Modifying Lookup fields, Subdatasheets
Unit 3: Complex queries; Joining tables in queries, Creating calculated fields, Summarizing and grouping values
Unit 4: Advanced form design; Adding unbound controls, 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, 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 over 19 Years of Technology Consulting Experince to the table. He is a Novell Certified Network Engineer, and a Certified Microsoft Office Specialst.
For more than 8 years, Rob has been performing workshops, seminars and conferences in Software...
