Included Exercise Files
Skill Level : Beginner
Duration : 1h 6m
Language : English
Released : 5/4/2016
Size : 154,92 Mb
Spreadsheets can only go so far. Databases are the next best step for complex data sets. Access 2016, Microsoft's powerful database software, 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.
Topics include:
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
