Microsoft Access Training Resources
Below you will find useful informational articles , including tips and tricks, how-to articles etc. Content is updated on a weekly basis. We also offer training training on Microsoft Access.
Access Learning Resources:
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
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.
Formatting Text in Access Databases
There are several options for formatting your text in the Datasheet. To change the font face and size using the Ribbon tools, use the following procedure. Read more.
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
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
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
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
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.
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.
Formatting Tables in MS Access - Part A
In this Article, we will learn how to select data and change the height and width of rows and columns. You may select data in a table in a number of different ways. Read more.