Access Essential Training (Office 365/Microsoft)

Harness the power of databases using Microsoft Access. Learn how to build tables, define relationships, create queries, and more, using the Office 365 version of the program.

Introduction

• Build databases with Access
• What you should know

1. Getting Started

• Database concepts
• Create the database file
• Understand the Trust Center
• Dig into ribbon tabs
• Database navigation pane
• Customize the Quick Access Toolbar
• Create a database backup

2. Creating Tables

• Table structures and relationships
• Create a table and set data types
• Enter data
• Primary and foreign keys
• Import tables

3. Setting Field Properties

• Relationships and referential integrity
• Edit table structure in Design view
• Control input with masks
• Set a default value
• Data validation rules
• Data lookup fields
• Additional field properties

4. Organizing Records

• Sort table data
• Filter table data
• Delete records
• Search and replace values

5. Using Queries

• What are queries?
• Simple Query Wizard
• Build queries in Design view
• Establish constraints with criteria
• Specify criteria with wildcards
• Incorporate AND and OR statements
• Filter with mathematical comparisons
• Create flexible queries with parameters
• Build expressions
• Obtain summary statistics

6. Creating Forms

• Understand the role of forms
• Generate forms from tables
• Adjust form elements in Layout view
• Use the Form Wizard
• Form Design view
• Find records

7. Creating Reports

• Introduce reports
• Report Wizard
• Edit a report in Design view
• Edit a report in Layout view
• Group and sort records
• Create calculated totals
• Apply conditional formatting rules
• Create labels
• Adjust print settings

8. Maintaining the Database

• Customize groups in the navigation pane
• Compact and repair the database
• Examine database object relationships
• Document your thought process
• Print the blueprint of your database
• Split a database into front and back ends
• Protect the database with a password
• Set startup options

Conclusion

• Next steps