Access 1

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

a.
abbreviation

b.tag

c.caption

d.alternate

c.caption

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.
True
False

False

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

a.Insert Column

b.Add Field

c.Add Column

d.Insert Field

d.Insert Field

Layout view shows a report on the screen and allows the user to make changes to the report.
True
False

True

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

a.
Remove

b.Delete

c.Trash

d.Erase

b.Delete

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

a.Open

b.Design View

c.Query Window

d.SQL

b.Design View

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.

a.Delete Column

b.Delete Field

c.Remove Column

d.Remove Field

b.Delete Field

The Currency data type is used for fields that contain only monetary data.
True
False

True

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.
True
False

True

A unique identifier is also called a primary key.
True
False

True

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.
True
False

True

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

a.Sequential

b.AutoNumber

c.Incremental

d.ValueIncrement

b.AutoNumber

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

a.Variable

b.Memo

c.Character

d.Long Text

d.Long Text

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. ____________________
True
False

True

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu. ____________________
True
False

False

A field whose data type is ____ can store text that can be used as a hyperlink address.

a.URL

b.Hyperlink

c.Web

d.Placeholder

b.Hyperlink

To preview and then print the contents of a table, use Table Preview.
True
False

False

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

a.Bitmap

b.OLE object

c.Image

d.Illustration

b.OLE object

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.
True
False

False

A field whose data type is ____ can contain any characters.

a.Short Text

b.Character

c.Alpha

d.Normal

a.Short Text

In Access, table and field names can be up to ____ characters in length.

a.256

b.128

c.64

d.32

c.64

___ words are words that have a special meaning to Access and cannot be used for the names of fields.

a.Significant

b.Tagged

c.Restricted

d.Reserved

d.Reserved

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

a.Restore

b.Fix

c.Compact & Repair

d.Compaction

c.Compact & Repair

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu. ____________________
True
False

False

To open the Navigation Pane, tap or click the ____ Button.

a.Open Pane

b.Shutter Bar Open/Close

c.Open Navigation Pane

d.Navigation Bar Show/Hide

b.Shutter Bar Open/Close

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

a.relational

b.tabular

c.record

d.attribute

a.relational

In Access, the columns in a table are called records.
True
False

False

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________
True
False

False

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.
True
False

True

Redundancy means storing the same fact in more than one place.
True
False

True

A(n) ____ contains information about a given person, product, or event.

a.record

b.attribute

c.field

d.column

a.record

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

a.Reverse

b.Back

c.Undo

d.Cancel

c.Undo

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

a.New Name

b.Redefine

c.Save Name

d.Rename

d.Rename

In Access, field names cannot contain digits.
True
False

False

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

a.Rename Column

b.Change Column

c.Rename Field

d.Change Field

c.Rename Field

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

a.Grammar

b.Customize

c.Options

d.Manage

c.Options

In Datasheet view, a table is represented as a collection of rows and columns called a list.
True
False

False

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

a.CTRL+DELETE

b.DELETE

c.CTRL+Y

d.CTRL+K

b.DELETE

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

a.Format

b.Description

c.Field Size

d.Caption

a.Format

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

a.Back Up Current

b.Save As Back Up

c.Close and Back Up

d.Back Up Database

d.Back Up Database

Changing the column width in a datasheet changes the structure of a table.
True
False

False

You can place an insertion point by tapping or clicking in the field or by pressing ____.

a.F2

b.F3

c.F4

d.F5

a.F2

To add a record to a table, tap or click the ____ record button.

a.Add New

b.Last

c.New (blank)

d.Insert (New)

c.New (blank)

One way to undo changes to a field is to click the Undo button on the status bar.
True
False

False

To import data to a table, tap or click the ____ tab on the ribbon.

a.FILE

b.IMPORT

c.DATABASE TOOLS

d.EXTERNAL DATA

d.EXTERNAL DATA

The Navigation Pane contains a list of all the objects in the database.
True
False

True

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.
True
False

True

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record. ____________________
True
False

False

Landscape orientation means the printout is across the length (height) of the page.
True
False

True

Access is a ____.

a.database management system

b.file management system

c.workbook management system

d.word processing software tool

a.database management system

To save the changes to the layout of a table, tap or click the Save button on the ____.

a.
Quick Access Toolbar

b.status bar

c.TABLE TOOLS tab

d.Navigation Pane

a.Quick Access Toolbar

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

a.Datasheet View

b.Open

c.Run

d.Results View

b.Open

A(n) ____ contains information about a given person, product, or event.

a.field

b.record

c.column

d.attribute

b.record

When Access first creates a database, it automatically creates a table.
True
False

True

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

a.Attachment

b.Extend

c.Document

d.File

a.Attachment

Redundancy means storing the same fact in more than one place.
True
False

True

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________
True
False

False

To define an additional field in Datasheet view, tap or click the ____ column heading.

a.Add Field

b.Insert Field

c.New Field

d.Click to Add

d.Click to Add

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.
True
False

False

Form view displays a single record at a time.
True
False

True

Access 1 - Subjecto.com

Access 1

