Access 2019 Essential Training

Course details

Learn how to wrangle your data and gain deeper insights by leveraging the power of Microsoft Access 2019. In this course, Access expert Adam Wilbert shows how to use Access to build databases that help you store and retrieve your data more efficiently. Adam begins by going over the concepts behind relational databases. He then discusses how to build tables—the foundation of any database—as well as how to define the relationships between tables and use queries to find and filter data. He also steps through how to build an interface for the database from forms, complete with combo boxes; create reports for printing and sharing; and take steps to maintain your database.

Learning objectives
Determine the essential uses for the Trust Center.
Explore the functions of the database Navigation pane.
Recognize the fundamentals of entering data when using Access.
Identify the necessary steps when importing a table when using Access.
Break down the fundamentals of filtering and sorting table data in Access.
Identify the method utilized when building queries in Design view.
Determine the role of forms in Access.
Examine all of the elements involved in maintaining a database in Access.
Explore how to properly protect an Access database with a password.

Concepts

0. Introduction

01 - Building databases with Access
02 - What you should know

1. Getting Started

03 - Database concepts
04 - Create the database file
05 - Understand the Trust Center
06 - Digging into Ribbon tabs
07 - The database Navigation pane
08 - Customize the Quick Access Toolbar
09 - Create a database backup

2. Creating Tables

10 - Table structures and relationships
11 - Create a table and set data types
12 - Enter data
13 - Primary and foreign keys
14 - Importing tables

3. Setting Field Properties

15 - Relationships and referential integrity
16 - Editing table structure in Design view
17 - Control input with masks
18 - Set a default value
19 - Data validation rules
20 - Data lookup fields
21 - Additional field properties

4. Organizing Records

22 - Sorting table data
23 - Filtering table data
24 - Deleting records
25 - Searching and replacing values

5. Using Queries

26 - What are queries
27 - The Simple Query Wizard
28 - Build queries in Design view
29 - Establishing constraints with criteria
30 - Specifying criteria with wildcards
31 - Incorporating AND and OR statements
32 - Filtering with mathematical comparisons
33 - Create flexible queries with parameters
34 - Build expressions
35 - Obtain summary statistics

6. Creating Forms

36 - Understand the role of forms
37 - Generate forms from tables
38 - Adjusting form elements in Layout view
39 - Using the Form Wizard
40 - Form Design view
41 - Find records

7. Creating Reports

42 - Introducing reports
43 - The Report Wizard
44 - Edit a report in Design view
45 - Edit a report in Layout view
46 - Group and sort records
47 - Creating calculated totals
48 - Apply conditional formatting rules
49 - Create labels
50 - Adjust print settings

8. Maintaining the Database

51 - Customize groups in the Navigation pane
52 - Compact and repair the database
53 - Examine database object relationships
54 - Document your thought process
55 - Print the blueprint of your database
56 - Split a database into front and back ends
57 - Protect the database with a password
58 - Set startup options

Conclusion

59 - Next steps