When is it sufficient to use a list to organize data?
when the data is simple and can be organized in one table
Which is NOT a component of a database that describes how data is stored?
report
The type of database that uses fields, records, and measure as data attributes is
multidimensional
Which of the following is NOT considered meta data?
table name
Data captured from websites as users navigate through a website is called?
clickstream data
Which of the following database systems uses artificial intelligence?
knowledge-based system
A field labeled PHONE that accepts data such as (610) 555-1212 would use the Number data type.
False
A query is used extract a subset of data from a database.
True
A small slice of a data warehouse is called a data mine.
False
Data warehouses capture data from only one time period.
False
Which of the following is NOT part of a design plan for a database?
Develop the forms
The two types of objects responsible for collecting data are
tables and forms
Which is NOT a Microsoft Access database object?
Slides
Which database object enables you to ask questions of the database?
Queries
When creating a table in Design view, you can add each of the following EXCEPT
Table sizes
A _ enables users to view or enter data one record at a time.
form
Which data type enables you to store numeric values that need to be calculated?
Number
A database___organizes information into fields and records.
table
The Form _ prompts you step-by-step through the creation of a form.
Wizard
The Access data type used to automatically assign an incremental number is __
AutoNumber
To use data from two tables, you must create a ___ between them.
relationship
The duplication of data in a database is called data ___.
redundancy
The ___ field must be a unique identifier of each record in a database.
primary key
A Short Text field can store no more than 100 characters.
False
Autonumber Datatypes are generally used for calculation fields such as price.
False
When you enter data using a form, the data in the underlying table is also updated.
True
table
a collection of data
field
a category of data
join line
used to create a relationship between two tables
form
allows editing of individual records
database
a collection of objects
