Viewers: in countries Watching now:
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.
(music playing) Hi! My name is Adam Wilbert and I would like to welcome you to Access 2013 Essential Training. We'll start by taking a look at what makes the relational database work, and how moving your information into Access can help make you more efficient with your time and with your data. We'll build tables to store our data and attach rules to help minimize data entry errors in order to ensure that our data remains consistent and reliable. Next, I'll introduce Queries, a powerful way to find, filter and sort your data in order to reveal exactly the information you need precisely when you need it.
With forms we'll create a main user interface to your database. We'll build custom interactive elements with buttons and combo boxes to help us populate a database with data, and move around to accomplish different tasks efficiently. Reports will help us create a structure for printed documents and allow us to easily share insights about the data. And finally, Macros will help us automate tasks and keep everything running smoothly. So thank you for joining me in Access 2013 Essential Training.
There are currently no FAQs about Access 2013 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.