A database helps store and manage information in a systematic way. Microsoft Office Access 2007 is a database system that can help you easily retrieve and update your business data. It also helps you process information effectively to meet various business needs.


An Access database is a relational database contained in a single file that you can use it offline to store large quantity of data, it can also be used online for some data-driven web site such as an online store.

The basic components of an Access database include tables, forms, reports, queries, macros, and modules. A database table stores data in rows and columns. Tables are similar to spreadsheets. However, unlike spreadsheets, tables organize data in a systematic manner. Forms are also called data entry screens, act as a user-friendly interface to work with your data. They contain various commands and help control user interactions.

Reports in an Access database help present data in a readable format. A report always presents the current data in the database. You can view, print, and export a report. Queries help retrieve data from various tables and display it in a single datasheet. They also function as the record source for forms and reports. You can also use queries to perform tasks with data.

In an Access database, macros act as a simplified programming language and help add functionality to the database. You can use them to automate most database operations, such as opening a report, running a query, or closing the database. Modules also help add functionality to the database. Modules are written using the Visual Basic for Applications (VBA) programming language.

In an Access database, data is stored in different subject-based tables. Access 2007 uses primary key fields to link data from multiple tables and arrange it in a logical way. A primary key is defined as a field or a set of fields that functions as a unique identifier for every row in a table. For instance, a student’s unique student ID number can be the primary key in the STUDENTS table.

If you are interested in learning more about database and Access, you may consider taking a training course.