Access Essential Training (Office 365/Microsoft) (2018)

Course details

Learn how to build Access databases to store and retrieve your data more efficiently. Access expert Adam Wilbert explains the concepts behind relational databases, before moving onto building tables—the foundation of any database. He then demonstrates how to define the relationships between tables and use queries to find and filter data. This course also shows how to apply rules and validation to minimize data entry errors; build an interface for the database from forms, complete with interactive buttons; create reports for printing and sharing; and take steps to maintain the database you created.

Learning objectives
Navigating the interface
Creating tables
Defining data types
Defining table relationships
Sorting and filtering table data
Editing forms
Creating queries and reports
Maintaining a database

Concepts

0. Introduction

01 - Build 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 - Dig into ribbon tabs
07 - 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 - Import tables

3. Setting Field Properties

15 - Relationships and referential integrity
16 - Edit 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 - Sort table data
23 - Filter table data
24 - Delete records
25 - Search and replace values

5. Using Queries

26 - What are queries
27 - Simple Query Wizard
28 - Build queries in Design view
29 - Establish constraints with criteria
30 - Specify criteria with wildcards
31 - Incorporate AND and OR statements
32 - Filter 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 - Adjust form elements in Layout view
39 - Use the Form Wizard
40 - Form Design view
41 - Find records

7. Creating Reports

42 - Introduce reports
43 - Report Wizard
44 - Edit a report in Design view
45 - Edit a report in Layout view
46 - Group and sort records
47 - Create 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