Microsoft Access 2010 Fundamentals

Picture of Microsoft Access 2010 Fundamentals
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 5566 Students

Learn to build, edit, and maintain a database in Access 2010, using tables, reports, forms, and queries to give you fast access to all your important information.

Take control over your data! Whether you're a novice or an experienced database user, this course will show you how to harness the full power of Microsoft Access 2010.

In these practical and project-oriented lessons, you'll learn how to use this award-winning MS Office software to create and customise tables. You'll build relationships between your tables to eliminate redundancies and slash data entry time. And you'll discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks.

In addition, you'll find out how to make your database more user-friendly with custom data entry forms, smart lists, and other sophisticated controls. You'll learn how to retrieve exactly what you need from your database with powerful queries and reports, and you'll even start automating routine tasks with labor-saving macros.

By the time you've finished this course, you'll know how to create an effective database for any information you need to store, document, and manage—at home or on the job.

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 lesson, you&rsquo;ll find out what Access is and how individuals, businesses, and organizations use it to store information. You&rsquo;ll begin to build an Access database . . . including all the components that turn a list of records into reports, forms, and queries. We&rsquo;ll start by opening the application and creating a new database. <b></b>

It&rsquo;s time to lay down the law! Today you&rsquo;ll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. Also, you&rsquo;ll set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-free.

Today you&rsquo;ll create additional tables for&nbsp;our class&nbsp;database, customizing them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

In this lesson, you&rsquo;ll use forms for data entry and for viewing records in your tables. You&rsquo;ll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables&rsquo; fields to include. You&rsquo;ll also determine form layout.

In this lesson, you&rsquo;ll add buttons and controls to forms. You&rsquo;ll also adjust table relationships to support the creation of multi-table forms . . . which paves the way to creating queries and reports that draw data from more than one table.

Using queries to sort, filter, and search your database is one of the most important skills you&rsquo;ll master in this course. In this lesson, you&rsquo;ll create queries that search for specific data. You&rsquo;ll also customize how Access displays that data. You&rsquo;ll follow instructions step by step, so you gain confidence with the process; then I&rsquo;ll turn you loose to create a query on your own.

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won&rsquo;t help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won&rsquo;t help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you&rsquo;ll create queries that give you true power to search your database.

In this lesson, you&rsquo;ll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Reports are easy to create and to customize. In this lesson, you&rsquo;ll build a simple report using the Report Wizard. Then you&rsquo;ll change the report&rsquo;s appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need, on any data in your database.

In this lesson, you&rsquo;ll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query&rsquo;s criteria. This makes truly customized reporting possible&mdash;and quite simple.

In this lesson, you&rsquo;ll plan and create a completely customized report, using a specialized query that controls which data the report includes. You&rsquo;ll add fields that perform calculations on your data. You&rsquo;ll customize your report&rsquo;s layout, too, using design view&rsquo;s many tools for controlling the structure and appearance of your data.

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

Laurie Fuller

Laurie Fuller

Laurie Fuller has been teaching people to use computers, software, and the Internet for more than 15 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30... Read more

 Read Laurie Fuller'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

This was the most organized and helpful computer class I have ever taken.  I appreciate your patience, humor and clear directions, Laurie.  I am sure it will help me with an Access-based work database that I have to tend and feed when school starts again.  I also will be recommending this to others at work.
Verified Student
Thank You very much for a very well put together introductory class.  What I liked best is that you always included tips on how to take things one step further, or how to change items to match other requirements.  I learned not only how to use a function, but how to apply it in different environments.
I will now be able to confidently use Access for many applications.  Being able to do these lessons on my own schedule was a tremendous plus! Keep up the great work!
Verified Student
The use of the videos is extremely helpful when we get into more technical areas. I have been self-taught in Access and know only the information I need to - to get the job done. However, I learned a great deal and look forward to the intermediate course available. Thank you. This is the first experience our company has had in online training (6 of us are in training right now) and it is very convenient, affordable and well worth the time. You seemed to be very experienced and also do a very good job explaining the topic in your videos.
Verified Student
See More Reviews

