Jump to content
Sign in to follow this  
downtemplate

Lynda.com - Access 2013 Essential Training

Recommended Posts

e000d33a8e0c5baf984d4350bbd78171.jpeg

Access 2013 Essential Training

Duration: 5h 05m | Video: AVC (.flv) 960x540 15fps | Audio: AAC 48KHz stereo | 683 Mb

Level: Beginner | Language: English

Genre: eLearning

 

 

Join author and database expert Adam Wilbert on a tour of the essential features of Microsoft Access 2013 and discover how to build a database and store your data more efficiently. First, Adam explains the concepts behind relational databases, before moving onto 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; build an interface for the database from forms, 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

 

Screenshot

62129c82643acc71add0605bd38d62f8.jpg

Hidden Content

    Give reaction to this post to see the hidden content.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...