A database is a collection of information that’s related to a particular subject or purpose, such as tracking customer orders or maintaining a music collection. Using Microsoft Access, you can manage all your information from a single database file. During my time in college, I have learned how to build and manage a database with access using:
- Tables to store data.
- Queries to find and retrieve the data.
- Forms to view, add, and update data in tables.
- Reports to analyze or print data in a specific layout.
- Data access pages to view, update, or analyze the database’s data from the Internet or an intranet.