Microsoft Access

What is a database?

• A structured collection of records or data

• A data structure that improves search operations in a table.

• A program for creating online forms.

• A set of instructions used when retrieving data from a table.

What is the difference between data and information?

• Data is always numerical while information is always text.

• Data is raw facts while information is data processed in some way

• Data is generated by an application while information is generated manually.

• Data is presented as formatted text while information is presented as plain text.

How is a database organised?

• A database contains reports and fields stored in tables.

• A database contains forms and reports stored in tables.

• A database contains fields and records stored in tables.

• A database contains indexes and critera stored in tables.

Which of the following is a common use of large-scale databases?

• Storing and accessing bank account records.

• Storing and accessing videos on a hard drive.

• Storing and accessing contacts in a mobile phone.

• Storing and accessing bookmarks in a Web browser.

What is important when designing a database?

• A query should only fetch data from a single table.

• A table should contain data related to a single subject type.

• A report should contain records based on a single data type.

• A form should enter data into multiple tables.

Which of the following is important when creating fields in a database?

• Each field in a table should contain only one type of data.

• Each field in a table should use the same data type

• Each field in a table should use the same field size.

• Each field in a table should contain a primary key.

Which of the following is an appropriate data type for a field containing decimal values?

• Autonumber

• Number

• Text

• Memo

What property is used to automatically enter a specific field value for new records?

• Field Size

• Format

• Caption

• Default Value

What is used when there is a need to uniquely identify each record in a table?

• Default Value

• Primary Key

• Validation Rule

• Filter

What could be used to find and sort records faster?

• Index

• Primary Key

• Form

• Validation Rule