| Course Title | Level | Duration | Released | ||
|---|---|---|---|---|---|
| Access 2007: Queries in Depth | Intermediate | 2h 8m | 09/2010 | {8} | |
| Access 2010: Queries in Depth | Intermediate | 3h 2m | 06/2011 | {8} | |
| Access 2007: Forms and Reports in Depth | Intermediate | 3h 37m | 02/2012 | {8} | |
| Access 2010: Forms and Reports in Depth | Intermediate | 3h 7m | 02/2012 | {8} | |
| Access 2013 Essential Training | Beginner | 5h 4m | 02/2013 | {8} | |
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
Learn more about lynda.com
Ready to join?
get started
Members who watched this also viewed
show more
