Microsoft Access – Level 2 & 3 / Advanced (Code:44355)

Learn advanced topics in Access 2016 such as how to manage data and data entry, creating forms and dialog boxes, advanced queries, splitting databases, and much more.

This course builds upon 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 topics such as how to manage data and data entry, create forms and dialog boxes, split databases, and much more.


The prerequisite for this course is our Access Level 1 course or an equivalent working knowledge of Access or other database applications.

What You'll Learn

In this course, you will learn to create and manage an Access database. You will:

  • Create Subforms
  • Customize a form layout to improve usability and efficiency of data entry
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy
  • Lock down and prepare a database for distribution to multiple users
  • Create and modify a database switchboard and set the startup options

Course Outline

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. Database Normalization
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

Choose Another Popular Course

Choose Another Course
Share This Post
Have your say!
2 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>

Request a Quote

Request Quote Form

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.