Question

explain the components of the access window​

Answer 1

Answer:

The Microsoft® Access Database is made up of 7 major components:

Tables;

Relationships;

Queries;

Forms;

Reports;

Macros;

Modules.

Explanation:

1. Tables

Tables are responsible for storing information within the database. You will notice that the tables in Access look similar to the ones in Excel. They contain columns and rows. Each column has a name at the top, and each row has a number.

If you don’t set up the tables correctly, the database might give you the wrong results. Improper tables can also lead to slow or unpredictable performance, so take your time setting up the tables appropriately.

2. Relationships

Relationships are essentially the “connections” or “bonds” that are formed between tables. Tables can be related in one of three ways: one-to-one, one-to-many and many-to-many.

3. Queries

Queries are requests for information. Queries can sort, calculate, filter, update data and more based on the results you are looking for.

4. Forms

According to Access, a form is a database object that can be used to create a user interface for a database application. A bound form is linked to a data source, whereas an unbound form does not.

5. Reports

Once you have data entered into the database, you can run reports to view, summarize or format various information. Reports cannot be edited as forms can, but you can pick and choose the information you want to compare before creating the report.

6. Macros

Macros perform a series of actions based on how you enter them. For example, you can create macros that will open forms, change values, run queries and even run other macros. Thanks to macros, you can automate certain tasks and improve efficiency when using the database.