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