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.
Below you will find useful Microsoft Access and Excel database training, including tips and tricks, how-to articles etc. Content is updated on a weekly basis. We also offer training on Microsoft Access.
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.
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.