Ana səhifə

Microsoft Access is a program to create and manage your databases. It has many built in


Yüklə 32 Kb.
tarix18.07.2016
ölçüsü32 Kb.
Microsoft Access is a program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information.
First of all you need to understand how Microsoft Access breaks down a database. Some keywords involved in this process are: Database File, Table, Record, Field, Data-type. Here is the hierarchy that Microsoft Access uses in breaking down a database.

Database File: This is your main file that encompasses the entire database and that is saved to your hard-drive.

Table:A table is a collection of data about a specific topic. There can be multiple tables in a database.



Field:Fields are the different categories within a Table. Tables usually contain multiple fields.

Datatypes:Datatypes are the properties of each field. A field only has 1 datatype.

Primary keys are one or more fields (columns) whose value or values uniquely identify each record in a table. A primary key does not allow Null values and must always have a unique value.

After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.


A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a key in the other table.

A form is nothing more than a graphical representation of a table. You can add, update, delete records in your table by using a form.

A report is an effective way to present your data in a printed format. Because you have control over the size and appearance of everything on a report, you can display the information the way you want to see it.

FILL THE BLANKS WITH ONE OF THE FOLLOWING WORDS: categories, printed, identify, features, field, keywords, graphical, matching, topic, tables, breaks down, delete, reports, entire, identifier.

Microsoft Access is a program to create and manage your databases. It has many built in ………… to assist you in constructing and viewing your information.
First of all you need to understand how Microsoft Access ………… a database. Some ………… involved in this process are: Database File, Table, Record, Field, Data-type. Here is the hierarchy that Microsoft Access uses in breaking down a database.


Database File: This is your main file that encompasses the ………… database and that is saved to your hard-drive.

Table:A table is a collection of data about a specific …………. There can be multiple tables in a database.



Field:Fields are the different ………… within a Table. Tables usually contain multiple fields.

Datatypes:Datatypes are the properties of each …………. A field only has 1 datatype.

Primary keys are one or more fields (columns) whose value or values uniquely ………… each record in a table. A primary key does not allow Null values and must always have a unique value.

After you've set up multiple ………… in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and ………… to display information from several tables at once.


A relationship works by ………… data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique ………… for each record, and a key in the other table.

A form is nothing more than a ………… representation of a table. You can add, update, ………… records in your table by using a form.



A report is an effective way to present your data in a …………format. Because you have control over the size and appearance of everything on a report, you can display the information the way you want to see it.


Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©atelim.com 2016
rəhbərliyinə müraciət