Intro to Microsoft Access

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

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

Is it OK to have a database of unrelated data?

• Yes

• No

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

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

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

You discover many errors in a database table. What has been lost?

• Data Integrity

• Database Management System

• Fields and Records

• Primary Key

Which of the following is an easy way to enter and browse data in a large database?

• Forms

• Tables

• Spreadsheets

• Records

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.

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.