Access Module 1

In Access, the columns in a table are called records

False

A unique identifier is also called a primary key

True

In Access, field names cannot contain digits

False

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

True

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

False

The maximum number of characters allowed in a field whose data type is Short Text is 225 characters

True

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of memo

False

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

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 225

False

When Access first creates a database, it automatically creates a table

True

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

False

Changing the column width in a datasheet changes the structure of a table

False

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

True

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

False

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

False

Form view displays a single record at a time

True

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

True

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

True

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

True

Redundancy means storing the same fact in more than one place

True

Access is a

Database management system

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

Relational

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

Record

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

Reserved

In Access, table and field names can be up to __________ characters in lenght

128

A field whose data type is ________ can contain any characters

Short text

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

Long text

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

AutoNumber

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

Attachment

A field whose date type is _______ can store an OLE object, which is an object linked to or embedded in the table

OLE object

A field whose date type is _______can store text thAt can be used as a hyperlink address

Hyperlink

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

Caption

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

Click to Add

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

Undo

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

Delete Field

To change the name of afield, 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

Rename field

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

Format

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 the tap or click ______ on the shortcut menu

Insert field

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

New (blank)

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

F2

To delete a record, tap or click the record sector for the record, and then press the ______ key

Delete

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

Options

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

Quick Access Toolbar

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

EXTERNAL DATA

To open the Navigation Pane, tap or click the ______ Button

Shutter Bar Open/Close

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

Open

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

Design View

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

Back Up Databsw

To compact and repair a databse, tap or click the ________ button in the Info gallery in the Backstage view

Compact and Repair

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

Delete

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

Rename

A(n) _______ is software that can be used to create a database; add, change, and delete data in the database; task and answer questions concerning the data in the database; and create forms and reports using the data

Database management system

The rows in the tables are called

Records

Contains a specific piece of information switching a record

Field

Data type in Access is referred to as Money in SQL Server

Currency

View has more functionality for creating a table than Datasheet view

Design

To define an additional field in Datasheet view, tap or click the _______ column heading, select the data type, and then type the field name

Click to add

To insert a field between existing fields, press and he or she the column heading for the field that will follow the new did, and then tap or click ______ on the shortcut menu

Insert field

Society encourage users to contribute to ____ computing, which involves reducing the electricity consumed and environmental waste generate when using computers, mobile devices, and related technologies

Green

A hard copy or __________ is information that exists on a physical medium such as paper

Printout

Refers to the process of determining the tables and fields that make up the database

Database design

The determination of database requirements is part of a process is known as

Systems analysis

Designing to omit _______ will help to produce good and valid databse designs

Rebundancy

Access Module 1 - Subjecto.com

Access Module 1

Your page rank:

Total word count: 1242
Pages: 5

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

In Access, the columns in a table are called records

False

A unique identifier is also called a primary key

True

In Access, field names cannot contain digits

False

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

True

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

False

The maximum number of characters allowed in a field whose data type is Short Text is 225 characters

True

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of memo

False

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

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 225

False

When Access first creates a database, it automatically creates a table

True

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

False

Changing the column width in a datasheet changes the structure of a table

False

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

True

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

False

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

False

Form view displays a single record at a time

True

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

True

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

True

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

True

Redundancy means storing the same fact in more than one place

True

Access is a

Database management system

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

Relational

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

Record

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

Reserved

In Access, table and field names can be up to __________ characters in lenght

128

A field whose data type is ________ can contain any characters

Short text

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

Long text

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

AutoNumber

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

Attachment

A field whose date type is _______ can store an OLE object, which is an object linked to or embedded in the table

OLE object

A field whose date type is _______can store text thAt can be used as a hyperlink address

Hyperlink

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

Caption

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

Click to Add

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

Undo

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

Delete Field

To change the name of afield, 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

Rename field

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

Format

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 the tap or click ______ on the shortcut menu

Insert field

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

New (blank)

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

F2

To delete a record, tap or click the record sector for the record, and then press the ______ key

Delete

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

Options

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

Quick Access Toolbar

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

EXTERNAL DATA

To open the Navigation Pane, tap or click the ______ Button

Shutter Bar Open/Close

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

Open

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

Design View

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

Back Up Databsw

To compact and repair a databse, tap or click the ________ button in the Info gallery in the Backstage view

Compact and Repair

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

Delete

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

Rename

A(n) _______ is software that can be used to create a database; add, change, and delete data in the database; task and answer questions concerning the data in the database; and create forms and reports using the data

Database management system

The rows in the tables are called

Records

Contains a specific piece of information switching a record

Field

Data type in Access is referred to as Money in SQL Server

Currency

View has more functionality for creating a table than Datasheet view

Design

To define an additional field in Datasheet view, tap or click the _______ column heading, select the data type, and then type the field name

Click to add

To insert a field between existing fields, press and he or she the column heading for the field that will follow the new did, and then tap or click ______ on the shortcut menu

Insert field

Society encourage users to contribute to ____ computing, which involves reducing the electricity consumed and environmental waste generate when using computers, mobile devices, and related technologies

Green

A hard copy or __________ is information that exists on a physical medium such as paper

Printout

Refers to the process of determining the tables and fields that make up the database

Database design

The determination of database requirements is part of a process is known as

Systems analysis

Designing to omit _______ will help to produce good and valid databse designs

Rebundancy

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