Learn how to capture and report data in a professional manner using Microsoft Access! This Access training workshop is designed for people looking to learn the fundamentals of creating, using, and manipulating a database. This online class is instructor-led, so you can ask any questions you may have as you work through the lessons. Plus, the online format gives you the opportunity to practice the skills you learn firsthand on your own computer.
Our expert instructors will teach you the basics of working in Microsoft Access, including how to use fields, queries, and tables; how to work with toolbars; and how to use and search the help function.
In this half day class, you will learn new skills and practice them with hands-on instructor-led exercises. Upon successful completion of this Microsoft access training course, students will be able to:
- Create and build a new database
- Work with tables
- Set up fields for tables
- Change fields in already established tables
- Add additional tables to a database
- Print the contents of a table
- Join tables
- Save tables
- Create auto forms and auto reports
- Add, change, and delete data in a database
- Design, save, and print a database
- Calculate statistics
- Create validation rules
- Close a database
This Access training course will also include a brief introduction to querying, which will include how to query a database (all fields), create a new query (select fields), use compound criteria in querying, sort data in a query, and save a query.
You will also learn time-saving tips and shortcuts to work more quickly and efficiently. Our expert instructor will set aside time to answer your specific questions.
Note: Most of the skills taught in this class are applicable to 2010, 2013 and 2016 versions of Access. Windows operating system is used for instruction in all Microsoft Office workshops.
Prerequisite: Students should be comfortable with working database software programs before taking this Access training class.