Normalize Tables with the Analyze Table in Access
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…
Application Parts in Access
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…
Connecting to Excel In Access
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…
Using an Input Mask for Data – Access
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…
Let your Database Skills Evolve with Access
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…
Take your Data further with SQL
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…
Ribbon and Navigation Pane Restrictions in Access
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…
Access: Queries – AND vs. OR
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…
Use Application Parts to quickly build tables and forms in Access
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…
Access – Normalizing Tables
Not sure if you separated out the fields in the tables correctly? Normalizing your database is key to building an easy to use database. Using the “Analyze Table” command, Access…