What is a tool used to organize, store, retrieve and communicate groups of related information.
100
Field properties are used to control how data is entered into a field.
What is TRUE?
100
Difference between field and record in regard to a database.
What is a grouping or category of similar information contained in a table (field) and a complete description of all the fields related to one item in a table (record).
100
Define LookUp Wizard.
What is a datatype used to define preset values for database entries. This increases productivity and accuracy.
100
The building blocks of ALL databases. An arrangement of columns (fields) and rows (records).
What are tables?
200
Used to control how data in a particular field will be searched, sorted or used in calculations.
What are data types?
200
An autonumber can never be used as a primary key.
What is FALSE? It makes a great one = unique identifier
200
Many-to-Many database relationships are formed by connecting 2 or more tables that have a one-to-many relationship -- this connection is called _________.
What is a junction table?
200
____ allow for information to be arranged in a specific order such as alphabetical, chronological, ascending or desending.
What is a sort?
200
The effectiveness of a database can be measured by the user's ability to retrieve useful information is called what?
What is database management?
300
Join line
What is a graphical representation of the link between 2 or more tables?
300
You do not have to have a primary key for each database table.
What is FALSE? Primary keys format each record as a unique entity.
300
Define and name 2 types of filters
What are filter by selection (filters for information related to an active cell) and filter/advance filter sort (used to define specific search criteria).
300
This protects related data that is stored in multiple database tables.
What is referential integrity? (i.e. autonumber, student ID, Employee SS#)
300
Difference between a filter and query.
What is a one time deal/temporary and sorts records in a table (filter) and is reusable which uses selection criteria (query).
400
Define Query.
What is a database object created by placing filters and selecting multiple criteria (comparision operators) to extract information from one or more tables. The resulting data becomes an object that can be saved, recalled and used to perform other operations.
400
A group footer in a database report is used to display sums, counts or averages of groups of data.
What is TRUE?
400
Ms. Draime gave a 5.02 Database quiz to her students and wants to display the students who made an 85 or higher --- what would she use to show this data?
What is a filter? (she needs to sort her database to show had an 85 or higher).
400
Name at least 5 data types for databases.
What are text, memo, number, date/time, currency, auto number, Yes/No, and Lookup Wizard?
400
What are forms within forms called?
What are subforms?
500
Define report and name some components.
What is a database object used to organize, summarize and print data from database tables. Components include: Report header, page header, group header, detail section, group footer and page footer.
500
Page headers of a database report are only located on the first page.
What is FALSE?
500
Name the 4 database objects.
What are tables, queries, forms and reports?
500
Name and define 2 conditinal operators.
What are AND (reduces the number of records because both conditions must be met) and OR (increases the number of records because one or the other condition must be met).
500
Name 3 or 4 advantages of using a database form.
What are searching for information is faster; data entry is faster; easy to read and understand and allows information to be censored.