Microsoft Office Access 2010: Level 1 and 2
Access users will create and modify new databases and their various objects.
Upon successful completion of this course, students will be able to:
- Identify the basic components of an Access database
- Build the structure of a database
- Manage data in tables
- Query a database
- Design forms
- Generate reports
- Streamline data entry and maintain data integrity
- Join tables to retrieve data from unrelated tables
- Create flexible queries to retrieve data and modify tables
- Improve the functionality of Access forms
- Customize reports to organize the displayed information and produce specific print layouts
- Share data between Access and other applications
This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.
You should be familiar with using personal computers. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend that you first take one of Element K’s introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:
- Windows XP Professional: Level 1
- Windows XP: Introduction
This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products.
Day 1: Level 1 – $99
Day 2: Level 2 – $99
Full-Two-Day workshop: $198
Meet the Instructor
Carol Whitson, owner of Computer Specialty Services, is a certified Microsoft Office specialist and has her GISP (Geographic Information Specialist Professional) certification. She is proficient in Microsoft Office (2007-2013) family of products, QuickBooks, and Sage software and has taught various GIS and custom software courses.