Microsoft Access 2007 Fundamentals

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

Learn how Microsoft's powerful database can help you store and manage information you've collected about your business, home, or community.

Learn how Microsoft's powerful and award-winning database can help you manage, store, search, analyze, and display important information you've collected about your business, home, community, or any other entity. In this practical and project oriented hands-on workshop, you'll learn how to create tables filled with fields and records. You'll build relationships between the tables to eliminate redundancies and slash data entry time. You'll discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks. 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.

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.

A Microsoft Access database is made up of seven interrelated components: tables, fields, records, forms, queries, reports, and macros. In today's lesson, you'll become familiar with each of these components and--perhaps more importantly--you'll learn how each component can help you successfully collect and manage a wide variety of business, personal, or scientific data. And you'll get hands-on experience building tables; creating fields; and manipulating records.

Today, you're going to learn how to take advantage of a variety of powerful customization options that will help you simplify the process of adding data to an Access table. You'll get hands-on experience with validation rules, default values, and input masks—time-saving tools that will improve your productivity while increasing the accuracy and reliability of the data you collect.

This lesson will literally slash the amount of time you spend performing data entry tasks. You'll deftly sidestep an issue that often plagues Access novices: how to avoid typing and re-typing the same pieces of information over and over again in each of the many tables that make up your database. Today, you'll discover the powerful and time-saving secret of table relationships.

In this lesson, we'll give your database a professional makeover. Your database will achieve new levels of attractiveness and sophistication with the introduction of powerful forms. You'll find that forms make it faster, easier, and more pleasant for you to review, add, edit, or remove the information in your tables.

Today, you'll embellish your forms with powerful custom controls like buttons and combo boxes. These custom controls can help you automate tasks you might otherwise find difficult or time-consuming to carry out manually. As a result, you'll work at greater efficiencies and with fewer opportunities for error.

One reason we create a database is so we have a place to store information that we've collected. We store data in a database because we know that we will need to review that information again. By squirreling the data away today, we give ourselves future opportunities to review, search, analyze, sort, and subtotal that information as needed. Today, you'll discover how to use an Access query to scan a vast collection of data and retrieve only the exact pieces of information that you require.

In today's lesson, you'll overcome all those thorny query issues that often stump both beginning and advanced Access users. You'll learn how to scan the entirety of your database for a single word (or even a tiny word fragment) with pinpoint precision. You'll find out how to seek out a range of dates or numbers instead of placing all your bets on a futile and time-consuming search for a single value. And if you ever find yourself with a better understanding of what you don't want to see than what you do, you'll understand how to perform a reverse query.

In a well-designed database, information will be evenly distributed across multiple tables. The advantages of this distributed approach are too numerous to elucidate here, but the approach does raise one important question: is there any way to take all of the information that has been scattered across several tables and bring it together in one place? Fortunately, there is a simple solution. Today, you'll receive ample opportunities to try your hand at combining information from an assortment of tables into a single pool of data.

If you really want to show off the data in your database, you'll want to showcase it with a report. A report will help you organize and format your data, making it more accessible and more attractive. There really is only one surefire way to understand what a report is and what it can do for you: you'll just have to create one. And that's exactly what you're going to do in today's lesson.

In our last lesson, you learned how to convert a table filled with raw information into a handsome, well-organized report suitable for printing. But what if you want to create a report that only shows some, instead of all, of the information contained within a table? Is that even possible? You'll find out in today's lesson.

Access comes with a number of pre-formatted reports designed to meet just about any conceivable need. But there will be rare occasions when you want to produce a report that is a little, well, different. A report that goes beyond the norm. A report that communicates with its reader in a new and unique way. In today's lesson, you'll learn how you can use the Report Design tool to whip up your very own custom reports from scratch.

In this, our final lesson, you'll learn all about Access macros. An Access macro can automate just about any database activity you can imagine, from running queries to printing reports to opening and closing forms or tables. However, a macro can perform these activities at a much higher rate of speed and with far more accuracy than you or I could ever manage to muster. This is one of the most popular and eye-opening lessons in the course, covering a fascinating topic you won't want to miss.

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

I just wanted to let you know that I appreciate your having designed a course that was simple, clear, straightforward, and at the same time, comprehensive.
Verified Student
I needed to learn enough to use an existing database and the lessons were just in time as I am working through the project. The lessons were extremely detailed and this was exactly what I needed for a 67-year-old doing this kind of thing for the first time!
Verified Student
I thoroughly enjoyed the course. I tried learning Access 2007 on my own, and although I got quite far on my own, this course really showed me how little I really knew! Thank you so much. I can put the things I learned into practice immediately - actually, I already have!
Verified Student
See More Reviews

The Learning Environment

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

Discover more online courses

Recently viewed products

