Access

Record

A collection of characteristics which collectively describe a person, place, or thing.

What database design principle does the setting of relationships support (this is together with the proper design of the database, which includes the proper atomization of data for tables)? Cascading updates and deletes through tables and making sure data is normalized Ensuring accuracy and consistency Avoiding redundancy None of the answers given

Avoiding redundancy

Common field

Fields in two (or more) different tables that match (same data type and size)

What is the direct output of a correctly constructed query which has results? (Select the single best possible answer below) query report form table

table

Which data type(s) should be used for the Address category shown in the table below? (Select the best answer that will fit) Data Number Other Text

Text

Which of the following data types should be used for the PHONE category? (Select the best answer that will fit) Other Date Text Number

Text

Select all that apply to the criteria used in queries applied to selected fields in the data in order to answer questions: a criteria in a query can be used to detect something occuring on a particular date a criteria in a query can be used to create a new field and construct the contents of the field the criteria in the queries can be used to detect empty fields the criteria in the queries help to filter the data a criteria in a query can be used to construct a new field and ask the user to provide the contents of that field the criteria in the queries can be used to detect whether a numeric or currency amount is less than or greater than a given amount

(all options) a criteria in a query can be used to detect something occuring on a particular date a criteria in a query can be used to create a new field and construct the contents of the field the criteria in the queries can be used to detect empty fields the criteria in the queries help to filter the data a criteria in a query can be used to construct a new field and ask the user to provide the contents of that field the criteria in the queries can be used to detect whether a numeric or currency amount is less than or greater than a given amount

Choose one of the following: (select the single best possible answer below) (a) Choice 1: a form or report holds the data ready for display (b) Choice 2: a form or report holds the instructions for how the data is to be displayed but must be run afresh each time to ascertain any new changes to the data Neither choice is correct (b) Choice 2 from above (a) Choice 1 from above

(b) Choice 2 from above

Table

A collection of people, places, or things which collectively are a group which are similar.

Database

A collection of tables, forms, queries, or reports.

Report

A group of selected characteristics (or columns) in a particular format which may be sorted. It is typically a regular function.

Is Null Query

A query which can determine which field is blank for a record.

The principle of database design supported by DATATYPES in a database

Accuracy and Consistency

The principle of database design supported by database RELATIONSHIPS

Avoiding Redundancy

What database design principle does (a) the setting of datatypes as well as (b) the limiting of the field sizes support? (Choose the single best answer). Avoiding Redundancy None of these answers Enforcing Accuracy and Consistency Cascading Updates and Deletes and ensuring data is normalized

Enforcing Accuracy and Consistency

What database design principle does use of a Form for entry of data support? (Choose the single best answer). Avoiding redundancy None of these answers Cascading Updates and Deletes and Keeping data normalized Ensuring accuracy and consistency

Ensuring accuracy and consistency

Which of the following data types should be used for the Birthday category? (Select the best answer that will fit) Text Other Date Number

Date

Foreign Key

Each value points to a primary key in another table.

Consider the two tables shown below, the Student Info table (the first table) and the Student Billing table (the second table). When the tables were set up, relationships were set for the tables. A correctly set relationship window is illustrated below the two tables. However for the two tables to be out of balance as they are shown below, one of the three small check boxes in the relationship window was not checked. Question: Which of the check boxes in the relationship window was not checked? ------------------------------------------------------------------------ The Enforce Referential Integrity box The Cascade Update Related Fields Enforce Cascade Delete Related Records

Enforce Cascade Delete Related Records

Inside the database, in which of the following types of objects does the data reside in? (Select the single best possible answer below) In the reports In the forms In the queries In the tables

In the tables

Field

Is a single piece of information describing a characteristic of a person, place, or thing.

Which of the following data types should be used for the BATH category? (Select the best answer that will fit) Date Number Other Text

Number

Query

Primarily used to select a group of records (thought of as rows) from table(s) with a common set of characteristics of interest to the user. It is typically a regular function.

Sorting

Puts selected information in order (alphabetical, numerical, or dates) and can be used in any feature of the database.

Redundancy (definition)

Repetition of information in a database indicating poor design.

Data Atomization

The process of reducing information to its smallest constituent useful size.

Primary Key

The unique field (or fields) required to unambiguously identify a record in the home table.

What is a database? (Select the best definition of phrase from those below) a collection of data tha is organized a huge mass of data a huge mass of data that is organized a collection of data that is organized by its relations

a collection of data that is organized by its relations

Example of redundancy

Two or more tables in a database that store a customer's address.

Form

Used to display information one record at a time.

Queries use criteria to sort and ________ data to answer questions. (Find the single best answer below to fill in the blank) filter create hierarchies of none of the answers given delete

filter

What is the input of a query? (Select the single best possible answer below) another query only a single table a form a report one or more tables

one or more tables