Intermediate Microsoft Access 2010

Code: COMP1115

Course description

Do you have experience building Microsoft Access 2010 databases, but want to take your skills to the next level? In this course, you'll build an entire database project from scratch. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information. You'll start by learning how to create your new database by importing information from Excel spreadsheets into tables. Using action queries, you'll add and update key fields that allow you to build relationships among the tables. Then you'll master the steps for building complex yet easy-to-use forms to manage table data. The course offers you tips and techniques for optimizing your database, 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 you queries more effective. Once you've built your database, you'll examine how to build reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. 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: 2
Prerequisites: None
Corequisites: None

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.

Credit transfer

Have you taken this course or an equivalent course?
Contact the Credit Transfer Office.

 
Start Date
Day/Time
Delivery
Campus
Cost
Availability
Start Date: Mar. 13, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: May. 13, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

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

Start Date: Apr. 17, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Jun. 17, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

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

Start Date: May. 15, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Jul. 15, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

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

Start Date: Jun. 12, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Aug. 12, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

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

Start Date: Jul. 17, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Sep. 16, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

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

Start Date: Aug. 14, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Oct. 14, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

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

Not all courses are offered each term. Spring 2019 registration opens February 4, 2019. Fall 2019 registration opens July 8, 2019.