What describes a collection of data organized in a manner that allows access retrieval and use of data?

1

2 What is a Database? A collection of data organized in a manner that allows access, retrieval, and use of that data.

3 ACCESS ALLOWS YOU TO: Use a computer to create a database,
add to a database, change data, delete data, sort data, retrieve data, create forms and reports

4

5 Records A record contains informations about a given person, product
or event. Records Each row represents a record.

6 A field contains a specific piece of information within
Each column represents a field Fields A field contains a specific piece of information within a record

7 PRIMARY KEY Unique identifier Your student I.D. number, social security number, fingerprints

8

9 Creating a Table Describe the structure of the table to Access by describing the fields within the table. For each field, you indicate the following:

10 FIELD NAME Each field in the table must have a unique name.
One of a kind

11 Field Names Unique- One of a kind

12 Data Type Data type indicates to Access the type of data the field will contain. Text, Numbers, Pictures, Memo, Currency, OLE Object and others.

13 Data Type

14 Description Access allows you to enter a detailed description of
the field. Tells more about the field.

15 } Description

16 Now it’s your turn to create a structure and table!
Have fun!!!!