DePaul University Information Services > Services > Technology Training > Resource Library > Access

Access - A Relational Database

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