0246 - Introduction to Microsoft Access 2007

Course Description

Course Details 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. 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 • Internet access • Email • One of the following browsers: o Mozilla Firefox o Microsoft Internet Explorer (9.0 or above) o Google Chrome o Safari • Adobe PDF plug-in (a free download obtained at Adobe.com .) Microsoft Windows 7, Vista or XP, Microsoft Access 2007 or Microsoft Office Professional 2007 (please be sure to install this software on your computer before the course begins). Note: This course is not suitable for Macintosh users, nor for users of any of older versions of Microsoft Access. *Unfortunately if you have the 2010 version of Microsoft Office, it won't work with Office 2003 or Office 2007. Also, we won't be able to support you in the discussion area at this time.