Office 365: Access Essential Training with Adam Wilbert (2015)-0daytown

Office 365: Access Essential Training with Adam Wilbert (2015)

MP4 | AVC 148kbps | English | 1280×720 | 15ps | 5h 04mins | AAC stereo 128kbps | 622 MB

Genre: Video Training

oin author and database expert Adam Wilbert on a tour of the essential features of Microsoft Access 2013, the database application included with every Office 365 subscription, and discover how to store, organize, and access your data more efficiently. First, Adam explains the concepts behind relational databases, before moving on to building tables—the foundation of any database. He then shows how to define the relationships between tables and use queries to find and filter data. The course also shows how to apply rules and validation to minimize data-entry errors; use forms to build a database interface complete with interactive buttons and combo boxes; create reports for printing and sharing; and automate these tasks, and many others, with macros.

Topics include:
Understanding table structures and relationships
Setting primary and foreign keys
Establishing relationships and maintaining referential integrity
Sorting and filtering data
Building queries with constraints and criteria
Editing table data with queries
Generating forms from tables
Adding form controls
Creating reports with totals and labels
Embedding macros in buttons
Repairing your database
Protecting databases with passwords