Using Forms to Add, Browse, or Edit Records in Access

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 nothing inherently wrong with doing things this way, but using the datasheet view for all … Continue reading Using Forms to Add, Browse, or Edit Records in Access

Normalize Tables with “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 database, you should be able to type information in one place and it should be accessible everywhere else. Normalization is the process of making sure … Continue reading Normalize Tables with “Analyze Table” in Access

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 Create tab, then click the drop-down for Application Parts (located on the left side of the ribbon). There are a number of templates to choose … Continue reading Application Parts in Access

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 importing and/or linking, the data needs to have headers for each column of information. Also, there can be no entire columns or rows of information … Continue reading Connecting to Excel In Access

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 entered is crucial for custom functionality. Therefore, control through data validation is very important. Input Masks are one type of data validation that ensure information … Continue reading Using an Input Mask for Data – Access

Let your Database Skills Evolve with Access

You are pretty good with MS Excel. You have used it for years, taken MCT’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 Access is the next level. Apply your knowledge to MS Access, and learn basic database organization … Continue reading Let your Database Skills Evolve with Access

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 Language, better known as SQL, from Mission Critical Training. In SQL Fundamentals of Querying, you will learn how to use SQL to implement logic and … Continue reading Take your Data further with SQL

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