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
Great product, had a problem initially downloading, emailed customer services, they responded within two hours giving me a detailed work list, it worked, I now have office 2010 and I am thrilled with it. I will certainly use this software store in the future. Thanks Guys.
Although I had a problem with the download, the support team helped me immediately and the problem was solved. Thank you, I am a satisfied customer.
I thank you for all the help and patience that you have given me and I do feel that I have been a bit of a nuisance with my many requests for help. All the team have been so helpful and polite that I will certainly buy any future software that I require from you. Also your rapid response to requests is second to none and I applaud you for it.
I was delighted to find InDesign at such a great price and equally as pleased at how quickly I could download it and use it. It's been with me 3 days and I've already designed a brochure! Your site has a very prominent bookmark on my browser.
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 recommend everyone who wants to own a very reliable original Photoshop copy, to get it from here without even a little hesitation ... thank you for providing us with this. I wish you all the best. I give this website and the program as well 5 if not 10 stars.
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.