Office 365: Access Essential Training With Adam Wilbert

[xidau123 13]

 

Office 365: Access Essential Training With Adam Wilbert

5h 4m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch | 590MB

Genre: eLearning | Beginner | Language: English

 

Join 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

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.