Microsoft Access is a computer application used to create and manage computer-based relational databases on desktop computers and/or on connected computers (a network). Access allows a user to create relational databases that have tables of data. Using these tables with a built-in query tool, users create reports.
A database is a collection of information. The database is stored as a single file. Each file then contains database elements, which are components. The different Access database elements are:
Tables store information. Tables are the foundation.
Queries are used to perform actions on a table. This actions include choosing data that meet certain criteria and be manipulated and sorted.
Forms are used to create and arrange data. They are an easy way to view or change data in a table.
Reports provide a mechanism to extract and display data. They are easy to create to display where information is displayed on a page, how it's grouped and sorted and how it's formatted.
Macros are mini-programs that automate tasks.
Access Resources for Windows