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.