Access

A score tracks supplier and inventory in a database. which of the following would be a field in the table

• inventory cost
• phone number

you discover many errors in a database table. what has been lost?

• data integrity
• fields and records

you have a table that hold names and phone numbers for 1000 people. how many records are there?

• 1000
• two

why does a database inside a database need to be organized?

• so the data is neat and tidy
• so the data can be found when needed

sorting from Z-A is also called a descending sort

• true
• false

what is it called when "ask the database a question"?

• Query
• report

ascending means sorting from:

• largest to smallest
• smallest to largest

a primary key field from one table appears in a second table. what is the field in the second table called?

• a foreign key
• a linked key

you specify data types when adding ______

• fields to a table
• records to a table

every record must have a different _____ value in a table.

• primary key
• data integrity