The Learning Environment

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

Discover more online courses

Recently viewed products

Picture of Microsoft Access 2010 Fundamentals

Microsoft Access 2010 Fundamentals

$599
$389AUD
Save 35%
Microsoft Word 2010 Intermediate Online Course | Vibe Learning
 

Microsoft Word 2010 Intermediate

Picture of Microsoft Word 2010 Intermediate
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 3012 Students

Master the more advanced features of Microsoft Word 2010 and learn how to create an index, build a list of figures, design a table of contents, do desktop publishing, perform a mail merge, and use timesaving shortcuts.

Microsoft Word 2010 is a powerful and popular program, yet most people use only a fraction of its features. In this course, you'll learn Microsoft Word's more advanced features, which can make writing easier, faster, and more fun. You'll improve your creativity and efficiency at the same time!

In the first part of the course, you'lllearn how to perform a mail merge, and we'll explore shortcuts, styles, and templates. Shortcut keys and macros let you type repetitive words and phrases quickly and accurately at the touch of a button. Styles let you save text formatting. Templates let you create documents that contain predefined formatting and text, making it a snap to create documents that look right every time.

In the second part of the course, we'll cover how to use Word as a simple desktop publishing program to create signs, flyers, menus, brochures, and even newsletters. You'll learn how to insert different types of graphics in a document including digital photographs from your own camera, clip art images provided by Microsoft, and different types of charts such as bar, line, or pie charts.

Next, you'll find out how to wrap text around graphic images and divide a page into columns and text boxes. Both columns and text boxes give you different ways to display text beyond the traditional appearance of text that fills an entire page.

Finally, in the last part of this course, you'll learn about printing labels, making form letters, and creating an index, table of contents, and list of figures automatically. If you need to create long documents, you'll appreciate Word's ability to keep track of page numbers for your chapter headings or index entries.

Whether you need to produce a short letter, flyer, report, or book-length manuscript, this course will teach you how to get the most out of Microsoft Word 2010!

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.

We've come a long way since the days of the typewriter. What used to take hours can now be done in seconds with Microsoft Word 2010. And the less time you spend typing, the more time you can spend being creative and having fun. In this lesson, you'll learn shortcuts in Word that can help you create documents faster and more accurately than ever before. Not only will these shortcuts save you time, but they'll help you create letters and reports more easily than you might have thought possible.

What you write is half of communication. The other half is getting people to read what you write. One way to make your writing more appealing is to make it look presentable with formatting. Of course, formatting text is easy, but applying different types of formatting over and over again can get tedious. That's why today you'll learn a fast and easy way to format chunks of text quickly and consistently using something called <i>styles</i>. You'll find out what a style is, how to apply it, and more important, how to create and save your own styles to use in any document. By the end of this lesson, you'll be able to make any document look presentable with just the click of your mouse.

If you've ever baked cookies, or even just watched someone else do it, you know how difficult it can be to make all the cookies in a batch look exactly alike. Some turn out big, some small, some gooey, and some burned! However, if you use a cookie cutter, you can make identically shaped cookies every time. That's the same principle you'll learn in this lesson, instead of using a cookie cutter, though, you'll use something called a <i>template</i>. A template stores the formatting of a document so you can apply it to another document. Templates let you format entire documents as easily as formatting a single word. Word offers lots of convenient templates stored right on your computer or available over the Internet, and you'll also find out how you can create your own.

They say a picture is worth a thousand words, so what better way to spice up your documents than by adding pictures? Today, you'll learn how to add your own digital photographs to a document so you can show everyone your vacation pictures, family holidays, or just interesting sights you've captured with your own camera. In addition to adding your own photos, you can also add clip art from Word's massive library of free graphics. And you'll find out how to resize, rotate, and style your pictures, as well as wrap your document text around them. By the end of this lesson, you'll see why Word documents are about much more than words!

