Skip to content
Tutorials Center
My learning

Topics

Lesson 3 of 36 ยท Getting Started

Creating Your First Access Database

Create a blank Access database, choose a safe file location, build your first table, enter data, save, back up and reopen it. Includes a runnable SQL version.

Time to build something. In this lesson you create a blank database for a small book-lending shelf, add a table, enter a few records, save and reopen the file and make a backup. The example is deliberately tiny, so you can focus on the workflow rather than the data.

The steps below describe the Microsoft 365 version of Access. Menus in Access 2016, 2019 and 2021 are nearly the same.

Step 1: Start with a blank database

  1. Open Access. The start screen lists templates on the left and your recent files below them.
  2. Click Blank database (some versions call it Blank desktop database).
  3. In the panel that appears, type a File Name, for example BookShelf. Access adds the .accdb extension for you.
  4. Click the folder icon next to the name to choose where to save. Pick a folder you back up, such as Documents, not a temporary or downloads folder.
  5. Click Create.

Access creates the file and opens a new empty table called Table1 in Datasheet view. It also selects the first field, ID, which is an AutoNumber primary key.

Avoid spaces and special characters in file and object names. BookShelf is easier to use in code and in queries than Book Shelf (new). If you do use spaces later, you must wrap names in square brackets in SQL, like [Book Title].

Step 2: Add fields in Datasheet view

The new table has two columns: ID and Click to Add. To add a field:

  1. Click the Click to Add header.
  2. Choose a data type from the list, such as Short Text or Number.
  3. Type the field name and press Enter.

Build a Books table with these fields:

Field Type Meaning
ID AutoNumber (already there) Unique number for each book
Title Short Text The book title
Author Short Text The author's name
YearPublished Number Year of publication
OnLoan Yes/No Whether the book is currently lent out

To rename the ID field, double-click its header and type BookID. A clear name helps you later when other tables refer to it.

Step 3: Enter data

Type directly into the grid, like a spreadsheet. Press Tab or Enter to move to the next field. When you leave a row, Access saves the record immediately. There is no separate Save step for data, only for the structure of the table.

Enter these three books:

BookID Title Author YearPublished OnLoan
1 The Silent Orchard Ines Varga 2011 No
2 Maps of Salt Tomas Reyes 2019 Yes
3 A Short Winter Ines Varga 2022 No

The OnLoan column shows check boxes. A ticked box means Yes (stored as -1 internally); an empty box means No (stored as 0).

The same table in SQL looks like this. SQLite, which runs below, stores Yes/No as 0 and 1, while Access stores 0 and -1.

SQL The Books table in SQL

Press Run (or Ctrl + Enter) to see the result here.

Step 4: Save the table

Click the Save icon on the Quick Access Toolbar, or press Ctrl+S. Access asks for a table name. Type Books (the table name is not the same as the file name) and click OK. If you close the table without saving, Access asks the same question.

Naming conventions help as a database grows. A few that work well:

  • Use plural nouns for tables: Books, Members, Loans.
  • Use PascalCase with no spaces: LoanDate, not Loan Date.
  • Do not prefix tables with tbl unless your team insists. The Navigation Pane already groups objects by type.

Step 5: Look at the table in Design view

Switch to Design view from Home > View > Design View. You see the field list on top with Data Type and Description columns, and the Field Properties pane below.

Notice that BookID has a key icon at its left. That marks the primary key, the field whose value is unique for every record. You will study keys in a later lesson.

Add a description, such as Book title as printed on the cover, in the Description column of Title. This appears in the status bar when you click the field in a form, and helps anyone who inspects the table later.

Step 6: Run your first query

Go to Create > Query Design. In the Show Table dialog, double-click Books and click Close. Double-click Title and Author in the field list to add them to the grid. Under Author, in the Criteria row, type:

Text
"Ines Varga"

Click Run (the red exclamation mark). Access displays the two books by Ines Varga. Switch to SQL View to see what Access wrote:

SQL
SELECT Title, Author
FROM Books
WHERE Author = "Ines Varga";

Access SQL accepts double quotes around text. Standard SQL uses single quotes, which also work in Access, so the runnable example below uses them.

SQL Your first query

Press Run (or Ctrl + Enter) to see the result here.

Save the query as BooksByVarga and close it.

Step 7: Close, reopen and back up

To close the database, use File > Close. To reopen it, choose File > Open or pick it from the recent list.

Backing up an Access database is simple, but you must do it while the file is closed or use the built-in command. The recommended command is File > Save As > Back Up Database. Access suggests a name that includes today's date, such as BookShelf_2026-05-01.accdb.

A few habits will save you pain:

  • Back up before major design changes. Undo does not apply to structural changes.
  • Never edit a file stored only in a synced folder while others have it open. Cloud sync tools can corrupt a database that is open on two machines.
  • Do not copy a database while it is open if you can avoid it. A .laccdb file next to your .accdb is the lock file that shows someone has it open.

If Access shows a yellow Security Warning: Some active content has been disabled bar when you open a file, that means the file contains macros or VBA and is not in a trusted location. Your database from this lesson has none, but you will meet the bar again. See File Formats, Templates and Trusted Locations.

Common beginner mistakes

  • Saving in a temporary location. Pick a real folder in the first dialog.
  • Entering data into the wrong view. Type data in Datasheet view; use Design view only for structure.
  • Skipping the primary key. Every table needs one. A default ID field costs nothing.
  • Putting two facts in one field. Typing Ines Varga, 2011 in a single cell makes it impossible to sort or filter by year. Split it into two fields.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What file extension does a modern Access database use?

    Access 2007 and later use .accdb. The older .mdb format is still readable but lacks newer features.
  2. 2. When is a datasheet record saved?

    Access commits a record as soon as you leave it. Ctrl+S saves the table design, not the data.
  3. 3. Which command makes a dated copy of the open database?

    Back Up Database in the Save As screen suggests a name with today's date and copies the file safely.
  4. 4. How is a Yes/No field stored in Access?

    Access stores True as -1 and False as 0, even though a check box is shown. SQLite and many other systems use 1 for true.

Summary

  • Create a database with Blank database, choose a name and a safe folder, then click Create.
  • Add fields in Datasheet view with Click to Add, type data directly and Access saves each record when you leave it.
  • Save the table design with Ctrl+S and give it a clear plural name.
  • Design view shows field types and the primary key; Create > Query Design builds your first query.
  • Back up with File > Save As > Back Up Database before big changes.

Next: File Formats, Templates and Trusted Locations