ICT Microsoft Access Test UPDATED ACTUAL Exam Questions and CORRECT Answers

ICT Microsoft Access Test UPDATED
ACTUAL Exam Questions and CORRECT
Answers
A store tracks customers and their orders in a database. What can be created to store this
collection of related data? - CORRECT ANSWER - database


A store tracks customers and their orders in a database. Which table would NOT be part of this
database? - CORRECT ANSWER - Inventory table


A database contains a Customer table. What would be stored in a record of the Customer table? -
CORRECT ANSWER - information about one customer



Is it OK to have a database of unrelated data? - CORRECT ANSWER - no


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



Why does data inside a database need to be organized? - CORRECT ANSWER - so the
data can be found when needed


You discover many errors in a database table. What has been lost? - CORRECT
ANSWER - data integrity


A store needs to keep track of suppliers and inventory. What software can be used to create the
database, tables, fields and records? - CORRECT ANSWER - database management
system


You specify data types when adding ______. - CORRECT ANSWER - Fields to a table