Access Tip 21: Formatting Forms

When you’re adding or editing data in Access, you’ll use forms a lot. If you spend some time optimizing your form to make it as pleasant and easy to use as possible, then it will pay off in the long run. In this video, we’re going to add a Command...

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 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 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 16: Using Report Wizard

Occasionally, you may want to create a report that includes data from multiple tables or queries. The Report Wizard can simplify this process by breaking it up into several steps. You’ll be able to choose the tables or queries that you want to include, and then...

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 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 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...

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 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 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 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 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 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 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 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...