Access quiz by Simar Brahma :D

What is Primary Key?

• It is one (or more) column(s) whose value uniquely identify every row in a table.

• It is one method that helps you find information quickly and easily in a database.

• They are requests for information. They can sort, calculate, filter, update data and more based on the results you are looking for.

• It is a database object that can be used to create a user interface for a database application.

What is design view?

• The function we use to set up a table in a database.
• The place where we type in all the information.

A query is a cell in the database.

• True
• False

A specific piece of information within a record, also called column, is a ___________.

• Row
• Field
• Cell

A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.

• Query
• Report
• Database 
• Spreadsheet

Which data type would be most suitable for the 'Age' field?

• Currency

• Date & Time

• Number

• Yes/No

• Memo

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

The best data type to choose for date of birth would be

• Number

• Text

• Date/Time

• Currency

A ‘required field’ is a form of

• Validation

• Verification

• Data Entry

• Data Output