Microsoft Access quiz

What is a database?

• A collection of books

• A collection of information stored electronically.

• A purse with a base

• All of the above

How do you define a field in a database?

• A omplete set of fields

• A collection of records

• Single piece of information

• A firstname

These are examples of field names:

• First Name, Surname, Address, Position

• Malcom, Sandra, Position, Zipcode

• State, moon, wave, potatoes, sick

How do we define a record in database?

• A complete set of fields

• A collection of information

• All the peoples names

• I dont know

What is the purpose of a primary key?

• To uniquely identify the record

• To take telephone numbers and lock then

• It will ensure that values are entered twice

What is the purpose of a primary key?

• To uniquely identify the record

• To take telephone numbers and lock then

• It will ensure that values are entered twice

How would you define a Query?

• Created to see tables better

• Allow you to retrieve data from tables

• The wizard allows you to go step by step

Why are reports created in access databases?

• They are produced to analyse and print queries or tables for presenting

• Just to print

• To collect more information

Relationships are created in Ms. Access to:

• Connect tables to create combined reports queries or forms

• To show relation

• To join tables together for printing

Why do you save a database in Ms. Access before creating objects?

• You must save first

• Because there are tasks which save automatically

• Access database will be lost