14 min read

What Is Microsoft Access (and Why It's Different)?

What a database actually is, and why Access is a different kind of program from Word or Excel.

You will learn: what Microsoft Access is. what you will build in this course. You will do: read how each lesson is laid out. open the next lesson when you are ready.

What Is Microsoft Access?

Microsoft Access is a program for building a database on a Windows computer. A database is one place to store related facts. At Riverside Public Library we store members, books, loans, and fines. Access saves everything in one file: RiversideLibrary.accdb . That file holds tables, queries, forms, and reports.

You will build RiversideLibrary step by step: 1 Create a blank database file. 2 Create four tables : Members, Books, Loans, Fines. 3 Link the tables with relationships . 4 Ask questions with queries . 5 Enter data on forms . 6 Print lists with reports . Small example data for learning. A real library database may have thousands of records.

Follow the sidebar order. Each lesson adds one piece.

Complete Database Fundamentals first, or read it when a word is new. You need Microsoft Access on Windows (2016, 2019, or Microsoft 365). These pages work in a browser, but the click paths are for real Access on a PC. Mac: Desktop Access for Mac is limited. Use Windows or a Windows virtual machine for the hands-on steps.

Each lesson tells you: What the feature is Why the library needs it Exact steps in Access (tab \to button \to what to type) Expected result — what you should see Try it — a short question or task Playgrounds on the page simulate the Access window. They help you learn. They are not Microsoft Access. For real practice, follow the steps on your PC.

Practice

Which object stores member rows in columns?

Picture a small shop keeping track of customers, orders, and stock across three separate spreadsheets. For a while it works. Then a customer's phone number gets updated in one file but not the other two. An order number gets typed twice by accident. Someone needs "every order from customers in a certain city last month," and the only way to find it is scrolling through hundreds of rows by eye. A database exists to stop exactly that kind of drift. Every fact lives in one place — a customer's address is stored once, not copied into every order — and the computer, not a person, answers questions that would otherwise take an afternoon of scrolling.

Access is Microsoft's take on this idea, built so that ordinary people — not just professional developers — can put a real, working database together: connected tables of information, on-screen forms for typing data in without touching a table directly, and polished reports for printing or sharing results. It has been part of Microsoft Office for decades, and remains one of the more approachable ways for a small business, a classroom, or a club to outgrow a spreadsheet without hiring a database administrator.

This is the single biggest point of confusion for anyone arriving from Excel, so it's worth saying plainly: Excel is a grid built for calculating and arranging numbers however you like on a sheet. Access is a set of structured, connected tables, each dedicated to one kind of thing (customers, orders, products), with rules about exactly what each column may hold, and tools built specifically for asking questions across several tables at once. Excel is flexible; Access is organized. Neither one replaces the other — a later lesson comes back to when each tool is the right choice.

What Is Microsoft Access?

Microsoft Access is a program for building a database on a Windows computer. A database is one place to store related facts. At Riverside Public Library we store members, books, loans, and fines. Access saves everything in one file: RiversideLibrary.accdb . That file holds tables, queries, forms, and reports.

What You Will Build

You will build RiversideLibrary step by step: 1 Create a blank database file. 2 Create four tables : Members, Books, Loans, Fines. 3 Link the tables with relationships . 4 Ask questions with queries . 5 Enter data on forms . 6 Print lists with reports . Small example data for learning. A real library database may have thousands of records.

Follow the sidebar order. Each lesson adds one piece.

Before You Start

Complete Database Fundamentals first, or read it when a word is new. You need Microsoft Access on Windows (2016, 2019, or Microsoft 365). These pages work in a browser, but the click paths are for real Access on a PC. Mac: Desktop Access for Mac is limited. Use Windows or a Windows virtual machine for the hands-on steps.

How Each Lesson Works

Each lesson tells you: What the feature is Why the library needs it Exact steps in Access (tab \to button \to what to type) Expected result — what you should see Try it — a short question or task Playgrounds on the page simulate the Access window. They help you learn. They are not Microsoft Access. For real practice, follow the steps on your PC.

Practice

Which object stores member rows in columns?

Field Notes: Why a Database, Not a Spreadsheet?

Picture a small shop keeping track of customers, orders, and stock across three separate spreadsheets. For a while it works. Then a customer's phone number gets updated in one file but not the other two. An order number gets typed twice by accident. Someone needs "every order from customers in a certain city last month," and the only way to find it is scrolling through hundreds of rows by eye. A database exists to stop exactly that kind of drift. Every fact lives in one place — a customer's address is stored once, not copied into every order — and the computer, not a person, answers questions that would otherwise take an afternoon of scrolling.

Access is Microsoft's take on this idea, built so that ordinary people — not just professional developers — can put a real, working database together: connected tables of information, on-screen forms for typing data in without touching a table directly, and polished reports for printing or sharing results. It has been part of Microsoft Office for decades, and remains one of the more approachable ways for a small business, a classroom, or a club to outgrow a spreadsheet without hiring a database administrator.

Access vs. Excel, in One Paragraph

This is the single biggest point of confusion for anyone arriving from Excel, so it's worth saying plainly: Excel is a grid built for calculating and arranging numbers however you like on a sheet. Access is a set of structured, connected tables, each dedicated to one kind of thing (customers, orders, products), with rules about exactly what each column may hold, and tools built specifically for asking questions across several tables at once. Excel is flexible; Access is organized. Neither one replaces the other — a later lesson comes back to when each tool is the right choice.