"It was the people...at the end of the day we have to feel comfortable with those we are working with. Datamann people... ...  read more

General Information | Classes Schedule | Available Classes Back to Class List Microsoft Access 2007 - Intermediate Prerequisites: Microsoft Access 2007 - Beginner Levels: Beginner   Intermediate   Advanced   Class length: 1 day Class Objectives Normalize tables, set table relationships, and implement referential integrity between related tables. Create a Lookup list field, modify Lookup field properties, and use a sub datasheet 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, calculated fields, and a combo box to a form. Class Outline Unit 1: Relational databases Topic A: Database normalization Topic B: Relating tables Topic C: Implementing referential integrity Unit 2: Working with related tables Topic A: Lookup fields Topic B: Modifying Lookup fields Topic C: Subdatasheets Unit 3: Complex queries Topic A: Joining tables in queries Topic B: Creating calculated fields Topic C: Summarizing and grouping values Unit 4: Advanced form design Topic A: Adding unbound controls Topic B: Graphics Topic C: Adding calculated values Topic D: Adding combo boxes Unit 5: Advanced reports Topic A: Creating customized headers and footers Topic B: Adding calculated values Topic C: Subreports Unit 6: Charts Topic A: Charts in forms Topic B: Charts in reports Unit 7: PivotTables and PivotCharts Topic A: PivotTables Topic B: Modifying PivotTables Topic C: PivotCharts

Privacy Policy datamann.com © 1975 - 2010 All Rights Reserved. Best Viewed in Internet Explorer and 1024x768 Screen Resolution Template and Graphics by Results Marketing/Communications L.L.C.   Developed and Hosted by GalaxyPlace