A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records?
A database contains a Customer table. What would be stored in a record of the Customer table?
Is it OK to have a database of unrelated data?
Why does data inside a database need to be organized?
A store tracks customers and their orders in a database. Which table would NOT be part of this database?
A store tracks customers and their orders in a database. What can be created to store this collection of related data?
You discover many errors in a database table. What has been lost?
Which of the following is an easy way to enter and browse data in a large database?
What is a database?
What is a database table?
What is a database record?
4. What is a database field?
What is a database form?
What is data integrity?
What tools does Access have to help manage large amounts of data?
What is ascending order?
What is descending order?
What is filtering?
What view should you use to adjust and format a report?
A primary key field from one table appears in a second table. What is the field in the second table called?
Does Microsoft Access need to be told about relationships between tables?
You cannot change the order of fields on a report.
A query for a report can come from multiple tables.
Filters can be used on query results.
Queries can only use data from one table at a time.