Intermediate Microsoft Access 2007

Intermediate Microsoft Access 2007

Middlesex County College

$99.00 Enroll Now!

Instructor-Led Course
Hours: 24
Duration of Access: 6 weeks
Start Dates: Dec 09, Jan 13, Feb 10, Mar 16
3,286 Students
have taken this course.


A new session of each course starts monthly. If enrolling in a series of two or more courses, please be sure to space the start date for each course at least two months apart.

Week 1

Lesson 01 - Getting Started


A database is a collection of data organized into multiple tables. In this lesson, you'll learn the importance of recognizing one-to-many relationships among the data your database will manage. You'll also discover how to create tables that reflect those relationships and create the first table for a sample working database that we'll build together throughout the course.

Lesson 02 - Designing a Database


Today, we'll dig deeper into database design and the natural one-to-many and many-to-many relationships among your data. You'll discover the importance of primary, foreign, and composite keys, and how to create them in your own databases. You'll get plenty of hands-on practice as we create more tables for our working sample database.

Week 2

Lesson 03 - Creating Forms


While tables provide a means of storing data, they don't offer much in the way of making a database user-friendly. For that, you need forms. In this lesson, you'll create a form for our working database and learn about the three ways to view forms: Form View, Layout View, and Design View. You'll start learning the tools and techniques the pros use to create attractive forms that are easy to use.

Lesson 04 - Advanced Form Design


Today's lesson will expand on the skills you learned in Lesson 3. Here you'll learn to move, size, and position multiple controls, choose colors and fonts, and more. You'll also find out how to test your forms and fix common problems. All of these skills will allow you to produce more professional-looking forms that make it easy to work with data in your database.

Week 3

Lesson 05 - Creating a One-to-Many Form


Today, we'll return to the topics of one-to-many and many-to-many relationships among tables and explore how they relate to forms. You'll build on the skills you've already acquired to create more complex one-to-many forms that reflect the one-to-many relationships among your data. You'll also discover the value of lookup queries and combo boxes, which make it easy for users for select data for fields without having to type it in from memory.

Lesson 06 - Mastering Object-Oriented Development


Virtually everything you create in Access is an object, and all objects have properties. Understanding that is key to successful database design and development. In this lesson, you'll discover what that's all about and see how you can use properties to gain more control over every aspect of your database. Along the way, you'll add more enhancements to our working database, making your forms more attractive, usable, and user-friendly.

Week 4

Lesson 07 - Sorting, Searching, and E-mail


Sorting and Searching are key ingredients of any database. Today, we'll cover new techniques for sorting form data without the complexities of creating queries. You'll give your form a Search Box that allows users to quickly locate data without the need for complex filters or queries. As an added bonus, you'll learn how to create links in a table for sending e-mail messages with a simple mouse click. And you'll find out some of the secrets of SQL, the Structured Query Language that makes all your queries work the way they do.

Lesson 08 - Attachments, Expressions, and More


Storing text and numbers in a database is easy. But what if you want to also store pictures, Word documents, or other external files? You can do that too, thanks to the Attachment data type. In this lesson, you'll learn all about attachments, including ways to use them in forms.

Week 5

Lesson 09 - Working With Access Reports


Forms are great for interacting with data on a computer screen, but sometimes you have to print data on paper, too. That's where reports come in. In today's lesson, you'll learn the tools and techniques for creating and formatting reports. You'll see how to control margins, spacing, page breaks, page orientation, and other important formatting features. And you'll get plenty of hands-on practice in using the report Layout View and Design View.

Lesson 10 - Creating a One-to-Many Report


Today, we'll keep working on the skills you learned in Lesson 9, creating a more complex one-to-many report. You'll see how to use a query to combine data from multiple tables, and you'll learn about calculated controls on reports. You'll also discover some important skills for showing subtotals and totals on your one-to-many forms.

Week 6

Lesson 11 - Make It User-Friendly


By now, you've created many database objects. Eventually, you may have to hand that database over to less knowledgeable users who won't know what to do with all those tables, queries, forms, and reports. Fortunately, they don't need to. As you'll discover in this lesson, you can hide all the complexities from those users. You'll learn to create a switchboard form that's so easy to use, your database users won't need any database expertise at all!

Lesson 12 - Enhance Your Database With Macros


In this, our final lesson, you'll discover still more tools and techniques for making your database more user-friendly. The star of this lesson will be Access macros, which pre-define actions that you can tie to a button click or other event to simplify things for your database users. You'll also learn how to create custom messages that explain things to users so you don't have to. You'll come away with a fully functional database that's easy enough for even a computer novice to operate.