Microsoft Access 2010 Intermediate

Picture of 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&rsquo;ll review Access key concepts and terminology. You&rsquo;ll also learn how to <i>import</i>, 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&rsquo;ll work on for the rest of the course.

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

What are table relationships? And what does <i>referential integrity</i> mean? It&rsquo;s&nbsp;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&rsquo;ll learn how to create a subform without the wizard, and you&rsquo;ll use the Tab control to arrange form data. <p>

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

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

In this lesson, you&rsquo;ll build powerful, fast summary queries that total, count, or average the values in a set of records. You&rsquo;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&rsquo;ll add query parameters that allow you to change a query&rsquo;s criteria without altering its design. <p>

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&mdash;<i>conditional formatting</i>, 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.</p>

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. </p>

</p> <p>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.</p>

If you're creating a database for others, you must make it easy to use&mdash;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.</p>

Ken Cook

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

I have recommended this course to colleagues and they will be taking it in the next few weeks. This was very helpful and I can't wait to put my knowledge to use.
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:

Discover more online courses

Recently viewed products

Picture of Microsoft Access 2010 Intermediate

Microsoft Access 2010 Intermediate

$599
$389AUD
Save 35%
Photoshop CS6-Intermediate Online Course | Vibe Learning
 

Photoshop CS6-Intermediate

Picture of Photoshop CS6-Intermediate
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 598 Students

Extend your Photoshop knowledge and learn how to enhance graphics by using layers, layer masks, and other advanced photo-editing features.

Photoshop is one of the most amazing software programs ever developed. It's a fun and creative way to alter photos and prepare them for print or the Web. In this course, you can take your Photoshop skills to the next level by exploring more advanced features in Photoshop that let you easily re-edit projects long after they were originally created (and long after the Photoshop ""undo"" command has expired).

These techniques, called non-destructive editing, let you work faster and reuse parts of images over and over again. If you like scrapbooking or want to make page layouts that you can fill with different graphics, you'll learn how to create reusable templates.

You'll learn how to save every single pixel in your original image so you never have to say, ""I'm sorry I tossed that information."" You'll see how to use Smart Objects, so that even if you crop or resize an image, you'll be able to get it back to its original size months afterwards. (And you'll learn some tricks to warp Smart Objects that will make the tabloid newspapers jealous!)

Whether you're a photographer who wants to use Photoshop to edit photos, a scrapbooker, or an artist, this course will teach you the building blocks you need to unleash your creativity. It's also a lot of fun!

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'll create, view, and hide layers. Why do layers matter? Well, they open a world of opportunities for fine-tuning your images. You can edit a layered image nondestructively, so you don't have to start over if you make a mistake or need to change something.

Today we'll focus on the clues Photoshop gives to explain exactly what you're doing to a layer as you're working. You'll create, move, duplicate, lock, unlock, cut, and paste layers. Knowing this information will let you alter images quickly and nondestructively . . . and the lock commands will help you prevent others (and you!) from accidentally altering your work.

Take advantage of Smart Objects&mdash;the most awesome and significant innovation in Photoshop since the layers feature was introduced. You can place a RAW-format photo (or JPG or TIF) file inside the Smart Object and re-edit it in Camera RAW anytime you want. You'll discover how to crop and resize photos nondestructively using Smart Objects, and you'll love the way they let you make a protected package out of an image.

Today you'll see how you can make an individual layer in an image larger or smaller, rotate it, and use the amazing Warp command. And you can reverse all these changes anytime you want&mdash;if you make them on a Smart Object layer. You can even use filters nondestructively, so long as you apply them to a Smart Object (gee, those come in handy!). You'll also create a pear that, when cut open, has an orange inside it.

<p>Each time you edit the exposure in an image, you lose image quality. But what if there were a way to edit the exposure as much as you wanted and not hurt the quality? There is! An <i>Adjustment layer</i> makes no permanent change to the image, and you can stack up these layers as you wish. You won't ever want to apply a regular Levels command or Adjustment command directly to an image again.</p>

In this lesson, you'll find out about layer masks&mdash;another way that Photoshop lets you have your cake and eat it too. If you bring a picture of little Johnny onto a new background image, and you erase all the stuff that was in the background, what happens if you change your mind? You'd better hope you have the original image somewhere, and then you're in for a lot more work. However, if you use a layer mask, you'll keep every pixel that's in the original image and hide the parts of the original that you no longer wish to see.

Did the dog eat Grandmother's portrait? Or did time and water do that damage? No matter. Using layers makes it easier than ever before to restore some of your treasured family heritage. You'll get ample practice with that today, plus links to websites that specialize in image restoration. Again, the theme of this lesson is nondestructive editing&mdash;working in layers so that you can always change your mind about a correction without having to begin again.

What happens if you want to place a person into a swimming pool or the ocean using Photoshop? To make the composite realistic, you need to transition from total opacity above the water line to total transparency below it. You'll learn that skill today as you work with grayscale and gradient masks. You'll also experiment with vignette edges and other edge effects, plus you'll create a Web page header.

One of the most common ways to lose sleep while using Photoshop is to try to add a new background behind a model with wispy, flowing hair. Hair and fur have always been the bane of Photoshop users. Photoshop can help, however. You'll learn some new tricks today as we explore some commands on the Masks section of the Properties panel.

<p>Have you ever wondered how to put images inside type, like those old postcards for various cities? You'll find out today. It's called a <em>clipping mask</em>, and it's a digital version of spreading glitter onto a paper that has a design drawn in glue&mdash;the glitter only sticks to the glue. In this case, the new layers only stick to the base layer in the clipping mask. Making a clipping mask is easy, but it provides one of Photoshop's "wow" moments.</p>

Photoshop can use the values in an image to correct the image. That sounds scary and mysterious, but it's actually easy to do. Today you'll create luminosity masks and use them to correct images and to develop false duotone images and wonderfully creative image composites. This lesson should nurture your creativity and yet give you some solid ways to add punch to an image or to create stunning sepia tones.

In this course, you've created composites in so many ways. But there's still more to learn! Today you'll create an image that has a different photo in each color channel. You'll use Content-Aware Scale to make unusual adjustments to your image size. You'll try a wonderful stained-glass framing technique. And you'll finish the course with a fun assignment that lets you put together everything you've learned.

Sherry London

Sherry London

Sherry London is a noted Photoshop and Illustrator expert, an artist, a writer, and a teacher. Her fiber art has been featured in magazines and exhibitions. Her published works include Photoshop CS2 Gone Wild, Photoshop Magic, Photoshop Effects Ma... Read more

 Read Sherry London'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 Photoshop CS6-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 Photoshop CS6-Intermediate:

Discover more online courses

Recently viewed products

Picture of Photoshop CS6-Intermediate

Photoshop CS6-Intermediate

$599
$389AUD
Save 35%