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.
Prerequisites
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
