Introduction to Access Databases

An Access database is has much more structure than an Excel spreadsheet or a Word document. Data cannot be freely entered into a database. In this series of Access database tutorials we look at the six different objects that live inside an Access database.

Access Tables

Access databases require a data to be stored in a table. Unlike other application like Word or Excel, you have to specify the structure of the data which goes into the table. At first this might seem to be confusing time consuming task. The payoff is that once a table is set up operations like sorting and selecting different records is much, much faster and data integrity is greatly increased.

Access Tutorial – Importing Data

Once we have our first Access table set up the next step is getting data into our Access database. There are several ways of getting data into a database ranging from manually inputting data to uploading data into a table. We will explore all th different methods.

Access Tutorial – Query Basics

Having data in a database is great but the real killer applications of an Access database is a query. Queries allow you to select slices of data stored in an Access database table. You can store the query and re-select the data whenever you like.

Access Tutorial – SQL Basics

Once we have an idea of what Access database queries do one final piece of the puzzle is the SQL statement. SQL is a text “language” that allows us to specify a query in almost English words. SQL is a near universal language among all databases so once you learn it an Access you can apply it to other database systems.