Included Exercise Files
Skill Level : Beginner
Duration : 3h 40m
Language : English
Released : 9/24/2018
Size : 380,11 Mb
Learn how to wrangle your data and gain deeper insights by leveraging the power of Microsoft Access 2019. In this course, Access expert Adam Wilbert shows how to use Access to build databases that help you store and retrieve your data more efficiently. Adam begins by going over the concepts behind relational databases. He then discusses how to build tables—the foundation of any database—as well as how to define the relationships between tables and use queries to find and filter data. He also steps through how to build an interface for the database from forms, complete with combo boxes; create reports for printing and sharing; and take steps to maintain your database.
Topics include:
Creating a new database
Creating tables and new data types
Importing and entering data
Setting up relationships and primary keys
Adding validation rules
Sorting and filtering table data
Building queries
Designing forms
Creating reports
Maintaining an Access database
