Microsoft Access 2007 Intermediate

Quick Facts

Delivery Method Online
Professional Certificate
24hrs Suggested Study Time
3 Months Access
Tutor Support
Study On Any Device
3097 Students

Expand your Microsoft Access 2007 skills to build better, more user-friendly Access databases.

Microsoft Access 2007 database developers need the technical knowledge and skills to design databases that use multiple related tables. At the same time, good developers must know how to hide some of these underlying complexities so their completed products are pleasant to use.

In this course, you'll master the tools and techniques required to create user-friendly Access 2007 databases. You'll learn to design one-to-many and many-to-many databases and create queries, forms, and reports to reflect those relationships. You'll find out how to create a switchboard form, change database settings, and use macros to make a database easy and intuitive enough for even a computer novice to use.

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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!

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.

Alan Simpson

With over 100 published books to his name, award-winning author Alan Simpson is widely regarded as a computer and Internet guru. His books have been published throughout the world in over a dozen languages. Alan is a seasoned veteran of the comput... Read more

Read Alan Simpson's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

The Learning Environment

From the moment that you enrol in the Microsoft Access 2007 Intermediate you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

Get The Personal Support You Deserve

At Vibe Learning, we're real people who are dedicated to providing you with personal support every step of the way. Our industry experts are not only professional and knowledgeable but also incredibly passionate about sharing their expertise with you. With their guidance, you'll gain invaluable insights and practical knowledge to help you succeed.

Still looking?

Check out the following courses related to Microsoft Access 2007 Intermediate:

Microsoft Access 2007 Fundamentals

Microsoft Access 2010 Fundamentals

ASP.NET Fundamentals

Database Development Fundamentals

Discover more online courses

Microsoft Access 2007 Intermediate

$599

$389AUD

Save 35%

Explore Creative Classrooms

Now Only

$389

AUD

35% off

$599 AUD

Quick Facts

Delivery Method Online
Professional Certificate
24hrs Suggested Study Time
3 Months Access
Tutor Support
Study On Any Device
5326 Students

Enrich your teaching talents and encourage your students' creative thinking as you learn to turn your classroom into a creative classroom.

Creativity will abound in your classroom as you tap your students' hidden talents. Learn how to use creativity to teach reading, writing, visual arts, performing arts, social studies, science, mathematics, and physical and health education. Develop creative new approaches to field trips, learning labs, activities, exercises, assignments, and evaluation methods. Think beyond the textbook and challenge your students by making your classroom a creative classroom!

Are you a creative teacher? Today, we're going to analyze the traits that creative teachers share and explore how you can apply these traits to your classroom. Then we'll exercise our minds by using brainstorming to transform everyday classroom routines into creative learning opportunities!

Can you encourage your students to be more creative? Today, you'll discover how to find your students' creative talents and even recognize students' hidden talents. You'll learn to be a creativity encourager and prepare yourself to help all students become creative thinkers and learners. We'll also examine how thinking relates to creativity, how to teach students about how they learn, and how to use questioning to initiate the creative process.

Does your classroom learning environment encourage creativity? In this lesson, we're going to explore whether your classroom is nurturing or neglecting creativity. I'll provide you with the tools you need to make your classroom a creative classroom—a learning environment that inspires, encourages, and promotes creativity! We'll also explore how to create classroom rules and objectives that encourage creativity, as well as creative testing and grading.

Can you create a space for creative learning in your classroom? Imagine a classroom where students learn about reading, writing, plants, animals, and mathematics at the same time, with learning taking place throughout the classroom. It's time to set up creative learning labs in your classroom, and in this lesson, we'll go over everything you need to know! You'll learn how to design creative learning labs for different learning styles, create themed-based learning labs, and best yet, find grants and other resources that can help you turn your learning lab ideas into realities.

How do you encourage reluctant readers and motivate creative students? In this lesson, we'll go over many creative techniques you can use to transform reading reluctance into enthusiasm. We'll explore ways to liven up those everyday reading assignments and make books come to life through creative reading. We're going to open our books and teach students to read, respond, remember, and relate—using creativity as our tool!

