Exam 16: Access: Presentation Development

An unchanging value is called a(n) ________.

The ________ property can be applied to change the way a field is displayed or printed.

Access can import data from different a database or Excel spreadsheet.

All Excel spreadsheets are ready to import into an Access database.

Using a field that contains a birth year and a field that contains the current year to determine the age of a person listed in a database is called ________.

In field names, object names, and filenames, uppercase letters are used to distinguish the first letter of a new word in ________ notation.

The maximum size of the Text data type is ________ characters.

Which field property type should be applied to fields that should not remain empty?

A(n) ________ is a dynamic subset of a table that selects, sorts, and calculates records as specified in a query.

Jose is working on a database that stores stock information. He needs to design a field that will allow a user to connect to a graph created in Excel. The data type he should apply to this field is:

Multi-table queries take advantage of table relationships in a database.

The ________ data type is used to hold sentences or paragraphs of descriptive data.

Good database design begins with designing forms.

Ryan needs to organize the data in a table so that it displays in a summarized format. He should use the ________ view for this purpose.

Sarah is working in a database that stores resort vacation information. She needs to design a field that will allow a user to link to an external website. The data type she should apply to this field is:

A(n) ________ field is used to produce a value from an expression or function.

Which of the following query criteria would be used to produce results for Date / Time fields containing a date of December 12th, 2010?

A field name can begin with a(n) ________.

By establishing a relationship, you can efficiently combine data from related tables.

Ben is working in a database that stores student information. He wants to determine each student's age based on the student's birthday. Which of the following statements accurately describe how the fields should be designed?