There are certain best practices for databases that are not widely known. One of these best practices is using forms to add, browse, or edit records. Often, we use the Datasheet view to do all of these things. There is

Normalizing a table in Access is one of the most important steps toward having a database that actually works like a database. Typically, when you are the user of a database, you should be able to type information in one

  Application Parts are a great way to quickly build  databases. By using application parts templates, you can easily create tables, queries, forms, and reports. To do this, click the Create tab, then click the drop-down for Application Parts (located

  Access allows users to connect to various data sources, such as SQL, other databases, XML files, and SharePoint, as well as Excel files. In order to ensure a proper importing and/or linking, the data needs to have headers for

When people are typing information into a database, it is not always obvious how information is supposed to be entered. In many cases, having consistency in the way data is entered is crucial for custom functionality. Therefore, control through data

You are pretty good with MS Excel. You have used it for years, taken AdvantEdge Training’s Excel classes, and developed some impressive spreadsheets. Now what? What else can you do with all that knowledge of logic, formulas, and data? MS

You have a good grasp of Access databases, but you know there is more you can do with your data. It’s time to check out a class on Structured Query Language, better known as SQL, from AdvantEdge Training & Consulting.

Allowing everyone to have full access to a database you created can bring on many issues. In most cases, too many queries and reports get created, which makes it hard at some point for users to find what they are

When writing queries in Access, it is important to know where to place the criteria for the queries, as placing the criteria in the wrong place can drastically change the outcome. Although there are many ways to write criteria in

Application Parts are a quick way to partially, or completely, build specific tables and forms for your database. Using the Contacts template as an example, once used, this Application Part will create tables, queries, forms and reports. This preset functionality is