Picture of Microsoft Access 2007 Fundamentals

Microsoft Access 2007 Fundamentals

$599
$389AUD
Save 35%
Medical Transcription Online Course | Vibe Learning
 

Medical Transcription

Picture of Medical Transcription
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
  • 5295 Students

Learn how to transcribe the medical reports most often used in healthcare today, and discover how to get started and advance as a medical transcriptionist.

Take your first step toward a lucrative career as a medical transcriptionist! In this course, you'll learn how to transcribe the most common medical reports used in both inpatient and outpatient settings. We'll review a lot of the grammar you might have forgotten since high school and apply it to the reports. This knowledge will help prepare you to work almost anywhere in the medical field—doctors' offices, clinics, public health facilities, and hospitals. With this foundation, you'll be set to advance your education so you can work as a subcontractor for a company that outsources transcription, or you can eventually even take on your own clients—all from the comfort of your own home.

We'll go through each of the nine main report types—their formatting requirements, the components of each one, and how they are used in the clinical setting. We'll review grammar points in every lesson, pointing out important elements that will make your reports perfect. You'll also gain important clinical knowledge of major disease processes that are essential to enhance your skill as a medical documentation specialist.

Along the way, we'll download a free transcriber that you'll use to listen to dictation, and we'll cover how to use it to produce the reports in your word processor. These hands-on exercises will give you the practice you'll need to determine if this field is for you. We'll also go through the options you'll have now and in the future by developing the skills of a medical transcriptionist. By the end of this course, you'll know the basic report types, have clinical knowledge of major diseases, be able to correct grammar from dictated reports on the fly, and know the next steps you'll need to take!

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 look at the history of medical transcription as a career. You'll find out how the field has evolved into its modern form, and you'll explore the various skills and aptitudes that you'll need to succeed as a professional medical transcriptionist. You'll examine the type of work MTs produce, and we'll take a look at the MT's job today, where you might work, and what might be in store in the future for those working in this career field.

We'll start today by discussing the MT's tools of the trade. We'll review a few of the reference books and discuss the types of Web sites that MTs use for research. Then we'll take a look at the hardware and software that today's MTs use on the job. I'll talk you through downloading the free software we'll use in this course, and then we'll go through a quick tour on how to use it. By the end of this lesson, you'll be sitting at your computer, listening to a real medical dictation audio file and looking at the Express Scribe software on your screen. As you listen to the medical report, you'll practice starting, pausing, and rewinding the audio as you tap away on the keyboard.

There are nine report types that medical professionals use most often in both hospitals and clinics. So in this lesson we'll go over a variety of examples of real medical reports. We'll also do a quick review of medical correspondence. Medical letters aren't much different from traditional letters, but since you might not have typed a traditional letter in a while, you might need a refresher. We'll finish the lesson with some specific tips about pathology reports and how to handle numbers and measurements. Then you'll practice transcribing a medical letter and a pathology report.

We'll spend this lesson going over how to listen most effectively, discussing the difference between hearing and active listening. We'll also touch on many of the issues that keep voice recognition systems from replacing humans, including homonyms, synonyms, and antonyms. Then we'll discuss how you can use phonetics and vowel sounds (as well as a few other tricks!) to help you figure out a word or phrase in a muddled recording. Then we'll talk a bit about the radiology department and radiology reports, and we'll finish up by practicing transcribing one in today's assignment.

Today we're going to talk about some subjects that might make you cringe a little: grammar, sentence structure, and punctuation. But I promise this will be a painless, maybe even enjoyable, journey through some of the basic principles of writing that will help you become a better MT. Then, in our Practice Corner, we'll talk a little more about SOAP notes and then turn our attention to infectious diseases and medications. You'll also have the chance to transcribe a SOAP note and a radiology report in the assignment that accompanies the lesson.

We'll continue our examination of writing in this lesson by talking about style from the MT's perspective. When you're transcribing, you must follow editorial directions in spelling, capitalization, and typographical display. And it's those directions that are the style MTs need to be concerned about. I think you'll be surprised at how many different ways you can treat a single word. Should it be capitalized or lowercased? Should you abbreviate it, or should you spell it out? Should your numbers be in digit form or word form? These are the issues we'll be covering in this lesson. Finally, in our Practice Corner, we'll focus on the H&P report, and you'll have the chance to practice transcribing one.

No matter what you transcribe, one thing is a given: Medical terminology will be a huge part of it. That's what we'll be focusing on today. One thing to remember is that dictators aren't perfect. They might say one word when they actually mean another. Or they might say a word that has a sound-alike word, like <em>cystitome</em> and <em>cystotome</em>. If you have a good understanding of medical terminology, you can pinpoint the correct word to make sure your transcription is accurate. Then, in our Practice Corner, I'll review the basic nature of heart disease and its treatment. We'll also take a close look at another common disease: diabetes.

