Lynda.com - Access 2013 Essential Training
System Requirements: Windows
- Codecs and player for playing mov-files.
Access 2013 Essential Training with Adam Wilbert
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 relationshipsSetting primary and foreign keysEstablishing relationships and maintaining referential integritySorting and filtering dataBuilding queries with constraints and criteriaEditing table data with queriesGenerating forms from tablesAdding form controlsCreating reports with totals and labelsEmbedding macros in buttonsRepairing your databaseProtecting databases with passwords
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 relationshipsSetting primary and foreign keysEstablishing relationships and maintaining referential integritySorting and filtering dataBuilding queries with constraints and criteriaEditing table data with queriesGenerating forms from tablesAdding form controlsCreating reports with totals and labelsEmbedding macros in buttonsRepairing your databaseProtecting databases with passwords
Features
Subjects
Business, Computer Skills (Windows), Databases
Software
Access, Office, Office 365
Author
Adam Wilbert
What customers say
The rating for Customer Support doesn't do the guys justice! I had a niggling problem with the installation and they supported me through the entire process. In the end they did a remote install - problem fixed! Very happy with the outstanding service they provided. Thanks again guys.
A very pleasant experience, indeed! Very helpful support team, replying promptly to my concerns and queries Will buy any software I need from here. Thank you once again, Dr Sam Cherian
As long as the buyer carefully reads the download and installation instructions there should be no problems. Once installed the Access 2010 that I purchases interfaced seamlessly with my other Office 2010 programs.
I'm very happy with the way everything went during buying and installation. Everything went smooth and the guidance video was very helpful and easy to understand.
I am happy to say that my computer has the product I purchased and is working well. Thank you so much for caring and following up. I will be a repeat customer just for that :)
Once again, please let me thank you for your prompt and attentive service. I look forward to working with your company in the future. Sincerely, Kerry Kracht
I appreciate the help the support team provided with the installation on my computer. The tech spent well over three hours trying to get the product installed and the licensing handled. We went through numerous restarts and they always responded promptly after I sent a password for the remote access to my computer. I will highly recommend your company to others for software purchase. Thanks again.