Introduction to Microsoft Access 2010

Take control over your data! Whether you're a novice or an experienced database user, this course will show you how to harness the full power of Microsoft Access 2010. In these practical and project-oriented lessons, you'll learn how to use this award-winning MS Office software to create and customize tables. You'll build relationships between your tables to eliminate redundancies and slash data entry time. And you'll discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks. In addition, you'll find out how to make your database more user-friendly with custom data entry forms, smart lists, and other sophisticated controls. You'll learn how to retrieve exactly what you need from your database with powerful queries and reports, and you'll even start automating routine tasks with labor-saving macros. By the time you've finished this course, you'll know how to create an effective database for any information you need to store, document, and manage—at home or on the job. How It Works This course is fully online, you require internet access and an email account. The course duration is 6 weeks, followed by a 2-week period to complete the final exam (online, open book). Lessons are released on Wednesdays and Fridays of each week, for a total of 12. You are not required to be online at any specific time. In addition to the specific lesson content, there is a discussion board with each lesson and often there is an optional assignment to apply the learning. Following each lesson, there is a short multiple choice quiz. Your score on these quizzes does not count towards the final mark but completing these helps solidify your learning as well as prepare you for the final exam. The final exam is an open-book, multiple choice exam and you need to achieve a minimum of 65% on the final exam to pass the course. There is only one opportunity to pass the exam. A certificate of completion from Ed2Go is available for printing immediately upon successful completion of the course and a certificate from the University of Waterloo will be emailed typically 1-2 weeks later. Many of the Ed2Go courses are eligible towards the various online certificates offered by WatSPEED. Requirements Microsoft Access 2010, (software must be installed and fully operational before the course begins); Windows XP, Windows Vista, Windows 7, or Windows 8.

Note: Check with the institution regarding start/end dates, prices, and delivery method. These may vary according to the program, section, and/or semester.