Skip to main content
Workforce LibreTexts

5.6: Naming Databases

  • Page ID
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    Learning Objectives

    • Name the database and location
    • Discuss the role of tables in access
    • Differentiate among types of tables
    Microsoft Access Blank database screen with Field "File Name" filled with the name "Database1.accdb". File folder button is to the right of the File Name field. This button allows the user to edit the location of the database.

    Enter the name of your database in the “File Name” field. The database location can be changed by selecting the box to the right of the “File Name” field and browsing to the location of your choice.

    Understanding Tables

    Tables are one of the key objects in Access. Access uses tables to store data. To store data, you create one table for each type of information that you track. Types of information might include customer information, products, or order details.

    The example below is taken from the Microsoft Access “Northwind Traders” sample database. It is a table containing a list of orders for the fictitious company with reference to Order Number, Order Date, Order Status, etc.

    Microsoft Access “Northwind Traders” sample database titled "Order List".

    Types of Tables

    There are three types of tables in Access: an object table, a transaction table, and a join table. Object tables contain data relating to a real-world object, like a company or a customer or a product. Transaction tables store information pertaining to events, like when an order is placed for a product or an invoice is sent to a customer. Finally, join tables are used to establish a relationship between two tables, like a product table and a customer table.

    We will focus on object tables in this section.

    Contributors and Attributions

    CC licensed content, Original
    • Naming Databases. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    5.6: Naming Databases is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?