What is a tool used to organize, store, retrieve,and communicate (report on) groups of related information?
100
In a database table, rows are called?
Records
100
What is the default format for all data types?
Text
100
Field size, format, input mask, and caption are examples of what?
Field property
100
Select Sort or Filter:
Based on the correct data management technique used to solve the statement.
Which county has the highest?
Sort
200
What is an entry?
A single piece of data in a database table is called what?
200
In a database table, a columns are called?
Fields
200
Which is an example of field data that has been formatted as currency?
A. 45.00
B. $45.00
C. 45.
D. Forty-five dollars
B
200
What is used to control how data is entered in a field?
Field property
200
What criterion will result in NASCAR drivers who have led at least 500 laps this season?
A.<=500
B.>=500
C.=500
D.<>500
B
300
What stores data in rows and columns?
Table
300
What Microsoft Program is used to create databases?
Access
300
Which data type will allow a doctor's office to make notes or comments about patients?
Memo
300
The ability to query by ____ is when a database entity is selected as an example of the criteria to be queried.
A. sample
B. example
C. cell
D. field
What is example
300
Select Ascending or Descending:
Based on the correct Sort order to solve the statement.
The cities with the MOST snow days were listed first.
Descending
400
What is a complete description of all fields related to one item in a database table is called?
Record
400
All of the following are examples of "real world" databases EXCEPT a/an:
a. Telephone books
b. E-bay (online businesses)
c. Video games
Video games
400
Doctor ID Last Name First Name Phone
90 Paxton Perry 332-3535
321 Pines Penny 678-1010
15432 Pauls Pam 456-1222
343433 Price Phillip 343-1323
In this database table, Perry is a what?
Entry
400
Doctor ID Last Name First Name Phone
90 Paxton Perry 332-3535
321 Pines Penny 678-1010
15432 Pauls Pam 456-1222
343433 Price Phillip 343-3434
In this database table, all the information about Price is called a what?
Record
400
What allows for retrieval information that meets specific criteria?
Filter/Query/Search
500
What is a grouping or category of similar information contained in a table?
Field
500
What is the first step in creating a database?
Plan the structure
500
What is used to control how data in a data in a particular field will be searched, sorted, or used in calculations?
Data Types
500
Doctor ID Last Name First Name Phone
90 Paxton Perry 332-3535
321 Pines Penny 678-1010
15432 Pauls Pam 456-1222
343433 Price Phillip 343-1323
In this database table, first name is called a what?
Field name
500
What allows information to be arranged in a specific order ascending (A to Z) or descending (Z to A)?