Checking for Duplicate Records with Queries In Access

Anytime you have duplicate records in Access, you run the risk of having corrupt data in your reports, because databases rely on normalized data for all tables and relationships. Normalized data means that entered data exists in only one table, and is utilized everywhere else throughout the database. This does not mean that you will … Continue reading Checking for Duplicate Records with Queries In Access

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 at some point for users to find what they are looking for, which then leads to more queries and reports being created. Unfortunately, without the … Continue reading Ribbon and Navigation Pane Restrictions in Access

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 outcome. Although there are many ways to write criteria in Access queries, our focus will be on the ‘AND’ and ‘OR’ expressions, and where to … Continue reading Access: Queries – AND vs. OR

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 will create tables, queries, forms and reports. This preset functionality is useful, especially if you are not sure where to start. Even though the Application Part … Continue reading Use Application Parts to quickly build tables and forms in Access

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 will make recommendations. It then allows you to keep or alter the suggestions. The steps for using this functionality is as follows: Click the Database … Continue reading Access – Normalizing Tables

Access: Normalizing your database

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 will make recommendations. It then allows you to keep or alter the suggestions. The steps for using this functionality is as follows: Click the Database … Continue reading Access: Normalizing your database