by Tony Holowitz | Jan 27, 2020 | Microsoft Access
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...
by Tony Holowitz | Jan 21, 2020 | Microsoft Access
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...
by Tony Holowitz | Jan 20, 2020 | Microsoft Access
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...
by Tony Holowitz | Jan 12, 2020 | Microsoft Access
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...
by Tony Holowitz | Jan 10, 2020 | Microsoft Access
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...
by Tony Holowitz | Jan 7, 2020 | Microsoft Access
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...
by Tony Holowitz | Dec 12, 2019 | Microsoft Access
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...
by Tony Holowitz | Nov 29, 2019 | Microsoft Access
Source: What’s new in Access 2016 – Access What’s new in Access 2016 Access 2016 has all the functionality and features you’re used to with some added enhancements and the best new features from Office 2016. Here are some of the top new...
by Tony Holowitz | Nov 21, 2019 | Microsoft Access
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...
by Tony Holowitz | Nov 7, 2019 | Microsoft Access
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...
by Tony Holowitz | Oct 5, 2019 | Microsoft Access
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...
by Tony Holowitz | Sep 25, 2019 | Microsoft Access
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...
by Tony Holowitz | Aug 27, 2019 | Microsoft Access
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...
by Tony Holowitz | Jul 29, 2019 | Microsoft Access
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...
by Tony Holowitz | Jul 24, 2019 | Microsoft Access
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...
by Tony Holowitz | Jul 4, 2019 | Microsoft 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...
by Tony Holowitz | Jun 12, 2019 | Microsoft Access
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...
by Tony Holowitz | May 26, 2019 | Microsoft Access
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...
by Tony Holowitz | May 15, 2019 | Microsoft Access
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...
by Tony Holowitz | Sep 29, 2018 | Microsoft Access
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...