Access Essential Training (Office 365/Microsoft)

Course details

In this comprehensive course for business professionals and database admins, data visualization expert Adam Wilbert guides you through using Microsoft Access to optimize your database solutions. Learn how to build and manage relational databases; analyze the structure and relationships within databases; and evaluate and improve database performance through advanced queries and automation. Build essential skills for developing, maintaining, and optimizing Access databases in environments that require long-term stability and support. Leverage Access's powerful features to design efficient data structures, create user-friendly forms and reports, and automate processes using macros. By the end of the course, you’ll be equipped with the skills you need to design secure, efficient databases tailored to your specific organizational needs.

Learning objectives
Create database tables.
Set field properties.
Organize database records.
Build Microsoft Access queries.
Create reports from data.
Automate the database with macros.
Maintain the database.

Concepts

0. Introduction

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

1. Getting Started in Microsoft Access (Office 2024)

03 - Building Access databases
04 - Create the database file
05 - Understand the Access Trust Center
06 - Digging into ribbon tabs
07 - The database Navigation Pane

2. Creating Tables in Access

08 - Database concepts
09 - Table structures and data types
10 - Create a table and set data types
11 - Enter data
12 - The role of primary and foreign keys
13 - Relating tables together with key fields
14 - Importing tables

3. Setting Field Properties in Access

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 in Access

22 - Sorting table data
23 - Filtering table rows
24 - Deleting records

5. Using Queries in Access

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

6. Creating Forms in Access

35 - Understand the roll of forms
36 - Generate forms from tables
37 - Adjusting form elements in Layout view
38 - Using the form wizard
39 - Form Design view
40 - Find records
41 - Create a dashboard to view key performance indicators (KPIs)
42 - Working with charts

7. Creating Reports in Access

43 - Introducing reports
44 - The report wizard
45 - Edit a report in design view
46 - Edit a report in layout view
47 - Group and sort records
48 - Creating calculated totals
49 - Apply conditional formatting rules
50 - Add a graph to a report
51 - Adjust print settings
52 - Embed a query in a report's record source

8. Automate the Access Database with Macros

53 - Create a first macro
54 - Work with embedded macros
55 - Take a quick peek at the Visual Basic language

9. Maintaining the Database

56 - Customize groups in the Navigation Pane
57 - Customize the Quick Access Toolbar
58 - Compact and repair the database
59 - Create a database backup
60 - Examine database object dependencies
61 - Document your thought process
62 - Print the blueprint of your database
63 - Split a database into front and back ends
64 - Protect the database with a password
65 - Set startup options

Conclusion

66 - Continue your Access journey