Lynda - Office 365: Access Essential Training with Adam Wilbert (Update 22-09-2015)
English | 6+ Hours | .MP4 | aac, 48000 Hz, stereo | h264, yuv420p, 1280x720, 15.00 fps(r) | 1GB
Learn how to build databases to store and retrieve your data more efficiently in the Office 365 version of Access. Adam Wilbert shows how to use the powerful program to wrangle your data and create your first table, and he highlights smart strategies to edit and modify fields and records.
The course also shows you how to build queries and action queries, create and design forms, use macros, integrate Access with the rest of the Office 365 suite, and maintain your databases over time.
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
Attaching macros to buttons and tables
Working with Excel and Outlook data
Maintaining an Access database