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…

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…

Continue Reading Connecting to Excel 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…

Continue Reading Access: Queries – AND vs. OR

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…

Continue Reading Access – Normalizing Tables