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
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 Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.
SUBSCRIBE NOW
close-link