Microsoft Access is a database program that stores and organizes information in tables, letting you search, sort, and report on data without writing code
Access is part of the Microsoft Office suite — the same company that makes Word and Excel. Unlike Excel, which is built for spreadsheets and calculations, Access is built to handle large amounts of organized information. Think of it as a filing cabinet that lets you ask questions about what's inside: "Show me all the tenants who moved in after 2020" or "Which properties have unpaid rent over 30 days old." Access does that work automatically instead of you scrolling through a spreadsheet by hand.
You may encounter Access if you work with housing organizations, nonprofits, government offices, or any business that tracks a lot of related information. Many landlords, property managers, and housing authorities use Access databases to keep records of tenants, leases, maintenance requests, and payments. If someone asks you to "enter data into the Access database" or "pull a report from Access," they mean you're working with one of these organized filing systems.
Key Takeaways
- Access stores information in connected tables rather than single spreadsheets, so you can link tenant records to lease records to payment records automatically.
- You do not need to know how to code to use Access — you can search, filter, and create reports using buttons and forms that work like any other computer program.
- Access is different from Excel because it is designed for large databases with many related pieces of information, while Excel is designed for calculations and analysis.
- Many housing and property management organizations use Access to track tenants, leases, maintenance, and payments in one connected system.
How Access stores information differently than Excel
Excel is a spreadsheet — one big grid where each row is a record and each column is a piece of information. If you have 500 tenants and each tenant has a lease, a payment history, and a maintenance request history, you would need three separate Excel spreadsheets and you would have to manually match them up yourself.
Access uses tables that connect to each other. You have one table for tenants, one for leases, one for payments, and one for maintenance requests. Access remembers which payment belongs to which tenant and which lease because you tell it once how they connect. After that, when you ask "Show me all unpaid rent for tenant 4521," Access finds tenant 4521, looks up their leases, looks up their payments, and shows you only the ones that are unpaid. You do not have to do the matching yourself.
This matters because it saves time and prevents mistakes. If you change a tenant's address in the tenant table, that change shows up everywhere that tenant's information appears. In Excel, you would have to find and change the address in three different places and hope you did not miss one.
What you actually do when you use Access
Most people who use Access do not build the database — someone else (usually called a database administrator or a tech person) sets it up once. You use it by opening forms, which look like paper forms on your screen. You fill in the blanks, click Save, and the information goes into the right table in the right place.
You might also run reports, which are pre-made summaries that Access generates for you. A report might show "All leases expiring in the next 30 days" or "Monthly rent collected by property." You do not write these reports yourself — someone builds them once, and then you click a button to run them whenever you need that information.
You can also query a database, which means you ask it a question. In Access, this looks like filling in a search form: "Show me all tenants in the 90210 zip code who have been here for more than two years." Access finds the answer and shows you the results. This is much faster than scrolling through thousands of records by hand.
Access versus other programs you might use
If you work in housing or property management, you might encounter several different tools. Access is one of them, but it is not the only one. Here is how it compares:
| Program | What it does | When you use it |
|---|---|---|
| Excel | Spreadsheet for calculations, charts, and analysis | When you need to do math, create budgets, or analyze trends |
| Access | Database for storing and organizing large amounts of connected information | When you need to track many related records and search or report on them |
| Google Forms or SurveyMonkey | Tools for collecting information from many people | When you need to gather data from tenants, applicants, or staff |
| Property management software | Specialized programs built specifically for landlords and property managers | When you need features like rent collection, maintenance requests, and tenant screening all in one place |
Many organizations that started with Access have moved to specialized property management software because those programs include features Access does not — like online rent payment, automatic late notices, or tenant portals. But Access is still common in smaller organizations, nonprofits, and government agencies because it is part of Office (which they already own) and it is flexible enough to customize for almost any tracking need.
Why someone might ask you to use Access
If you work for a housing organization, a property management company, or a government office, you might be asked to enter data into Access, run a report from Access, or search an Access database. This is normal work — it is how these organizations keep track of who lives where, who owes what, and what needs to be fixed.
You do not need special training to use Access if someone has already built the forms and reports for you. You just need to know how to use a computer at the level of clicking buttons, typing information, and reading what appears on screen. If you are asked to do something you have never done before, ask the person who manages the database to show you how — that is what they are there for.
Common reasons Access might seem confusing
Access can feel overwhelming the first time you see it because it has a lot of buttons and options. Most of those buttons are for people who build databases, not people who use them. If you are just entering data or running reports, you will use maybe five buttons total.
Another reason Access seems confusing is that different organizations set it up differently. The Access database at one housing organization might look completely different from the one at another organization. There is no single "right way" to build an Access database, so you cannot assume that what you learned at one job will look the same at another job. But the basic idea is always the same: you are putting information into organized tables or pulling information out of them.
Frequently Asked Questions
Do I need to know how to code to use Access?
No. If someone has already built the forms and reports you need, you just use them like any other computer program — click buttons, fill in blanks, and read the results. Coding is only needed if you are building the database from scratch, which is not something most people do.
What is the difference between Access and a spreadsheet?
A spreadsheet like Excel is one flat grid. A database like Access has multiple connected tables that talk to each other. If you have hundreds of related records, Access saves you time and prevents mistakes because you do not have to match information up manually.
Can I use Access on my phone or tablet?
Access is a desktop program designed for Windows computers. You cannot install it on a phone or tablet. Some organizations build web versions of their Access databases so you can use them in a browser, but that depends on whether your organization has done that work.
What happens if I make a mistake while entering data into Access?
You can usually undo your last action by pressing Ctrl+Z, the same as in Excel or Word. If you have already saved the information, ask the person who manages the database — they may be able to fix it or show you how to correct it without losing other data.
Is Access the same as Microsoft 365?
No. Microsoft 365 is a subscription service that includes Access, Word, Excel, and other programs. Access is just one program inside that subscription. Some organizations buy Microsoft 365 for their staff, which gives them access to Access (and the other programs) as part of the package.