WorksheetsDatabase Fundamentals
Total questions: 20
Worksheet time: 10mins
Why does data inside a database need to be organized?
“So the data can be found when needed”
“So the data can be searched from the Internet”
"So the data is neat and tidy”
“So data integrity can be maintained”
Which of the following is an easy way to enter and browse data in a large database?
“Records”
“Spreadsheets”
“Forms”
“Tables”
A store tracks customers and their orders in a database. Which table would NOT be part of this database?
“Reviews table”
“Inventory table”
“Orders table”
“Customers table”
A database contains a Customer table. What would be stored in a record of the Customer table?
“Information about all the customers”
“Information about one order”
“Information about every order”
“Information about one customer”
A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records?
“Forms”
Database”
“Database Management Software”
“Data Integrity”
The image represents a database. What does Item A indicate in the database?
“A record”
“A database”
“A field”
“A table”
You discover many errors in a database table. What has been lost?
“Database Management System”
“Fields and Records”
“Primary Key”
“Data Integrity”
Forms can be used to browse data, but they cannot be used to add, update or delete records.
“True”
“False”
You specify data types when adding ______.
“Data to a database”
“Data Integrity to a database”
“Records to a table”
“Fields to a table”
Data can be entered into the Datasheet view, but it can be easier to use a ______ instead.
“Form”
“Record”
“Primary Key”
“Field”
Which database view can be used to enter data?
“Table Design View”
“Datasheet View”
In the image, what is the highlighted area of the screen called?
“Navigation Pane”
“Database Form”
“Ribbon”
“Database Table”
Given these two views of the same database table, which field in the Datasheet View will cause a data integrity problem? Hint: Look at the Data Types in the Table View.
“Product ID”
“Cost”
“Product Name”
“Supplier ID”
Look at the information in the database table. What field is being used to SORT the table?
“Name”
“Phone”
“City”
“State”
Sorting from A-Z is also called a descending sort.
“True”
“False”
A query for a report can come from multiple tables.
“True”
“False”
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.”
What is it called when you want to see database records in a certain order?
“Filter”
“Search”
“Sort”
“Report”
Descending means sorting from:
“Smallest to largest”
“Largest to smallest”
In the table which customer does not have a Company associated with their information?
“Susan Lindross”
“Nancy Marshall”
“Carl Wilcox”
“Sheila Hagar”
