About this course
Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for using this powerful database program, and build an entire database project from scratch.
You'll start by importing customer and order information from several Excel spreadsheets as tables in a new database. You'll learn how to add key fields to these tables, update their fields using action queries, and build relationships between the tables.
Once you've mastered proper table construction, you'll build on that knowledge by learning how to create forms to manage table data. You'll discover how to construct crosstab and summary queries, and crunch numbers using query calculations. You'll also learn about outer table joins that can make your queries more effective.
From building reports to using conditional formatting, you'll see how to present your data and learn to use Visual Basic to automate common tasks. Finally, you'll build a navigation form to make it easy for your users to find their way around your database. By the time you've completed this course, you'll have created a fully functional database that tracks customer and order information.
Offered to: Public
Cost: 190 + tax
Time requirement: 6 weeks + 2 weeks to complete final exam