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

Go to class Write review
Scrimba Ad

Our career paths help you become job ready faster

Learn More → CodeSignal Ad

Introduction to Programming with Python

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.6 rating at LinkedIn Learning based on 193 ratings

Start your review of Learning Access 2016

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.