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.

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.

Dreamweaver CS6 Intermediate Online Course | Vibe Learning
 

Dreamweaver CS6 Intermediate

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

Take your Adobe Dreamweaver skills to the next level with more advanced Web design techniques under the tutelage of a proven Web development expert.

Take your Adobe Dreamweaver skills to the next level with more advanced techniques under the tutelage of a proven Web development expert. In this new intermediate-level Dreamweaver course, you'll learn to harness the power of this industry-standard Web design tool.

You'll examine pure CSS layout and discover how to get the most out of Dreamweaver's templates. The course also shows you how to incorporate multimedia elements such as video and manipulate data using XML data and XSL. Throughout the course, you'll get hands-on experience with Dreamweaver as you develop a sample site using your new skills.

Whether you're planning a career in Web design, designing a website for your business, or developing sites as a hobby, this course will give you the tools you need to work like a pro. By the end of this course, you'll have a solid, in-depth understanding of traditional layout and how it translates to the Web so you can make your sites clearer, cleaner, and more accessible.


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 our first lesson, you'll get familiar with the code Adobe Dreamweaver generates in response to the steps you perform. Intimidated by code? Don't be. By the end of this lesson, you'll have a much better understanding of how HTML, XHTML, CSS, and JavaScript work together to build your site content. Previous non-coders will come away with these topics demystified, and code-savvy users will learn how Dreamweaver enhances code editing.

Cascading Style Sheets (CSS) have been with us since the mid-1990s. Yet, because of the slow state of browser development, it's only in the last few years that CSS has taken its rightful place at the center of modern Web design. CSS governs content presentation, while HTML and XHTML handle document structure. In this lesson, we'll take a closer look at CSS, see how it works hand-in-hand with markup, and examine the tools Dreamweaver gives us to work with CSS in a "what you see is what you get" environment.

Snippets take some of the drudge work out of site design. Do you have a common element&mdash;like a document footer with copyright information in it&mdash;that you're going to insert in every page of your site? Turn it into a snippet. Next time you need it, just click a button, and voil&agrave;! Instant page content. In today's lesson, we'll examine Dreamweaver snippets, learn how they function, and discuss how to fit them into your workflow.

A Dreamweaver template allows you to fix the layout of pages so that inexperienced folks can't mess them up when they're updating content. In this lesson, you'll learn what Dreamweaver templates do, how to build them, and how to apply them to the pages of our site.

Today you're going to learn all about styling pages for devices other than the browser. We'll look at the different types of devices you can style for&mdash;smartphones, assistive technologies, and printers, to name just a few. And we'll examine some of the tools Dreamweaver provides to make styling for devices easier.

<p>It's estimated that in 2013, the number of people using handheld devices to view the Web will outnumber those on desktops and laptops. So, the future is <em>now</em>! We've examined ways to make our pages play nice when printed, so how do we get our stuff looking good on these other devices, too? Well, the mechanism is pretty much the same, but we have a few more variables to deal with. Fortunately, Dreamweaver has some very handy tools for making this job easier, and you'll learn about them in this lesson!</p>

In this lesson, we'll continue our discussion of styling for devices and finish up the smartphone layout that we started in Lesson 6. You'll learn how to find out device screen widths, and we'll talk more about media queries. You'll also work more with the Multiscreen Preview window to see your work as we go along. We'll finish up by tinkering with some CSS properties that are a bit tricky to find but necessary when styling for smartphone browsers. By the end of the lesson, our site will be optimized for a smartphone!

<P><I>Accessibility</I>. You've heard the term, but do you really know what it means? Section 508 of the U.S. federal Rehabilitation Act includes rules for making site content accessible for users with disabilities. Many other countries have similar rules. Today we'll discuss how to keep Dreamweaver on the ball, accessibility-wise, so anyone can use your site with ease.</P>

<P>Have you been to YouTube to watch videos? Or have you been to Amazon.com to preview music? These types of audio and video files are <I>media objects</I>. In today's lesson, we'll talk about what software you need to play media objects and how Dreamweaver lets you place this type of content within the sites you build.</P>

<p>Ever tinkered with JavaScript? It's the scripting language behind form field validation, rollover images, and other types of dynamic interaction. In Dreamweaver, we call JavaScript effects <em>behaviors</em>; in today's lesson, we'll delve into the various Dreamweaver interface features for creating these effects. And the best part is you won't ever have to touch the code!</p>

You've seen the acronym all over the place. It's time to find out how you can put XML (eXtensible Markup Language) to work. Today you'll examine XML and create a simple database. Then you'll pull data out of that database and format it with eXtensible Stylesheet Language (XSL)&mdash;all without a lick of programming!

<p>If you want to design <em>anything,</em> you need a firm understanding of&nbsp;the people&nbsp;you're designing for. In today's lesson, we'll step away from Dreamweaver and look at the most important component of the Web&mdash;us. You'll discover how we humans read Web content and learn how to structure your content so that it fascinates your fellow domesticated primates. </p>

Robert Fuller

Robert Fuller

Robert Fuller is a veteran Web developer, educator, and author. His corporate experience extends from Silicon Alley to Silicon Valley, where he has held almost every post from intern to senior developer. He has logged tens of thousands of classroo... Read more

Read Robert 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.

The Learning Environment

