Microsoft Access 2010 Intermediate

Quick Facts

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

Learn how to build more intuitive and powerful Microsoft Access 2010 databases.

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 optimising 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.

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.

In this first lesson, we’ll review Access key concepts and terminology. You’ll also learn how to import, or share, data between Access and other applications without retyping. The objects you import in this lesson will be the basis of a project that we’ll work on for the rest of the course.

Today you’ll learn how to set up key fields in tables, plus you’ll use action queries to quickly and easily manipulate multiple-table records with one command.

What are table relationships? And what does referential integrity mean? It’s time to find out how and why to use these features.

Forms are the user-friendly gateway to Access table data. In this lesson, you'll learn how to create and modify forms and make them easy to use.

In this lesson, you’ll learn how to create a subform without the wizard, and you’ll use the Tab control to arrange form data.

You’ve already learned to put data into your database in an efficient way. In this lesson, you’ll learn about query joins and data functions. These tools will help you get timely, high-quality data out of your database, so you see all the data you want and none of the data you don’t want.

Suppose your boss tells you, “I want a list of the customers who placed the most orders and a separate list of the customers who spent the most overall.” How can you find these answers quickly and accurately? Access comes to your rescue again! In this lesson, you’ll explore Access functions, crunch numbers with the best of them, and even design a mathematical formula of your own. And don’t worry if math makes you nervous . . . I’ll walk you through every step!

In this lesson, you’ll build powerful, fast summary queries that total, count, or average the values in a set of records. You’ll also discover the power of the crosstab query, which can not only summarize data but also rearrange it so that it becomes easier to understand. Finally, you’ll add query parameters that allow you to change a query’s criteria without altering its design.

Today you'll use the Report Wizard to build a basic report. Then you'll fine-tune what you've built, and I'll share some tips and tricks I've developed after building thousands of Access reports. Finally, you'll learn about a fantastic tool—conditional formatting, which allows you to visually identify key report data. With a few clicks, your report will change from a mass of numbers to a map of trends and changes that affect your business.

Just about every time you run a report, you'll want to limit the data it displays. You might want to see only a certain customer or a particular month and year. In this lesson, you'll build a dialog box that allows the user to run reports based on custom-built criteria.

Visual Basic is a powerful programming language that allows database developers to automate simple and complex tasks. In this lesson, you'll learn a little bit about Visual Basic, using it to make the reports dialog box you built in Lesson 10 fully functional.

If you're creating a database for others, you must make it easy to use—and as you may remember, Access can look intimidating to a newbie! In this lesson, you'll build a navigation form that directs users to the forms and reports they need. You'll also set up a database for shared use and modify the start-up options.

Ken Cook

Ken Cook has built and managed a successful computer consulting business (now called Cook Software Solutions, LLC) since 1990. He began as a trainer specialising in Microsoft Office and has helped numerous users (too many to count!) master a varie... Read more

Read Ken Cook'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.

What people are saying about our courses

Verified Student

This course enabled me to understand the databases that I deal with on a daily basis much better. I now can name the elements of the database our organization that I thought could be improved for easier, more efficient use! Wow, I've come a long way! Thanks!

Verified Student

This was an excellent, outstanding course! I have been using Access for a very long time and have designed and built a number of databases. I wish I had some of the knowledge gained in this course, a long time ago. I picked up quite a few tips for fine-tuning the design.

Verified Student

See More Reviews

The Learning Environment

From the moment that you enrol in the Microsoft Access 2010 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 2010 Intermediate:

Microsoft Access 2010 Fundamentals

Microsoft Access 2007 Fundamentals

Microsoft Access 2007 Intermediate

Database Development Fundamentals

Microsoft Word 2010 Fundamentals

Discover more online courses

Microsoft Access 2010 Intermediate

$599

$389AUD

Save 35%

Understanding the Cloud

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
23 Students

Learn everything you need to truly understand the cloud; including how it works, what drives it, why it's so popular, and how to make the cloud work for you.

What is the cloud? If you have trouble answering this question, you're not alone. In this course, we'll explore how the cloud works, what drives its incredible growth, and how you can use cloud services. And don't worry if you're not tech-savvy! We'll relate the cloud to things you encounter every day, using practical, non-technical language.

We'll start by looking at the building blocks of the cloud, where it started, and how it transitioned from an experiment into an unstoppable force. You'll also gain a clear understanding of IaaS, SaaS, and PaaS, and see why each may be attractive to some businesses, but not others. And you'll learn about the different kinds of clouds (public, private, and hybrid).

We'll also take an inside look at the engine rooms of the cloud: data centers. You'll examine the concept of big dataâ€•the overwhelmingly huge amounts of data that make analysis so challengingâ€”and how the cloud infrastructure enables data to zip across the globe at lightning speed.

