ACCESS INTERMEDIATE COURSE – TWO DAYS (COULD BE 1 DAY)

Prerequisites

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Access Basic Level.

Course Overview

This course builds on basic Microsoft Access skills acquired in Level 1 to help students become power users. In this Microsoft Access course, students will delve deeper into the program by studying different topics such as how to manage data and data entry, creating forms and dialog boxes, splitting databases, and much more.

Access Intermediate Topics

1. What is a well-structured table (Normalized)? Table Analyzer
2. Object Dependency (Condition)
3. Importance of Table Relationships- Types – How To- Printing Relationships
4. Enforcing Referential Integrity- Cascading Deletes & Updates.
5. DatabaseNormalization
6. How to Relate Tables
7. Implementing Referential Integrity
8. What is lookup field? Types
9. How to add a Multivalued field
10. How to create a Lookup Field
11. Modify lookup field properties (Value list Combo box- Edit list column)
12. Use a Subdatasheet
13. Create outer join, inner join, and self-join queries
14. Types of Queries- Unmatched Q- Find Duplicates Q
15. Create calculated fields in a query – Rule – Expression Builder
16. View summarized and grouped data from tables by using queries
17. Joining Fields Using the Expression Builder
18. Joining Tables in Queries
19. How to create a Form? Types of controls
20. Use controls to add graphics
21. Arranging, Aligning & Formatting Controls
22. Bind a control to a calculated field
23. Create a Calculated Control
24. Add a combo box (= lookup field)
25. Conditional Formatting in a form
26. Create advanced form types (Multiple Value- Split-Datasheet- Subform)
27. Adding Unbound Controls & Topic B: Adding Graphics
28. Adding Calculated Values
29. Adding Combo Boxes
30. Creating Advanced Form Types
31. Customize headers and footers in a report
32. Show report sections
33. Set properties for grouping data, and modify the appearance of a report
34. Add calculated values in a report by using functions
35. Print database objects and a report of database design
36. Create labels report
37. Create and modify a chart in a form
38. Create and modify a chart in a report