Quiz 3

Question 1

Data

Answer 1

A collection of numbers and text

Question 2

Table

Answer 2

A list of data organized into fields and records

Question 3

Data type/Field type

Answer 3

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

Question 4

DBMS

Answer 4

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

Question 5

Report

Answer 5

Structures for written output of data

Question 6

Structured Query Language (SQL)

Answer 6

The language you use to talk to a database

Question 7

Information

Answer 7

Meaning derived from data

Question 8

QBE

Answer 8

MS Access 2010 supplies a graphical user interface (GUI) called the Query By Example Grid or (QBE) grid

Question 9

Fields

Answer 9

A piece of a table containing data type

Question 10

Foreign key

Answer 10

A field that defines a relationship between 2 tables.

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

Question 11

Database

Answer 11

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

Question 12

Query

Answer 12

Question structures to sort, filter and select specific information
Used to extract information from a database
A request for information from a database
To extract information from the Database you must use a Query which is a “question” or “request”

Question 13

Criterion

Answer 13

An expression that tells the DBMS which records to retrieve

Question 14

Form

Answer 14

Structures for screen views of data
Structures for screen view and input of information
Used to simplify viewing and inputting of information

Question 15

Primary Key

Answer 15

A field, or combination of fields, which uniquely identifies a record in a database

Question 16

Referential Data Integrity

Answer 16

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 17

Cascade Delete Related Records

Answer 17

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

Question 18

Cascade Update Related Records

Answer 18

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

Question 19

Requirements of a valid foreign key

Answer 19

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

Question 20

Creation of dynasets

Answer 20

Dynaset only includes records that have matching keys on both tables. This is called an inner join which is the default join type in Access.
When you run the query a dynaset, or subset of the database is displayed.
You can make changes to this dynaset and the changes will be reflected in your database, because the dynaset is just a view of your database

Question 21

Field Properties

Answer 21

– Field size
– Input Mask
– Validity
– Default Value