Learn to build, edit, and maintain a database in Access 2010, using tables, reports, forms, and queries to give you fast access to all your important information.
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 customise 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.
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.