Access

What is a Database?

A database stores data and can be used to manage that data.

Which statements best describes a situation in which you should use MS Excel instead of MS Access application?

The file contains a financial table that requires tracking numeric values and performing calculations.

A 'Design View' in Access database can be used to add fields or modify the field properties.

True

A Form is an Access database object for collecting data.

True

A Query is an object in Access database.

True

A Report is an object in Access database.

True

A Table is not and object in Access database.

True

A cross-reference from one table (e.g. Students table) to another (e.g. Guardian table) refers to a relationship or link.

True

Users can import Excel files into Access database using the "External Data" tab.

True

In MS Access a row with a customer name, address, city, state, and zip code make up a set of data called a (an):

record

A Form is not an object in Access database.

False

Since backing up a file is so critical, Access will automatically back up the database when closing a file.

False

The function of a query object in Access database is to store data.

False

Usually, MS Access database permanently stores data in your computer Random Access Memory (RAM).

False

Creating a copy of a database in case the file becomes damaged or data is accidentally deleted can be accomplished by:

backing up

An Access file that could contain customer mailing addresses, phone numbers, as well as customer purchases and details of the purchase, is also known as a (an):

database

An Access database view used to display data in Fields and Records is known as a __________ view.

datasheet

A one - many relationship refers to a field that is unique in one table, and_________

has many matching records in the other table

A field that requires unique data for identifying records is called a (an)_____________

primary key

A relationship in MS database is formed by creating a link on _______________________.

two similar field types from two different tables or queries

When the following message appears: "Security Alert: Due to your security settings, certain content in the database has been disabled..... " it indicates that:

you should click Enable Content, if you trust that the file does not contain a virus.