A critical component of the MT's work is the way you put your reports together. So in this lesson, we'll talk about how to break up your reports into sections with headings, subheadings, special line spacing, page breaks, and other formatting niceties. We'll also take a closer look at ways you can make your work easier by using word processing shortcuts, AutoText, macros, and templates. Mastering them will make you a faster and more efficient MT! In the Practice Corner, we'll focus on surgical reports. Surgical terminology is important to know, and it's also fascinating to take an inside look at what goes on in the operating room. The assignment for this lesson will include a surgical report to help you put to work all the new knowledge you've gained.

Another essential step in transcription is editing and proofreading your work. And that's what we'll concentrate on today. I'll start off by sharing some editing do's and don'ts as well as what to look for when you're proofreading. In our Practice Corner, we'll be covering a disease process that has, in some way, touched virtually everyone: cancer. Once you have an overview of cancer, we'll work on the consultation report. Physicians often ask specialists to further evaluate their patients, especially cancer patients. So this is a common report that you're likely to transcribe regularly. The assignment for this lesson includes a consult report to transcribe, and you'll also get to practice proofreading.

So far we've focused on the mechanical elements of medical transcription. But there is still a lot you need to know about clinical issues. So this will be a completely clinical lesson. We'll talk about classification systems and their transcription foibles. And now that you have the bones of grammar and style down, we're going to talk about some real bones. We'll begin by discussing information on fractures and spine levels. Finally, in our Practice Corner, we'll discuss discharge and death summaries. They are very similar reports, but we'll take a look at some of their subtle differences.

This lesson will be similar to the last in that it covers lots of clinical issues. It won't all be clinical, however. There are a few miscellaneous things that I want to make sure I share with you. They don't really fit into neat categories, so I've put them all here. Once we finish with these miscellaneous items, we'll jump back into some clinical issues. We'll be talking specifically about infections. Then we'll turn our attention to smaller parts of the body—cells and blood. Then, in our Practice Corner, you'll see how everything you've learned can come together in an autopsy report. This is probably the longest, most comprehensive report you'll ever come across. And, of course, you'll have the chance to transcribe an autopsy report in the assignment!

By now you have the tools and the knowledge you need to dip your toe into the waters of medical transcription. But we still have a couple of big questions to answer. How do you manage your workload? Also, how do you establish yourself as a medical transcriptionist? And do you need more training? Today we'll discuss all the different ways you can work—everything from being an independent contractor all the way up to consultant work. We'll talk about additional training as well. Then we'll take a peek at some of the events on the horizon, and you'll see why this is an exciting time to enter the transcription field. For our final Practice Corner, we'll look at the Health Story Project. It's an initiative to develop standards for integrating narrative reports (like the ones you've been transcribing) into the electronic medical record in a meaningful way—giving them the ability to be searched and to extrapolate data like we have never been able to do before.

Jennifer Della'Zanna

Jennifer Della'Zanna

Jennifer Della'Zanna graduated from Albright College in Reading, PA with a Bachelor of Arts degree. With 15 years' experience in the health care industry, she has worked as a medical transcriptionist, receptionist, medical assistant, practice admi... Read more

 Read Jennifer Della'Zanna'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 been transcribing workers' compensation medical-legal reports for years. This course was an eye opener into what I lacked, what is missing in my reports, and my level of competence. I got busy and copied mountains of pertinent information to be studied again and again at my leisure so I can upgrade my skills. I have had a secret desire to work as a transcriptionist for a hospital or the County Medical Bureau, but I am
nowhere near prepared. This course was of immense value in helping me assess my current level of competence. I plan to practice transcribing reports over and over again. Thanks so much for the templates. I cannot express enough how valuable this course was for me.
Verified Student
This course exceeded my expectations. It was everything I was looking for and more. A++ for the instructor. I completed the Medical Secretary Training ( a 9-month course) at a technical college ~ 20 years ago and wanted to see how the industry changed, brush up my skills and decide if this was a career for me. Jennifer is so pleasantly willing to present a vast of array of resources, details, nuances, considerations, and experiences. I have taken a few on-line courses and this by far was the best one.
Verified Student
This course gave me information that I did not know even though I've been a medical transcriptionist for almost 9 years. I always learned something new in each lesson and was very informative. The resources given to you for future reference are very useful as well. I enjoyed taking this refresher course and would definitely recommend it to friends and family.
Verified Student
See More Reviews

The Learning Environment

From the moment that you enrol in the Medical Transcription 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.

Still looking?

Check out the following courses related to Medical Transcription:

Discover more online courses

Recently viewed products

Picture of Medical Transcription

Medical Transcription

$599
$389AUD
Save 35%