Sign up for Microsoft Office training, SharePoint training and more.
Access 2010 Training
Personalized Online Training
Get answers to everyday questions and on-demand training with over 7,000 Interactive Tutorials.
Bite-sized software simulations.
Accurately test your staff’s skills.
Training manuals with unlimited printing rights.
FREE Cheat Sheets
Just sign up, download, and share.
- Tablet / mobile
- LMS / SCORM
Microsoft Access is a powerful database program you can use to store all kinds of information – from a simple list to an inventory catalog of thousands of products. Once the information in put in Access, it’s easy to find and analyze. In this course youÍll become familiar with the Access 2010 working environment. You’ll learn about the program screen, how to give commands, use Help, and all the new features that have been added to Access 2010.
There are many great things you can do in Access, but before you can dive in headfirst you need to learn the basics. This course will teach Access’ basic functionality, such as entering date and the basics of tables, forms, queries, and reports.
Creating and Working with a Database
Thankfully, you can stop typing lists of information in Word and Excel by creating a database in Access. In this course you will learn how to create databases that store names, addresses, and any other type of information you can think of.
Finding, Filtering, and Formatting Data
As a database becomes larger and larger, finding a specific record becomes harder and harder. Luckily, Access has commands, such as Find, Sort, and Filter that can track down particular records. This course will teach you how to use these commands, sort information in a table, and use filters to display only records that meet your criteria.
Working with Tables and Fields
The most useful and efficient databases consist of well-structured tables. This course will explain what you need to know about tables and fields: how to link two related tables, how to create indexes for faster performance, and how to create primary key fields.
Creating Relational Databases
Many people find the concept of relational databases difficult to understand. In this course you will receive a clear understanding of relational databases. You will learn how to link tables together in a one-to-many relationship to create a relational database. You will also learn how to enforce referential integrity to keep records accurate.
Working with Queries
Queries are the superstars of Access. Queries make sense out of all the jumbled records and display only what you need to know. In this course you will learn how to harness the power of queries. You will learn about all the different types of queries and how they function within Access.
Working with Forms
A form created in Access is just like any ordinary paper form; only you don’t have to worry about reading bad penmanship. In Access, forms give you an easy way to enter and view data in a table. In this course you will learn how to create, add content, and create a form.
Working with Reports
Reports are handy to know if you need to print professional copies of any analyzed from your database. This course will explain how to create and work with reports from tables and queries.
Formatting Forms and Reports
Looking to create sharp-looking forms and reports? This course will explain how to format your forms and reports. You will learn how to change appearance of text and add graphics to make forms and reports visually appealing and functional.
Working with Macros
Macros are extremely useful when working in Access 2010. A macro helps you perform routine tasks by automating them. Learn how to create, run, edit, and work with Macro groups to simplify routine tasks.
Now that you are an expert at Access 2010, learn how you can easily share information between different databases and different programs. In this course you will learn how to import and export data from external resources.