Do you want to take your Microsoft Access skills to the next level? In this in-depth course, you will learn to use the more advanced features of Microsoft’s longstanding information management software.
You will start by importing customer and order information from several Excel spreadsheets as tables in a new database. Once you have mastered proper table construction, you will build on that knowledge and learn how to create forms to manage table data. Then, you will discover how to construct crosstab and summary queries, and crunch numbers using query calculations. Finally, you will build a navigation form, so users can search your database.
By the time you complete the course, you will have a fully functional database that tracks customer and order information.
About The Instructor
Ken Cook has managed his own successful computer consulting business since 1990. He began as a trainer, instructing numerous users on a variety of software packages, specializing in Microsoft Office. Currently, 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. He is also co-author of four “Access for Dummies” books.