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

LinkedIn Learning

Learning Access for Office 365

via LinkedIn Learning

Overview

New to databases? Get an overview of the Office 365 version of Access, including building tables, defining relationships, and creating queries and reports.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
1. Get to Know Access 2016
  • Why use an Access database
  • Load a template database
  • Enter data in the Task Management database
  • Explore the Access interface
  • Understand database objects
  • Add data to a table
  • Run a report
2. Build Your Own Database
  • Define data types
  • Create a table
  • Import data from an Excel workbook
  • Define table relationships
  • Build a data entry form using the wizard
  • Edit the form in Design view
3. Retrieve Information from the Database
  • Create a query using the wizard
  • Edit queries in Design view
  • Create a report using the wizard
  • Edit the report in Layout View
  • Add buttons to the form
  • Adjust the database startup options
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

4.6 rating at LinkedIn Learning based on 82 ratings

Start your review of Learning Access for Office 365

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.