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, 4 5 Records A record contains informations about a given person, product 6 A field contains a specific piece of information within 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. 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 15 } Description 16 Now it’s your turn to create a structure and table! |