Access Tip 20: Customizing Form Settings

If you really want to fine-tune your forms, you’ll need to use the Property Sheet. The Property Sheet lets you make extremely detailed changes to your forms. Since there are so many things that you can change, you should be extra careful when using the Property...

Access Tip 4: Working with Databases

A Database consists of multiple objects, and Access treats each object as a separate file that can be opened, saved, and closed. In fact, since you’re saving the objects individually, you won’t actually be saving the database itself. The database is kind...

Access Tip 12: Modifying Queries

Once you’ve created a query, you may want to make some adjustments to it to make the results easier to read. In this video, we’re going to talk about two ways of doing this: applying a sort and hiding fields you don’t need. Sorting is a very powerful...

Access Tip 5: Table Basics

Tables are at the heart of any Access database because they contain the actual data, so it’s important to know how to open and edit tables. If you’ve used a program like Excel, you’ll find tables to be relatively familiar already. However, there are...

Access Tip 18: Modifying Tables

Whenever you’re adding a new field to a table, there are three important things that you’ll need to think about: data types, character limits, and validation rules. The data type determines whether the field will contain text, numbers, currency, dates, or...

Access Tip 0: My Microsoft Access Advice

Before you start using Microsoft Access, make sure you are not reinventing the wheel. On occasion I’ll get a call from someone who wants to learn about Microsoft Access and even Microsoft Excel. Typically, I asked them what it is they’re trying to...

Access Tip 10: Multi-Table Queries, Part 1

In a typical database, a single table doesn’t show you the complete picture. That’s because related data is often spread out through several different tables. With a query, you can pull in data from multiple tables to answer questions. For example, to find...

Access Tip 9: Simple Query

Queries allow you to search for and compile data from one or more tables in Access. They are one of the best ways of analyzing the data you have in your database. Depending on what you’re trying to find out, they can range from very simple to very complex. In...

Access Tip 17: Formatting Reports

In order to create a professional-looking report, you’ll need to spend a few minutes formatting it. Access allows you to change the fonts and colors of a report. You can also change the theme and add a header, footer, and company logo. In this video, we’re...

Access Tip 15: Printing Reports

Once you’re finished with your report, you can either print it or export in a different file format it so that you can email it or post it on the web. Before you do this, you’ll need to go to Print Preview to make sure everything fits on the page, and you...

Access Tip 8: Sorting and Filtering

Sorting and filtering are tools that help you organize your data. Sorting arranges things in alphabetical or numerical order. Filtering hides data based on its value, allowing you to just focus on the most relevant data. Depending on what type of data you have, you...

Access Tip 6: Customizing Tables

There are a number of things you can do to customize your tables. For example, you can change the colors of the cells and the gridlines, and you can choose whether you want horizontal gridlines, vertical gridlines, both, or neither. You can also change the height and...

Access Tip 11: Multi-Table Queries, Part 2

In the last video, we created a query using two tables. We used a left join so that the query would look at the Orders table first, and we used search criteria to narrow down our results. In this video, we’re going to look at joins in a bit more depth, as...

Access Tip 1: Introduction to Databases

Free Microsoft Access Training I’d like to thank Mr. Steve Snyderman and his staff at GCFLearnFree.org for allowing me to offer these excellent Microsoft Access tutorials to my students for free. Access 2010 is a database creation and management program in the...

Access Tip 3: Getting Around Access

Whenever you’re learning a new program, it’s important to familiarize yourself with the program window and the tools within it. Working with Access is no different. Knowing your way around the Access environment will make learning and using Access much...

Access Tip 19: Creating Forms

Adding or editing table data can sometimes become tedious or difficult, which is why we often use forms instead. You can create a form from a table in a couple of clicks, and often it will automatically create a sub-form that allows you to edit data from a related...

Access Tip 14: Creating Reports

If you want to show some of your data to another person, you’ll often want to make it look as professional as possible, and simply showing them a table or query may not be impressive enough. Luckily, Access lets you turn a table or query into a report that you...

Access Tip 7: Working with Forms

In Access 2010, data is stored in tables, but you’ll often use forms to view and edit the information. Compared to tables, forms are easier and faster to use. In many databases, forms play a crucial role, as they allow you to add data to several related tables...

Access Tip 13: Creating a Totals Query

Queries can return a large amount of results, and often many of the results are identical For example, if we created a query to see which items have been ordered from our bakery, most of the items will appear multiple times. Sometimes, it’s much more useful to...