Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Access Essential Training (Office 365/Microsoft)

via LinkedIn Learning

Overview

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.

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.

Syllabus

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

Taught by

Adam Wilbert

Reviews

Start your review of Access Essential Training (Office 365/Microsoft)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.