Access Database Recovery

What is Access MDB File?

The MDB file is what houses all of the data for your Access Database. It contains everything that you used to create the database, such as forms and tables, as well as the background information to keep the database healthy. You are probably already familiar with the numerous types of files associated with the most common Microsoft applications. The file type refers to the file extension. Word uses the .doc and .docx file. Excel uses the .xls and .xlsx file. For Microsoft Access, the file...

Read more »

Aggregate Clauses and Summary Aggregate Clauses in Access SQL

Once you have a basic understanding of the basic Access SQL clauses, you need to learn about the more complicated clauses. Learning the two most common types will simplify your workload.  One of the primary draws of Microsoft Access is the ability to work with data quickly and easily. SQL gives you the tools you need to quickly and effectively create a query that will work with your data. The three basic SQL clauses retrieve data, but that isn’t always what you need. Aggregate clauses...

Read more »

3 Basic SQL Clauses in Your Access

Even though SQL is one of the easiest programming languages, there is a lot to learn about it. Understanding the three most basic SQL clauses will help you develop the skills you need to understand the more complex aspects of SQL. Once you have a basic understanding of the different syntactical structures of SQL, you need to learn the details. This lesson covers the three most basic SQL clauses: SELECT FROM WHERE Each of these terms serves a specific purpose within the query....

Read more »