True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
A database is given a descriptive name once all of the data has been
entered.
|
|
|
2.
|
A table is a database object that stores data.
|
|
|
3.
|
Each table in a database is related to another table by one field.
|
|
|
4.
|
In an RDBMS, repeated data between tables are in the columns that create a
relationship.
|
|
|
5.
|
Developing a database schema requires planning before working in Access.
|
|
|
6.
|
A well-designed database has fields that store two pieces of data.
|
|
|
7.
|
Duplicate field names can be used in a table.
|
|
|
8.
|
All data in a table must be the same type.
|
|
|
9.
|
Text fields can store a maximum of 10 characters.
|
|
|
10.
|
AutoNumber fields automatically store a numeric value that is ten greater than
that in the last record.
|
|
|
11.
|
Entering .5 in a field formatted as percent
displays 50%.
|
|
|
12.
|
The columns in a table are called records.
|
|
|
13.
|
A primary key prevents duplicate records in a table.
|
|
|
14.
|
A First Name field is a good candidate for a primary key field.
|
|
|
15.
|
The primary key column in a table can contain duplicate entries.
|
|
|
16.
|
Access displays a new table when a database is created.
|
|
|
17.
|
A table should be created in Datasheet view in order to control all aspects of
the table.
|
|
|
18.
|
A primary key can be defined as a combination of data in two fields if that is
what is required to make every record in a table unique.
|
|
|
19.
|
The  symbol is displayed next to a primary key in Design
view.
|
|
|
20.
|
A simple form shows the data for one record.
|
|
|
21.
|
Lookup fields in a form contain an arrow for selecting an entry.
|
|
|
22.
|
A single piece of data for a field is called an entry.
|
|
|
23.
|
A form displays all the fields for one record.
|
|
|
24.
|
In Datasheet view, the order in which fields appear can be changed by dragging a
field to a new location.
|
|
|
25.
|
Datasheet view displays one record at a time.
|
|
|
26.
|
Datasheet view is useful for comparing records.
|
|
|
27.
|
In Access, records can be sorted in ascending order only.
|
|
|
28.
|
When filtering, records that do not meet a specified criteria are removed from
the datasheet permanently.
|
|
|
29.
|
If a filter has been applied to a datasheet, only the visible records will
print.
|
|
|
30.
|
A field can be renamed.
|
|
|
31.
|
Deleting a form removes all records from the database.
|
|
|
32.
|
Records in a database never need to be updated.
|
|
|
33.
|
Data copied from Access is pasted as a table in a Word document.
|
|
|
34.
|
Imported data can be appended to an existing table.
|
|
|
35.
|
Adding record information to a database is called ‘populating’ the
database.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
36.
|
A relational database management system
a. | is any data that is stored on a computer. | b. | is the computer
application used for creating a database. | c. | groups unrelated data in
forms. | d. | is a primary key. |
|
|
|
37.
|
Which is used to run, open, and manage the objects of a database?
a. | Office Button | c. | Navigation Pane | b. | Quick Access Toolbar | d. | database schema |
|
|
|
38.
|
A term that describes the duplication of data is
a. | double data. | c. | database schema. | b. | data redundancy. | d. | data
validation. |
|
|
|
39.
|
Which is a description of the data and the organization of data into tables in a
relational database?
a. | RDBMS. | c. | database schema. | b. | data redundancy. | d. | data
validation. |
|
|
|
40.
|
Columns in a table are called
a. | schemas. | c. | records. | b. | fields. | d. | files. |
|
|
|
|
|
|
41.
|
How many fields are there in the table above?
|
|
|
42.
|
Which field in the table above is an AutoNumber field?
a. | Order ID | c. | Product ID | b. | Order Date | d. | Quantity |
|
|
|
43.
|
Which is true when choosing a field name?
a. | A field name should end with the letters
name. | b. | A field name should be the shortest name that accurately describes the contents of
the field. | c. | A field name should consist of abbreviations when possible. | d. | Field names should
contain special characters. |
|
|
|
44.
|
Which would be the most appropriate field name to represent a field that will
contain a person’s last name?
a. | Lst Nme | c. | LastName | b. | Name | d. | Last*Name |
|
|
|
45.
|
Which is not a field type?
a. | currency | c. | entry | b. | date/time | d. | text |
|
|
|
46.
|
Which field type stores dollar amounts?
a. | currency | c. | dollar | b. | date/time | d. | money |
|
|
|
47.
|
Which field type stores data retrieved from a field in another table?
a. | hyperlink | c. | yes/no | b. | memo | d. | lookup |
|
|
|
48.
|
Which field type stores a file?
a. | hyperlink | c. | attachment | b. | memo | d. | lookup |
|
|
|
49.
|
Which field type stores several lines of text?
a. | hyperlink | c. | attachment | b. | memo | d. | lookup |
|
|
|
50.
|
Which field format displays numbers exactly as they are typed?
a. | fixed | c. | percent | b. | general | d. | standard |
|
|
|
51.
|
Which is not a date/time field format?
a. | short | c. | long | b. | medium | d. | lookup |
|
|
|
52.
|
A field that contains unique data so that each record in a table is unique is
designated as the
a. | primary key. | c. | query field. | b. | unique field. | d. | key field. |
|
|
|
53.
|
A row in a datasheet contains
a. | a record. | c. | all the entries for one field. | b. | a field
name. | d. | all the records for
one field. |
|
|
|
54.
|
Which is a database object used for entering records into a table?
a. | table | c. | form | b. | field | d. | record |
|
|
|
55.
|
Which is not a kind of form?
a. | simple | c. | multiple items | b. | split | d. | complex |
|
|
|
56.
|
Which view is where records are entered?
a. | Design view | c. | Form view | b. | Layout view | d. | Datasheet view |
|
|
|
57.
|
A form’s record controls are used to
a. | display a specific record. | c. | change a column's
width. | b. | format a record. | d. | switch to Datasheet view. |
|
|
|
58.
|
Populating the database refers to
a. | adding records. | c. | defining fields. | b. | creating a form. | d. | developing a database
schema. |
|
|
|
59.
|
To move to the previous entry box in a form, press
a. | the Tab key. | c. | Shift+Tab. | b. | the Enter key. | d. | the Backspace
key. |
|
|
|
|
|
|
60.
|
Which view is the table above displayed in?
a. | Design view. | c. | Form view. | b. | Datasheet view. | d. | Layout view. |
|
|
|
61.
|
How many records are displayed in the table above?
|
|
|
62.
|
To increase the width of a column in Datasheet view,
a. | double-click the column letter. | c. | drag its right
boundary. | b. | double-click the field name. | d. | drag its left
boundary. |
|
|
|
63.
|
Placing records in a specified order is called
a. | organizing. | c. | sorting. | b. | querying. | d. | updating. |
|
|
|
64.
|
Displaying records based on a specified criteria is called
a. | organizing. | c. | sorting. | b. | filtering. | d. | updating. |
|
|
|
65.
|
Which view should be used to modify a table?
a. | Datasheet view | c. | Layout view | b. | Design view | d. | Form view |
|
|
|
66.
|
Modifying the data in an existing record is called
a. | adding. | c. | deleting. | b. | updating. | d. | renaming. |
|
|
|
67.
|
Which is not a way to populate a database?
a. | typing entries | b. | using copy and paste | c. | importing data from
an existing file | d. | exporting a file as an HTML document |
|
|
|
68.
|
Which of the following methods allows you to create a multiple primary
key?
a. | Using ALT + clicking the multiple fields & then choosing the Primary Key
tool. | c. | Using CTRL + clicking the multiple fields & then choosing the Primary Key
tool. | b. | Double-clicking two field selectors (at the top of the columns) in datasheet
view. | d. | It is not possible to
create a multiple primary key. |
|
|
|
69.
|
Which field type would you use for a field that stores the G.P.A. for students
at your school?
a. | Text | c. | Memo | b. | Currency | d. | Numeric |
|
|
|
70.
|
Which field type would you use for a field that stores the phone numbers of
students at your school?
a. | Text | c. | Memo | b. | Currency | d. | Number |
|
|
|
71.
|
Adding records to a database is called _____ the database.
a. | Scheming | c. | Initializing | b. | Populating | d. | Designing |
|
|
|
72.
|
Which of the following is the correct definition of a database?
a. | A field type that stores dollar amounts. | c. | An organized collection of related
data. | b. | A set of data for the fields in a table. | d. | A database object used for entering records
into a table and for viewing existing records. |
|
|
|
73.
|
Which of the following is the correct file extension for databases created in
Microsoft Access?
|
|
|
74.
|
Which of the following is most likely to be stored in a RDBMS (relational
database management system)?
a. | A letter to your grandmother. | c. | Calculating and keeping track of
finances in your checking and savings accounts. | b. | The names and addresses of customers for a
business. | d. | Family photos as
a slide show. |
|
|
|
75.
|
The best way to move from field to field within a form AND from the end of one
record to a new blank record within a form is:
a. | The Esc Key | c. | The Enter Key | b. | The Tab Key | d. | Either b or c |
|