Do you want to take your Microsoft Access 2013 skills to the next level? In this course, you'll learn how to use this program's advanced features to build a fully functional database from scratch.
You'll start by creating your new database as you import customer and order information from several Excel spreadsheets into tables. Using action queries, you'll add key fields to the tables and learn to build table relationships between the tables.
Next, you'll learn how to build complex yet easy-to-use forms to manage table data. You'll gain tips for adding the information you need without overcrowding your forms, including ways to build crosstab and summary queries so you can access information quickly and easily. You'll also learn about outer table joins that can make your queries more effective.
Once you've built your database, you'll discover how to create reports using conditional formatting to highlight key data points. You'll also explore Visual Basic and learn how to create a report dialog box so users can filter report data. Finally, you'll put the finishing touches on your database as you build a navigation form to make it easy for your users to find what they need.
About The Instructor
Ken Cook has built and managed a successful computer consulting business (now called Cook Software Solutions, LLC) since 1990. He began as a trainer instructing numerous users on a variety of software packages, specializing in Microsoft Office. Currently, he continues to train, but his main focus is creating expert Microsoft Office solutions, Microsoft Access database solutions, and Microsoft SQL Server solutions for Fortune 500 and small business clients. Ken is also co-author (with Laurie Ulrich Fuller) of Access 2007 for Dummies, Access 2010 for Dummies, Access 2013 for Dummies, and Access 2016 for Dummies, published by Wiley.