Digital photographs and clip art are just the beginning of what you can do with graphics in Word. Today, you'll discover how to add a variety of informational graphics, including charts, graphs, and WordArt, which allows you to display text as a graphic image. Not only will you learn how to add these graphics, but you'll also find out how to edit them when your data changes. We'll finish off the lesson by seeing how Word allows us to format documents with multiple columns&mdash;a handy skill for creating newsletters and publications!

Do you often create long documents? If so, you'll appreciate this lesson, which shows you how to divide a large document into parts called sections. Sections allow you to format part of a document a certain way without that formatting effecting the rest of your text. For example, you may want headers and footers to appear on some pages but not others. Sections make this easy! We'll also spend some time inserting footnotes and endnotes in a document. If you need to write research papers or other academic content, Word makes it a snap to add and format these previously pesky notes!

If you've ever seen a spreadsheet, you know how rows and columns let you organize numbers and text on the screen. Well, tables do the same thing in Word. In this lesson, you'll see how to create tables of all different sizes right in a Word document! We'll cover how to modify tables, too. And don't think Excel users get to have all the fun&mdash;you can even enter formulas to perform calculations in your tables, sort them, and style them for a customized look. Your data has never looked so appealing!

You probably print most of your documents on standard letter-size paper. While this is great for ordinary letters or business reports, sometimes you may want to get creative with your paper sizes. But then there's the trouble of printing. In this lesson, you'll see how you can define the dimensions of the paper you're using so Word will print everything correctly. You'll also learn how to print names and addresses directly on envelopes of any size. After this lesson, you won't feel confined to boring 8 1/2 x 11-inch paper anymore!

As you've probably already figured out, Word can do more than write letters. It can also function as a simple desktop publishing program for creating greeting cards, calendars, or newsletters. Today, you'll find out how text boxes are the key to simple desktop publishing, and you'll see how other elements come into play in customized documents. Along the way, we'll look at business cards and greeting cards to get a feel for how desktop publishing works. If you've always wanted to create a document that combines text and graphics in an artistic or visually appealing way, you'll find out how to do that and much more.

With the basics down, it's time to take our desktop publishing skills to the next level. Today, you'll discover the magic of linked text boxes that give you the power to move your text anywhere you want on the page and keep it flowing. You'll see how to create, position, resize, and group text boxes so you have total control over your text.

Did you ever get one of those "personalized" letters from a company in the mail? You can be sure that nobody typed the entire sales letter from scratch. Instead, the company used a form letter and something called mail merging. In this lesson, you'll learn how to store long lists of names and addresses that you can use over and over again in a form letter. Just create a document once, leave blanks for inserting information such as names and addresses, and let Word personalize each letter for you. Now you, too, can create personalized letters for business or personal use, such as sending out holiday greetings to family members and friends.

Look in most books, and you'll find a table of contents at the beginning and an index in the back. Often, these are the last components added to a document, since they need to have accurate titles and page numbers. But Word takes a lot of the tedious work out of creating these components. In this final lesson, you'll see how you can use Styles to make creating a table of contents a snap, and we'll explore how to tag index terms so Word knows what page they're on, even if they move later. Word can also help you keep track of any figures, such as charts, illustrations, or graphs, in your document. By letting Word worry about the details, you can create an accurate table of contents, index, or list of figures with very little extra effort on your part. These finishing touches will make your most important documents shine!

Wallace Wang

Wallace Wang

Wallace Wang is the author of over 40 computer books including "Microsoft Office 2007 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing i... Read more

 Read Wallace Wang'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

I really liked the course and the instructor. It was definitely more challenging than the introductory course. I would recommend this course to others if you really want to dig in to Microsoft Word and learn more about what it can do.
Verified Student
Thanks for providing a means of learning that is convenient, thorough and easy to understand!
Verified Student
This is the first online course I have ever taken and I liked it a lot. The teacher was thorough and made me feel like he really wants his students to get something out of it. Thanks!
Verified Student
See More Reviews

The Learning Environment

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

Discover more online courses

Recently viewed products

Picture of Microsoft Word 2010 Intermediate

Microsoft Word 2010 Intermediate

$599
$389AUD
Save 35%