Microsoft Access 2007 - Advanced
Course Description: Learn some advanced techniques that will help you order, manage, search, and report large amounts of information. This advanced tutorial will show you how to plan and set up tables and fields, create and use forms to enhance data integrity, design and run meaningful queries, and create useful and attractive reports.
Total Time: 6hrs. 31min.
| Lessons (To View Complete Course, Login & Click Below) | Time (Min:Sec) |
|---|---|
| Introduction - Preview | 16:46 |
| 1. Structure Data Input - Preview | 24:30 |
| 2. Validate Data input - Preview | 23:31 |
| 3. Create Indexes and Change Sort Order | 08:44 |
| 4. Create Relationships Between Tables | 21:41 |
| 5. Create Forms and Reports with Related Tables | 07:54 |
| 6. Create Forms with Subforms | 30:24 |
| 7. Create Forms with Special Views | 22:18 |
| 8. Build a Form in Design View | 18:12 |
| 9. Add Controls to Forms | 48:28 |
| 10. Use Advanced Formatting Tools | 12:30 |
| 11. Build Report Based on Queries | 34:18 |
| 12. Export a Report and Create a Lables Report | 14:28 |
| 13. Create a Subreport Using Design Tools | 31:12 |
| 14. Summarize Report Data | 18:42 |
| 15. Create a Report with an Interactive Filter | 14:48 |
| 16. Create a Crosstab Query | 05:41 |
| 17. Create a Pivot Table | 03:38 |
| 18. Create a Pivot Chart | 03:14 |
| 19. Switchboard & Macro | 05:56 |
| 20. Mail Merge with Word | 06:50 |
| 21. Action Query | 14:33 |
| 22. Inner and Outer Joins | 03:10 |
