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
Share This Post
Have your say!
0 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.