- Delivery Method Online
- Professional Certificate
- 24hrs Suggested Study Time
- 3 Months Access
- Tutor Support
- Study On Any Device
- 1808 Students
Microsoft Access 2010 Intermediate
Quick Facts
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 <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’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.
Microsoft PowerPoint 2010 Fundamentals
Quick Facts
- Delivery Method Online
- Professional Certificate
- 24hrs Suggested Study Time
- 3 Months Access
- Tutor Support
- Study On Any Device
- 3390 Students
Learn how to use Microsoft PowerPoint 2010 to create exciting slide presentations that include SmartArt, multimedia, animation, sound, charts, clip art, and hyperlinks.
Take your PowerPoint presentations from ""so-so"" to sensational! In these lessons, you'll learn how to use Microsoft PowerPoint 2010 to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.
First, you'll explore the latest features of PowerPoint, from the all-new File menu to the Backstage View. After that, you'll find out how to create dazzling presentations formatted with themes and a variety of slide layouts. You'll embellish your slides with text, objects, SmartArt, multimedia, animation, sound, charts, clip art, and hyperlinks, and you'll discover that global changes are a snap with the Slide Master.
In addition, you'll find out how to download an online image and insert it onto a slide. You'll also discover how to edit clip art, images, WordArt, and shapes easily with the commands on the Ribbon. You'll explore the printing interface in Backstage View, and find out how to view your presentations in the new Reading View.
And that's just the start! You'll also learn how to create a PowerPoint photo album with your digital pictures, and you'll work with PowerPoint Web App—an online version of PowerPoint. Finally, you'll add versatility to your PowerPoint skills as you learn to save presentations as PDF files and videos.
Whether you're a beginner or an experienced user, these lessons will teach you how to turn simple slides into a polished and exciting presentation that will make your message memorable. If you want to take your PowerPoint skills to a higher level, this is the course for you!
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.
Come explore the basic features of Microsoft PowerPoint 2010! You'll learn about the Ribbon, which replaces the menu and toolbars so common in other programs written for the Windows operating system. You'll fi<a name="_GoBack"></a>nd out how to plan a presentation and start the PowerPoint program. And you'll practice working with different views, task panes, tabs, and templates.
Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. We'l Lesson 3- Relationships of the Database Kind
What are table relationships? And what does <i>referential integrity</i> 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. <p>
You’ve already learned to put data <em>into</em> 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 <em>out</em> 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! <p>
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. <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—<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—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>
l start by choosing a theme for the presentation and slide layouts. You'll find out about the Live Preview feature, and we'll discuss how to save a file so you can find it later. You'll also create and edit slides in the slide pane and the Outline tab. Finally, we'll go over the ways to put on a slide show. Important stuff in Lesson 2!
Including tables in your presentation lets you present a lot of information in a little space. So in this lesson, you'll add, revise, and reformat tables. I'll also show you multiple ways to open a presentation. Then, I'll teach you how to preserve different versions of your work by using different filenames.
Today we'll cover two topics: printing and proofreading. You'll learn to print your presentation as slides, handouts, an outline, and notes pages. This versatility will really help you connect with audience members! And to make sure your printed presentation is as close to perfect as it can be, we'll explore the spelling checker, the AutoCorrect feature, the Research task pane, and the thesaurus.
We're going to switch gears in this lesson and work with images instead of text, which I think you'll enjoy. I'll show you how to embellish your slides with media clips, which could include illustrations, clip art, photographs, videos, or audio clips. You'll even learn how to download an image from a website and insert the image on a slide.
You're going to work with WordArt, Shapes, and SmartArt objects in this lesson, which I think you'll find exciting. It's fun to transform text into colorful WordArt objects and to draw and fill shapes with color and special effects. You'll learn to group and edit the ob<a name="_GoBack"></a>jects you create. And you'll add visual sophistication to your slides with SmartArt features—including Venn diagrams, flow charts, and more.
In this lesson, you'll create and edit a chart slide to illustrate statistical data. You'll find this lesson easy if you like working with numbers! But if you don't enjoy math, that's okay—I'll walk you through everything you need to know and do to create a chart slide. I'll also show you how to change the look of your chart by using Shape Fill, Shape Outline, and Shape Effects.
Making the same changes to dozens of PowerPoint slides is boring and time-consuming. Today we'll look at global changes you can make to your slides, handouts, and notes. For example, if you want to increase or decrease the font size on all the slides in a presentation, just make the change on the Slide Master. You also make global changes when you modify your presentation's theme colors or background.
In this lesson, we'll work with hyperlinks and action buttons. You'll enliven your presentation as you learn to create links from text or objects to other slides, presentations, documents, and Web pages. You can even add sounds and 3-D effects if you want!
Have you seen a presentation where text, images, or entire slides fly in from the top or push up from the bottom? That's animation. In this lesson, you'll learn about slide transitions, and you'll apply animation to individual slides and the Slide Master. You'll also find out how to add sound effects, such as chimes and whooshes. And perhaps most important, you'll learn how to avoid overdoing these effects!
You already know how to apply animation to your slides as they transition. Now it's time to apply advanced animation effects to text and objects on individual slides and Slide Masters. With the animation commands and the Animation Pane, you'll add and reorder animated text and objects on slides. You'll also add sound clips to your presentation.
Now that you know so much about creating PowerPoint presentations, we'll focus on different ways to save and share them. You'll see how easy it is to make your presentation into a PDF file, so it'll be accessible on computers that don't have PowerPoint 2010. You'll learn to open, edit, and share your presentation online with a Windows Live account. And you'll turn your presentation into a video.
Kathy Van Pelt
Kathy Van Pelt has been involved in education for many years, teaching and assisting students with microcomputer application courses. Kathy specialises in Microsoft Office applications, the Windows operating system, and keyboarding. For the past 2... Read more
Read Kathy Van Pelt's ProfileFrequently 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
The Learning Environment
From the moment that you enrol in the Microsoft PowerPoint 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 goaiv class="why-choose-icon">
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.