From the moment that you enrol in the Dreamweaver 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 Dreamweaver CS6 Intermediate:

Be Assertive! Online Course | Vibe Learning
 

Be Assertive!

Picture of Be Assertive!
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
  • 10741 Students

Find out how you can stop others from intimidating you or treating you poorly.

Are you tired of being intimidated and treated badly by others? Learn specific techniques to become more assertive in all parts of your life. Discover how people manipulate you and how you submit to being a victim. Understand the difference between passive, aggressive, and assertive behaviors, and see how inner dialogues keep people acting in passive ways. Explore ways to change your inner dialogue, such as using affirmations and visualisation, creating new labels for yourself and others, and keeping a journal.

Do you think you speak non-assertively?If so,master the skills that will empower you to talk in an assertive manner, including specific verbal techniques and phrases for a variety of situations. Anger and criticism from others are difficult to deal with, so you'll get many tips on how to handle these. And because your body can reflect an inner uncertainty, you'll learn how to use facial expressions, eye contact, gestures, and your voice to reinforce the assertive statements you're making.

You teach people how to treat you through your behaviors as well as your words, and this course will help you understand which behaviors to use with others so they perceive youas being assertive. When you begin to exhibit your new confidence in relationships, people will counter in various ways. You'll learn how to stand firm in the face of this resistance.

Get the assertiveness training you need in order tobe more confident and powerfulwith family members, friends, bosses, co-workers, professionals, service people, and even total strangers. It's your turn to speak up!

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.

This first lesson will mark a turning point in your life. You'll begin by measuring your assertiveness quotient, you'll learn about the many surprising consequences of not being assertive, and you'll learn to recognize the different behaviors of passive, aggressive, and assertive people.

Before you can begin to act assertively, you need to be able to identify your self-canceling thoughts and change your inner script. In this lesson, you'll learn why you have negative thoughts about yourself and what those could be. I'll share with you several techniques for replacing them with a positive inner script, including visualization, affirmations, storytelling, writing a journal, and creating a collage.

One of the ways non-assertive people lose power is through the use of certain types of language to either gain approval or avoid opposition, criticism or disagreement. Today, you'll learn how to recognize when you're doing this, and you'll discover some simple and painless adjustments to the way you say things that can help you avoid this problem.

Now that you've learned what takes your verbal power away, it's time to learn how to be verbally assertive. In this lesson, you'll learn how to make the four types of "I" statements to tell others about yourself, respond to others' requests, ask for cooperation and support, and confront another person. You'll also learn about techniques you can use to deal assertively with people who are angry with you or criticizing you.

Just as an actor perfects the nonverbal aspects of a role, you need to pay attention to the nonverbal nuances in your new assertiveness role. What you'll learn in this lesson is how to use eye contact, facial expressions, voice, body posture, gait and clothes to create an assertive image.

In order for you to be most effective, you need to be able to adjust your assertive message to the personality of the person with whom you're communicating and to deal with resistance. In this lesson, we'll study four behavior types and five sensory types to help you understand which assertive approach works best. You'll also find out how to identify resistance in others by observing verbal and nonverbal clues and various methods you can use to handle the resistance you may encounter.

Most people find it extremely challenging to be assertive with close family members. Today, you'll learn about a variety of statements family members use to manipulate you, and you'll discover the most effective ways to respond to each of them. You'll learn how to act assertively with your parents, siblings, and children to build more positive relationships.

In this lesson, you'll discover the four different emotional types of people and how they come together as mates. We'll explore the relationships these types have with each other, what problems tend to arise, and how the partners can treat each other differently in order to resolve any problems they may have. You'll also learn guidelines for working out issues with your partner in an assertive but loving manner.

Do you find it difficult to say no to a friend who asks a favor that you don't really want to do? Do you have difficulty having conversations in social situations? If so, you'll really learn a lot from this lesson. I'll show you how to use the assertiveness techniques you've been learning to deal with your friends in a calm but strong manner. Next, you'll learn techniques you can use to open up to other people and carry on interesting conversations.

You may approach the thought of being assertive at work with trepidation. However, when supervisors and employees treat each other with respect and act assertively with each other, both happiness on the job and productivity increase. In this lesson, you'll learn how to be assertive during job interviews as well as with your boss and subordinates, what to look for to see if your workplace encourages or discourages assertiveness, and how to advance assertiveness where you work.

Often, you encounter situations in which you deal with people as a consumer. Today, you'll learn how to be assertive with waiters, salespeople, government clerks, doctors, hospital employees, lawyers, and IRS agents. We'll also discuss how to be assertive in everyday situations, such as when a restaurant or movie theater is unbearably cold.

So far in this course, you've gained a wealth of knowledge about how to be assertive. You've learned skills and techniques to use with family and friends, as a consumer, and in the workplace and everyday situations. In this closing lesson, you'll learn some situations in which it's better to not be assertive, how to give and receive compliments, and how to be assertive in all parts of your life.

Vivian Harte

Vivian Harte

As a professor at two colleges for over 14 years, Vivian Harte taught students how to build and maintain successful teams. In the workplace, she helped teams create a city's strategic energy plan, write a state's recycling manual, organise and fac... Read more

Read Vivian Harte'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 Be Assertive! 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

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.

Recently viewed products