Intermediate Microsoft Access 2013

Code: COMP1072

Course description

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.

Course details

Hours: 24
Credits: 1
Prerequisites: None
Corequisites: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

Notice for ed2go courses


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.


Dates
Day/Time
Delivery
Campus
Cost
Availability
Start Date: Jan. 12, 2022
End date: Mar. 14, 2022
Day/Time:
Campus: Online
Cost: $185.00
Start Date: Feb. 9, 2022
End date: Apr. 11, 2022
Day/Time:
Campus: Online
Cost: $185.00
Start Date: Mar. 16, 2022
End date: May. 16, 2022
Day/Time:
Campus: Online
Cost: $185.00

Registration dates

Not all courses are offered each term.

Spring 2022 registration opens February 7, 2022. Fall 2022 registration opens July 4, 2022.

Delivery options

In person: classes held in person on a campus/site in a classroom/lab/shop/studio for the course duration

Online - Asynchronous: ​100% online delivery with no assigned day or time requirements, independent course completion

Online - Synchronous: 100% online delivery with scheduled day and time course requirements

Hybrid: any combination of: in person, timetabled, on campus, online, and hyflex delivery