Tracking Changes in MS Excel

Microsoft Access

Training Resources

Below you will find useful information, including tips and tricks, how-to articles etc. Content is updated on a weekly basis. We also offer training on Microsoft Access.

An Introduction to Access Databases

An Introduction to Access Databases

Access is a relational database. A relational database is a collection of data items organized as a set of tables. In this lesson, you’ll get a chance to familiarize yourself with the basic components of the database. First, we’ll look at some common database terms. You’ll also take a closer look at the Navigation pane. We’ll introduce tables, table relationships, queries, forms, and reports. Read more.

Performing Basic Access Database Tasks

Performing Basic Access Database Tasks

This lesson focuses on tables. You’ll learn how to enter and edit data in the Datasheet view of a table. Next, we’ll look at using the clipboard to cut, copy, and paste data to and from different fields. Read more.

Getting Started in Access

Getting Started in Access

This lesson is for students new to Access 2013, and focuses on getting started with Access 2013, signing into a Microsoft account, creating, saving, and opening a database. Read more.

Access Database Terminology

Access Database Terminology

There is specific terminology that is used to refer to the basic elements that databases are comprised of. Let's examine the most commonly used database terminology. Read more.

Access Database Relationships

Access Database Relationships

Relationships define a database. The power of a database lies in the way the tables are related to each other. Nearly every database that contains multiple tables also includes relationships between these different sets of information. There are three types of table relationships: one-to-many, many-to-many, and one-to-one. Let's learn about each type. Read more.

Working with Records

Working with Records

To add records to a table, you have the option of entering them manually, using a form, or using the import tools on the External Data tab. As the database we are using does not have a form for it yet and we do not have external data we can import into it, we will add records manually. Read more.

Open Database Objects

Open Database Objects

In this Article, we will learn how to open database objects in Microsoft Access. To open any objects that are listed inside the Navigation Pane, double-click on their listing. Read more.

Managing Objects

Managing Objects

In this Article, we will learn how to manage objects in Microsoft Access. There are a number of ways you can manage your objects using the Navigation Pane in Access 2013. All of these ways may be accessed by right-clicking on the object you would like to work with. Read more.

More Resources