Your page rank:

Total word count: 1629
Pages: 6

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

a.
abbreviation

b.tag

c.caption

d.alternate

c.caption

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.
True
False

False

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

a.Insert Column

b.Add Field

c.Add Column

d.Insert Field

d.Insert Field

Layout view shows a report on the screen and allows the user to make changes to the report.
True
False

True

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

a.
Remove

b.Delete

c.Trash

d.Erase

b.Delete

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

a.Open

b.Design View

c.Query Window

d.SQL

b.Design View

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.

a.Delete Column

b.Delete Field

c.Remove Column

d.Remove Field

b.Delete Field

The Currency data type is used for fields that contain only monetary data.
True
False

True

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.
True
False

True

A unique identifier is also called a primary key.
True
False

True

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.
True
False

True

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

a.Sequential

b.AutoNumber

c.Incremental

d.ValueIncrement

b.AutoNumber

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

a.Variable

b.Memo

c.Character

d.Long Text

d.Long Text

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. ____________________
True
False

True

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu. ____________________
True
False

False

A field whose data type is ____ can store text that can be used as a hyperlink address.

a.URL

b.Hyperlink

c.Web

d.Placeholder

b.Hyperlink

To preview and then print the contents of a table, use Table Preview.
True
False

False

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

a.Bitmap

b.OLE object

c.Image

d.Illustration

b.OLE object

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.
True
False

False

A field whose data type is ____ can contain any characters.

a.Short Text

b.Character

c.Alpha

d.Normal

a.Short Text

In Access, table and field names can be up to ____ characters in length.

a.256

b.128

c.64

d.32

c.64

___ words are words that have a special meaning to Access and cannot be used for the names of fields.

a.Significant

b.Tagged

c.Restricted

d.Reserved

d.Reserved

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

a.Restore

b.Fix

c.Compact & Repair

d.Compaction

c.Compact & Repair

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu. ____________________
True
False

False

To open the Navigation Pane, tap or click the ____ Button.

a.Open Pane

b.Shutter Bar Open/Close

c.Open Navigation Pane

d.Navigation Bar Show/Hide

b.Shutter Bar Open/Close

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

a.relational

b.tabular

c.record

d.attribute

a.relational

In Access, the columns in a table are called records.
True
False

False

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________
True
False

False

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.
True
False

True

Redundancy means storing the same fact in more than one place.
True
False

True

A(n) ____ contains information about a given person, product, or event.

a.record

b.attribute

c.field

d.column

a.record

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

a.Reverse

b.Back

c.Undo

d.Cancel

c.Undo

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

a.New Name

b.Redefine

c.Save Name

d.Rename

d.Rename

In Access, field names cannot contain digits.
True
False

False

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

a.Rename Column

b.Change Column

c.Rename Field

d.Change Field

c.Rename Field

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

a.Grammar

b.Customize

c.Options

d.Manage

c.Options

In Datasheet view, a table is represented as a collection of rows and columns called a list.
True
False

False

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

a.CTRL+DELETE

b.DELETE

c.CTRL+Y

d.CTRL+K

b.DELETE

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

a.Format

b.Description

c.Field Size

d.Caption

a.Format

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

a.Back Up Current

b.Save As Back Up

c.Close and Back Up

d.Back Up Database

d.Back Up Database

Changing the column width in a datasheet changes the structure of a table.
True
False

False

You can place an insertion point by tapping or clicking in the field or by pressing ____.

a.F2

b.F3

c.F4

d.F5

a.F2

To add a record to a table, tap or click the ____ record button.

a.Add New

b.Last

c.New (blank)

d.Insert (New)

c.New (blank)

One way to undo changes to a field is to click the Undo button on the status bar.
True
False

False

To import data to a table, tap or click the ____ tab on the ribbon.

a.FILE

b.IMPORT

c.DATABASE TOOLS

d.EXTERNAL DATA

d.EXTERNAL DATA

The Navigation Pane contains a list of all the objects in the database.
True
False

True

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.
True
False

True

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record. ____________________
True
False

False

Landscape orientation means the printout is across the length (height) of the page.
True
False

True

Access is a ____.

a.database management system

b.file management system

c.workbook management system

d.word processing software tool

a.database management system

To save the changes to the layout of a table, tap or click the Save button on the ____.

a.
Quick Access Toolbar

b.status bar

c.TABLE TOOLS tab

d.Navigation Pane

a.Quick Access Toolbar

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

a.Datasheet View

b.Open

c.Run

d.Results View

b.Open

A(n) ____ contains information about a given person, product, or event.

a.field

b.record

c.column

d.attribute

b.record

When Access first creates a database, it automatically creates a table.
True
False

True

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

a.Attachment

b.Extend

c.Document

d.File

a.Attachment

Redundancy means storing the same fact in more than one place.
True
False

True

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________
True
False

False

To define an additional field in Datasheet view, tap or click the ____ column heading.

a.Add Field

b.Insert Field

c.New Field

d.Click to Add

d.Click to Add

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.
True
False

False

Form view displays a single record at a time.
True
False

True

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending