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
Purchased AutoCad 2020! Was a speedly delivery of the Link and Key. Very happy using their services! Customer support was very friendly and fast. Great Job! Will utilize your service again should I need more digital software.
Andrew Zipkinz, AU
CorelDRAW Graphics Suite 2020 license key was sent within a few minutes of ordering. Complete instructions on downloading and activating were also included. Customer support responded promptly when I possessed a question. Very pleased!
Janet, GB
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.
Sandra C. Molden, CA
Professionalpany, low prices! Ease of purchase on the site, fast shipping time.
Alan Brynildsen, NO
A better price than Microsoft got exactly what I ordered at a great price! Was a pleasant shopping experience. Fast and easy to use store and checkout system.