Learning Access for Office 365

Spreadsheets can only go so far. Databases are the next best step for complex data sets. Access 2016, Microsoft's powerful database software included with Office 365, is the perfect introduction for those new to relational databases. This course provides an overview for first-time users. Adam Wilbert explains the best uses for Access, tours the interface, and guides viewers through various Access conventions and tasks, like understanding how objects interact, adding data to a table, and running a report. He also shows how to get going quickly with Access templates, create queries and reports to pull insights from data, and even use data from existing sources like Excel.

Learning objectives
Loading a premade template database
Exploring the interface
Defining data types
Creating tables
Defining table relationships
Editing forms
Creating queries and reports
Editing reports in Layout view