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

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