Social networking has also played an incredibly important role in the growth of the cloud. We'll examine how Facebook and Twitter contribute to the cloud, and how apps go from idea to app store. You'll gain an understanding of how mobile devices and major mobile ecosystemsâ€•like Apple, Android, and Windowsâ€•continue to shape the cloud, and how start-ups can use social media to shake things up like never before.

So come see how the how the cloud can work for you! Whatever your technical background, by the end of this course, you'll be thoroughly cloud-savvy.

Confused about the cloud? You're in the right place! In this first lesson, we'll clear up some confusion and start with the basics. I'll explain the building blocks of the cloud, and that will lead us to a durable definition of the cloud that you'll use as a foundation for the rest of the course. We'll also discuss what the cloud means to you, its impact on your life, and why it'll be helpful for you to understand how it works.

So how did the cloud get started? In this lesson, you'll learn the history of the cloud and how it was a natural evolution of networked computers and Internet connectivity. We'll also discuss why the cloud is so important, and we'll look at the business challenges and opportunities that the cloud addresses. By the end of this lesson, you'll have a solid understanding of how we got to where we are and how business computing operated before the cloud.

Ever wonder why some people believe the cloud is simple, while others believe it's complex? In this lesson, you'll learn why they're both right—and you'll learn how to think about the cloud from two perspectives. We'll also discuss the different types of clouds: public, private, and hybrid. And you'll get a glimpse inside the big business technology world and find out why the cloud can be such a compelling move for large organizations.

What's the difference between the cloud and a collection of computers? A bunch—and much of that comes down to virtualization. In this lesson, you'll learn what virtualization is and why it's so fundamental in how the cloud operates. We'll also discuss scale and how it relates to virtualization. Finally, you'll see how endpoints make all the connections work. Let's get started!

If you'll recall, services is one of the five building blocks in our definition of the cloud. In this lesson, we'll look at those services. Specifically, we'll discuss three categories of cloud services: infrastructure (or Infrastructure as a Service, or IaaS), platforms (or Platform as a Service, or PaaS), and software (or Software as a Service, or SaaS). We'll discuss how these three categories compare and individuals and business can take advantage of them.

All the computing power of the cloud needs to live somewhere, and it's not in the atmosphere. In this lesson, you'll learn all about data centers—how they operate, what they look like, where they're located, and what makes them tick. You'll also learn what makes one data center more efficient than another, and you'll get perspective on what it costs to make them operate. It's a fascinating tour, with a lot to learn and even more to explore, so let's jump in!

Our experience in the cloud includes the storing and transmission of data, either across the hall or across the world. In this lesson, you'll understand how to think about data in terms of its importance in the cloud, and you'll also learn why we often leave worrying about data to someone else. We'll discuss how all the data in the cloud moves across continents, across the ocean, and over airwaves. And we'll also look at a clear definition of big data in this lesson, as well as examples of where big data may be headed.

Making sense of how cloud providers offer their services is an important step in truly understanding the cloud. In this lesson, you'll see how a well-established cloud provider organizes and presents its offerings. We'll go through each group of the cloud provider's offered services, and we'll map them to what you've already learned about the cloud and the categories you're familiar with.

In this lesson, you'll learn where websites fit into the cloud and what other elements, offerings, or activities are driving the adoption and popularity of the cloud and its varied services. We'll also discuss what it means to be a big provider, and we'll examine the largest platforms—and largest overall service providers—that are in the cloud today.

Learn about what goes into creating a cloud app, and how the three (plus one) ecosystems dominate the world of cloud applications. In this lesson, you also learn about the different types of devices, how they are categorized, and how they align to the types of cloud apps that are available. You'll also learn about ecosystems, and why they define how cloud apps are created, distributed, and sold.

Today we're going to look at how social network sites like Facebook, LinkedIn, and Twitter work in the cloud and how users and organizations can create apps that connect with their huge base of users. You'll learn how social media sites let software developers interact with their sites, create apps and games that operate within and outside their sites, and why they do this. Also, you'll learn about social media tools on Facebook and in Twitter, including why the hashtag was created (#), how it's used, and how to use these sites yourself.

This lesson ties together everything you've learned in this course. You'll learn how we can view the cloud from two primary perspectives—consumer and business—and we'll distill the primary benefits (and drivers) that have propelled cloud adoption from participants of both perspectives. We'll also discuss where these two perspectives share a common, clear force that continues to be the biggest benefit of the cloud. And finally, we'll look into the future of what the cloud may hold and what that future might mean for each of us.

David Iseminger

David Iseminger is a computer and networking expert and an experienced teacher of networking topics. As a student first and expert second, Iseminger knows which teaching approaches are most effective. Iseminger has worked at Microsoft Corporation ... Read more

Read David Iseminger'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.

The Learning Environment

From the moment that you enrol in the Understanding the Cloud 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