MICROSOFT ACCESS MULTIPLE CHOICE:

1.) Which of the following fields is least likely to be set to required?

- A social security number in a taxpayer database.

- The name of an emergency contact for a patient in a doctor's database.

- A license plate number in a motor vehicles office database.

2.) When would you use the date function?

- To display the current date.

- To convert a value from a number into a date.

- When doing math involving two date fields.

3.) Which of the following is not a valid condition for an IIf function?

- Between 10 and 22

- State IN ("CA","WA","OR")

- Credits >=60

4.) Which statement is true about update queries?

- Update queries should be executed with caution because you cannot undo their changes.

- Only database administrators can run update queries.

- You can run an update query one time only.

5.) Why would you use an append query?

- To determine which records may need to be deleted from the database.

- To summarize the data in a firm's database to help managers evaluate their financial position.

- To copy records from one table to another based on criteria that you specify.