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

LinkedIn Learning

Learning Access 2016

via LinkedIn Learning

Overview

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

Syllabus

Introduction
  • Welcome
  • Use the exercise files
1. Get to Know Access 2016
  • Why use an Access database
  • Load a premade 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 Form Wizard
  • Edit the form in Design view
3. Retrieve Information from the Database
  • Create a query using the Query Wizard
  • Edit queries in Design view
  • Create a report using the Report 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.4 rating at LinkedIn Learning based on 100 ratings

Start your review of Learning Access 2016

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.