Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for 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 the tables, update these 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 gain techniques for using 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 the course, you'll have a fully functional database that tracks customer and order information.
ed2go online courses are designed for working professionals and those seeking to gain personal advancement. If you are enrolled in a program, carefully review the requirements of your program before registering to ensure the course code and title match the requirements in your program.
Classroom Delivery: In-person instruction that takes place at a college campus.
Online Delivery: Content is delivered entirely online through self-directed components, allowing you the flexibility to learn anytime from wherever you are.
Remote Delivery: Technology-enabled virtual instruction that takes place outside of a physical classroom. Remote delivery includes some form of scheduled real-time virtual classes or drop-in times, as well as self-directed components.
Hybrid Delivery: Instruction that includes a combination of online or remote delivery, and some classroom activities.
Not all courses are offered each term.Winter 2022 registration opens November 1, 2021. Spring 2022 registration opens February 7, 2022.