What happens when students can't write? In this lesson, we'll take a look at creative ways to eliminate your students' writer's block and encourage them to write creatively. After we get our students' pencils moving, it's time to fine-tune their writing skills with some creative assignments that will challenge them, encourage them, and make them enjoy writing, even if they can't yet write their names. We'll also explore freewriting, dramatizing, imaginative writing, and writing circles.

How do you encourage creative thought through art? Even if you don't consider yourself to be an artist, you can teach your students to create art and use creativity. In this lesson, you'll learn how the process of creating produces creative art. We'll talk about how to help students turn those early art creations into classroom masterpieces as we explore creative ways to introduce drawing and painting. Then we'll turn our classrooms into art museums for displaying mixed media creations. After that, grab your easels because we'll be taking art into our writing, math, and history lessons, too.

So what does it take to get a student interested in music and acting? In this lesson, you'll learn how to put students on stage—a friendly stage, a creative stage. We'll explore how to creatively teach music and drama through self-expression and how to provoke student interest in the performing arts across the curriculum. Some of the techniques we'll discuss include using self-expression in music—using mime, identifying with instruments, even thinking musical moods. And when we go into acting, you'll learn creative methods you can use to teach students to determine characters' emotions, create costumes, and create sets.

Is science creative? Through problem solving, scientists find answers by using some very creative techniques. In this lesson, you'll find out how to turn your creative students into creative scientists. We'll start by exploring the scientific method and how to use it in all your classes. We'll discuss using scientific knowledge in our everyday routines, like classroom discipline and testing, and then we'll take science out of the classroom as we explore some creative labs and field trips. Grab your lab coats, microscopes, and lab notes and prepare to think creatively!

How do you make a connection to the world from inside your classroom walls? In a world full of facts and figures, there are creative ways to make these items real. In this lesson, you'll learn creative ways to teach students to analyze, interpret, and be active participants in the subjects they're studying. We'll start by relating social studies to your students' lives by using the social studies connections in your classroom: the school's chain of command, classroom rules, and collaborative learning. We'll also use critical thinking to analyze social studies textbooks, and we'll create social studies learning labs and field trips.

Can math be fun and creative? In this lesson, we'll look at ways to make mathematical challenges fun through problem solving. We'll make math engaging, creative, and fun by organizing math field days, and we'll look at ways you can help your students relate their everyday lives to math through math learning labs, field trips, and much more!

Can you imagine a classroom of students eager to participate in physical activity? Good, because imagination is the key! In our final lesson, you'll learn how to get students moving by helping them to use their imaginations. You'll learn about creative movement, creative team games, creative cooperative games, and creative assessment. You'll also learn creative ways to keep your students healthy as they promote healthy topics and flex their creative muscles. You'll also learn how to use conflict-solving techniques that will teach students to think of creative solutions for their problems.

Robin Sellers

Robin Sellers is a certified teacher with a Master of Arts degree with a concentration in Technical and Professional Communication. She has over 11 years of experience in the traditional classroom and has been an online instructor since 2000, trai... Read more

Read Robin Sellers's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

What people are saying about our courses

I am a licensed teacher staying home with my children. I am taking classes for licensure renewal. I am currently homeschooling my third grader and first grader. This class was perfect. I have applied many of the ideas in our school day.

Verified Student

I am an Art major and think myself to be fairly creative. I was impressed with your very practical uses of creativity for the core subjects. Your ideas will help me, since I also have to teach these subjects. Thank you for the over-all coverage of elementary curriculum.

Verified Student

I found this course to be interesting and useful. There were lots of great ideas presented that will be easy to incorporate into any classroom. All of the resources included in the supplementary material will be a great help.

Verified Student

See More Reviews

The Learning Environment

From the moment that you enrol in the Explore Creative Classrooms you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Ready to get started?

Enrol Now