Have an account?
Skip to Content
Build your own quiz
Suggestions for you
25 questions
Show Answers
See Preview
- 1. Multiple Choice
Data that is organized in a useful manner is:
normalized data
information
facts.
a query
- 2. Multiple Choice
Which of the following is NOT a benefit of avoiding redundancy in a database?
Conserves space
Prevents unauthorized manipulation of data
Reduces errors when recording new data
User doesn't have to remember where data is stored
- 3. Multiple Choice
Each table row contains all categories of data pertaining to one entity and is called a:
field.
database.
record.
query
- 4. Multiple Choice
In Microsoft Access, all data is stored in one or more
macros
forms
tables
queries
- 5. Multiple Choice
An Access record is saved when you
save the table in which it was created
press Save on the File tab on the Ribbon
close the database
move to the next record
- 6. Multiple Choice
To rename a table, you can:
click the Database Tools tab on the Ribbon
right-click the table name in the Navigation Pane
click Save As from the File menu
open Windows Explorer
- 7. Multiple Choice
Before populating a table, which is the correct sequence of steps?
Create and name the database; save the database; design, create and name the table
Design the table, name the table, save the database
Create the table, design the table, name the table, save and name the database
Create the database, create the table, design the table, save and name the database.
- 8. Multiple Choice
While in Datasheet view, to display a table in Design View
in the Preview group, click the View button arrow and click Design View
on the Quick Access Toolbar, click Design View
in the Views group, click the View button and click Design View
in the Navigation Pane, click Design View
- 9. Multiple Choice
When creating a new table, Access does NOT:
prevent the user from modifying the ID field
format the first field as Autonumber
assign the ID field as the primary key
create a first field called ID
- 10. Multiple Choice
The most common database objects are:
tables, panes, and property sheets
tables, queries, forms, and reports
) tables, relationships, and panes
tables, queries, and relationships
- 11. Multiple Choice
The Access view that displays the table data in columns and rows is called
Datasheet view
Form view
Design view
Print Preview view
- 12. Multiple Choice
The table Design view shows
the number of records in the table
the relationships established for the table
the structure of the table
the queries result from a table
- 13. Multiple Choice
Which of the following is a good candidate for a primary key?
A postal code in an address database
A street name in an address database
A student ID in a college registration database
A Student name in a college database
- 14. Multiple Choice
The process of creating a query involves selecting the:
report(s) and selecting the fields you want to include in the query result.
form(s) and selecting the fields you want to include in the query result.
table(s) and selecting the fields you want to include in the query result.
record(s) and selecting the fields you want to include in the query result.
- 15. Multiple Choice
One purpose of a form is to:
simplify data entry in the database
retrieve specific data from one or more tables.
organize your database objects
simultaneously display the fields and records from a table in an easy-to-read format.
- 16. Multiple Choice
One purpose of a report is to:
retrieve specific data from one or more tables or queries
display the fields and records from a table or query in an easy-to-read format
simplify data entry in a table
organize your database objects
- 17. Multiple Choice
A query is a database object that:
summarizes data in a professional-looking manner
retrieves specific data from one or more database tables or queries
edits data
can select its data from tables, other queries, or reports
- 18. Multiple Choice
The Primary Key icon contains a picture of a Key
TRUE
Sometimes
False
- 19. Multiple Choice
When establishing a relationship, common fields do NOT necessarily need to have:
common data
the same data type
the same field size
the same field name
- 20. Multiple Choice
To find a contribution amount of $300 or greater, the entry in the Amount field's criteria should be:
>=$300
>300
300
>=300
- 21. Multiple Choice
When searching for "Red" or "Rad" or "Rid" or "Rod", but NOT "Rodney" or "Reed" or "Ron', which of the following criteria should be used?
R*d
R?d
R??
R*
- 22. Multiple Choice
Which of the following expressions would correctly add a calculated field named Discount that is 20 percent of the Price field?
Discount:[Price]*0.20
Discount=Price*20%
Let Discount=[Price]*0.20
[Discount]:[Price *20%]
- 23. Multiple Choice
Which of the following is NOT a function that can be used with the Totals button?
SUM
LOWEST
AVG
MAX
- 24. Multiple Choice
Sorting a table in Ascending order on the State field would result in Alaska displaying before California
TRUE
FALSE
- 25. Multiple Choice
Resizing sections in a form must be done in
Form view
Design view
Layout view
Datasheet view
- Answer choicesTagsAnswer choicesTags