Have an account?
Skip to Content
Build your own quiz
25 questions
Show Answers
See Preview
- 1. Multiple Choice
A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records?
Database
Database Management Software
Data Integrity
Forms
- 2. Multiple Choice
A database contains a Customer table. What would be stored in a record of the Customer table?
Information about one customer
Information about all the customers
Information about one order
Information about every order
- 3. Multiple Choice
Is it OK to have a database of unrelated data?
Yes
No
- 4. Multiple Choice
Why does data inside a database need to be organized?
So the data is neat and tidy
So data integrity can be maintained
So the data can be searched from the Internet
So the data can be found when needed
- 5. Multiple Choice
A store tracks customers and their orders in a database. Which table would NOT be part of this database?
Customers table
Orders table
Reviews table
Inventory table
- 6. Multiple Choice
A store tracks customers and their orders in a database. What can be created to store this collection of related data?
Database Management System
Database
Table
Record
- 7. Multiple Choice
You discover many errors in a database table. What has been lost?
Data Integrity
Database Management System
Fields and Records
Primary Key
- 8. Multiple Choice
Which of the following is an easy way to enter and browse data in a large database?
Forms
Tables
Spreadsheets
Records
- 9. Multiple Choice
What is a database?
An organized collection of related data.
A record that stores all the information for one item in a table.
A table that stores information about one specific kind of item in a database.
A column in a table that stores a piece of data for a record.
- 10. Multiple Choice
What is a database table?
An organized collection of related data.
A column in a table that stores a piece of data for a record.
Stores all the information for one item in a table.
Stores information about one specific kind of item in a database.
- 11. Multiple Choice
What is a database record?
Stores information about one specific kind of item in a database.
Stores all the information for one item in a table.
An organized collection of related data.
A column in a table that stores a piece of data for a record.
- 12. Multiple Choice
4. What is a database field?
Stores all the information for one item in a table.
Stores information about one specific kind of item in a database.
An organized collection of related data.
A column in a table that stores a piece of data for a record.
- 13. Multiple Choice
What is a database form?
A column in a table that stores a piece of data for a record.
Stores information about one specific kind of item in a database.
Forms are a way to view and browse information in a database.
An organized collection of related data.
- 14. Multiple Choice
What is data integrity?
Maintaining and assuring accuracy and consistency of data in a database.
Stores all the information for one item in a table.
Stores information about one specific kind of item in a database.
Forms are a way to view and browse information in a database.
- 15. Multiple Choice
What tools does Access have to help manage large amounts of data?
Foreign key
Sorting and filtering
A relationship
Report Design View
- 16. Multiple Choice
What is ascending order?
Moving down the alphabet from Z to A.
To find a specific item in the table.
Moving up the alphabet from A to Z
sorting
- 17. Multiple Choice
What is descending order?
Moving up the alphabet from A to Z.
Sorting
To find a specific item in the table.
Moving down the alphabet from Z to A.
- 18. Multiple Choice
What is filtering?
To find a specific item in the table.
A relationship
Changing which records are displayed on the screen.
Sorting
- 19. Multiple Choice
What view should you use to adjust and format a report?
Print Preview
Report Design View
- 20. Multiple Choice
A primary key field from one table appears in a second table. What is the field in the second table called?
A primary key
A foreign key
A relationship key
A linked key
- 21. Multiple Choice
Does Microsoft Access need to be told about relationships between tables?
No, relationships are automatically detected
No, relationships are not supported
Yes, relationships need to be defined.
Yes, only when the fields have different names.
- 22. Multiple Choice
You cannot change the order of fields on a report.
True
False
- 23. Multiple Choice
A query for a report can come from multiple tables.
True
False
- 24. Multiple Choice
Filters can be used on query results.
True
False
- 25. Multiple Choice
Queries can only use data from one table at a time.
True
False
- Answer choicesTagsAnswer choicesTags