Cco.docx

CCO115 Finals - Quiz 1 Total points29/35

Email address * [email protected]

The characteristics and behavior of a field, such as the number of characters allowed in the field. * 1/1

fields properties design properties datasheet properties

The objects are organized into categories on the Navigation Pane, which can be collapsed to allow more space for the selected object. * 1/1

True False

Access data can be exported to many other data formats for use in other applications. * 1/1

True False

Text size is up to _____ characters. * 1/1

254 255

256

Access is the Microsoft Office database application * 1/1

True False

At most one table must be created before any additional objects can be created. * 0/1

True False Correct answer

False

When you create a new database, the first step is to use a template. * 1/1

True False

The view that displays data from a table, form, query, view, or stored procedure in a row-and-column format * 1/1

Datasheet Design Table wizard

A relational database management system. * 2/2

access

Display characters that help to guide data entry. * 1/1

Field size Format Input mask

Use this data type if you need more than 255 characters * 1/1

Int Memo Text

The default data type for a field is Long Text. * 0/1

True False Correct answer

False

A collection of related information. * 2/2

database

In Access you can import or link data from other Access databases, Excel, Outlook, and many other data sources. * 1/1

True False

Like Word and Excel, Access has a standard document view. * 0/1

True False Correct answer

False

Once you have deleted a record, you cannot use the Undo command to restore it. * 0/1

True False Correct answer

True

A unique numeric value that Access automatically inserts when a record is added. * 1/1

AutoNumber Number Primary Key

You can adjust the column widths in a database table just as you adjust the column widths in an Excel spreadsheet. * 1/1

True False

In a relational database, information is organized into separate subject-based tables, and the ________of the data in one or more tables is used to bring the data together. * 2/2

relationship

Deleting records is similar to deleting rows in an Excel spreadsheet. * 1/1

True False

When you edit an existing record in Form view, you need to update the records in the table. * 1/1

True False

This stores data in columns and rows * 2/2

table

The Access document window changes based on the object with which you are working. * 0/1

True False Correct answer

True

Below are the different views in MS Access in creating table, except for_________ * 0/1

Datasheet Design PivotTable TableWizard Correct answer

TableWizard

Text field size is up to 255 characters. * 1/1

True False

The default data type for a field is Memo. * 1/1

True False

You can add fields only in Datasheet view. * 1/1

True False

You can create a new database file using a blank database template, or by using templates that are predefined with objects already created. * 1/1

True False

Set the maximum size for data stored as a Text, Number, or AutoNumber data type * 1/1

Field size Format Input Mask

This finds and shows data that meet a specified criteria * 2/2

query This form was created inside of University of the East. - Terms of Service - Additional Terms

Forms