Access Terms

Question 0

Meaning derived from the data

Answer 0

Information

Question 1

A collection of numbers and text

Answer 1

Data

Question 2

A large collection of data stored in a well-defined structure

Answer 2

Database

Question 3

A collection of programs that enable you to enter, organize, and select data in a database

Answer 3

DBMS

Question 4

An entity used to organize information by categories of like information

Answer 4

Table

Question 5

An attribute (piece of information) of the table/entity

Answer 5

Field

Question 6

Defines the type of information that can be stored. i.e. text, numbers, dates, etc.

Answer 6

Data type / field type

Question 7

A field, or a collection of fields, whose values uniquely identify each record in a table

Answer 7

Primary key

Question 8

Referential data integrity

Answer 8

A set of rules that specifies what records may exist in each table
–A record input with a foreign key must always have a matching record in the primary key table in the relationship

Question 9

Question structures to sort, filter and select specific information

Answer 9

Query

Question 10

Structures for screen views of data

Answer 10

Form

Question 11

Structures for written output of data

Answer 11

Report

Question 12

The language you use to talk to the database

Answer 12

Structured Query Language

Question 13

QBE grid

Answer 13

Query by example grid

Question 14

A field that defines the relationship between 2 tables

Answer 14

Foreign key

Question 15

Relationship rules

Answer 15

•Must be a primary key (unique) in at least one of the tables
•The field names on each table do not have to match as long as the information is the same.
•The related fields must be the same data type
– number, text etc.

Question 16

Removing any entry in a primary key field will automatically remove all entries in foreign key fields of related tables

Answer 16

Cascade delete related records

Question 17

Updating any entry in a primary key field will automatically update all entries in foreign key fields of related tables

Answer 17

Cascade update related records

Question 18

Related information input into the table

Group of fields

Answer 18

Record

Question 19

Hierarchy of data in a database

Answer 19

File
Table
Record
Field
Data type or Field type (also field properties)