Quiz 1: Access: Databases and Database Objects: an Introduction

Access is a ____. A)word processing software tool B)file management system C)workbook management system D)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. A)tabular B)record C)attribute D)relational

A(n)____ contains information about a given person,product,or event. A)attribute B)record C)field D)column

____ words are words that have a special meaning to Access and cannot be used for the names of fields. A)Reserved B)Restricted C)Significant D)Tagged

In Access,table and field names can be up to ____ characters in length. A)256 B)128 C)64 D)32

A field whose data type is ____ can contain any characters. A)Alpha B)Character C)Normal D)Short Text

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)Memo B)Long Text C)Variable D)Character

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)ValueIncrement C)Incremental D)AutoNumber

A field with the ____ data type can contain an attached file,such as an image,document,chart,or spreadsheet. A)Attachment B)File C)Document D)Extend

A field whose data type is ____ can store an OLE object,which is an object linked to or embedded in the table. A)Illustration B)Image C)Bitmap D)OLE object

A field whose data type is ____ can store text that can be used as a hyperlink address. A)URL B)Web C)Placeholder D)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. A)alternate B)caption C)abbreviation D)tag

When you create a table in Datasheet view,Access automatically adds a field called ____ as the first field in the table. A)AutoNumber B)AutoFill C)ID D)PrimaryID

To define an additional field in Datasheet view,tap or click the ____ column heading. A)New Field B)Add Field C)Click to Add D)Insert Field

To undo the most recent change to a table structure,tap or click the ____ button on the Quick Access Toolbar. A)Cancel B)Reverse C)Back D)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. A)Remove Field B)Delete Field C)Delete Column D)Remove Column

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)Change Column B)Rename Column C)Change Field D)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. A)Field Size B)Format C)Caption D)Description

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)Insert Field C)Add Column D)Add Field

To open a table in Design view,press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu A)Table Design B)Layout View C)Structure View D)Design View

-In the accompanying figure,the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table. A)principal key B)foreign key C)main key D)primary key

-In the accompanying figure,the Book Rep table displays in ____. A)Structure view B)Design view C)Layout view D)Table view

-In the accompanying figure,the small box or bar to the left of each field is called the ____. A)row selector B)field selector C)field bar D)current field bar

To add a record to a table,tap or click the ____ record button. A)Add New B)New (blank) C)Last D)Insert (New)

You can place an insertion point by tapping or clicking in the field or by pressing ____. A)F2 B)F3 C)F4 D)F5

To delete a record,tap or click the record selector for the record,and then press the ____ key(s). A)CTRL+DELETE B)CTRL+Y C)DELETE D)CTRL+K

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)Customize B)Manage C)Options D)Grammar

To save the changes to the layout of a table,tap or click the Save button on the ____. A)status bar B)TABLE TOOLS tab C)Navigation Pane D)Quick Access Toolbar

To change the print orientation from portrait to landscape,tap or click the ____ button on the PRINT PREVIEW tab. A)Portrait/Landscape B)Orientation C)Switch Orientation D)Landscape

To import data to a table,tap or click the ____ tab on the ribbon. A)DATABASE TOOLS B)FILE C)EXTERNAL DATA D)IMPORT

To open the Navigation Pane,tap or click the ____ Button. A)Open Navigation Pane B)Open Pane C)Shutter Bar Open/Close D)Navigation Bar Show/Hide

To create a query using the Query Wizard,tap or click ____ on the ribbon and then click the Query Wizard button. A)CREATE B)INSERT C)NEW OBJECT D)REPORT

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)Results View D)Run

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)SQL C)Query Window D)Design View

To create an initial report that can be modified in Layout view,tap or click ____ on the CREATE tab. A)Layout B)Report Layout C)Report D)Simple Report

To exit Access,tap or click the ____ button on the right side of the title bar. A)Quit B)Stop C)End D)Close

To back up the database that is currently open,use the ____ command on the Save As tab in the Backstage view. A)Close and Back Up B)Back Up Current C)Save As Back Up D)Back Up Database

To compact and repair a database,tap or click the ___ button in the Info gallery in the Backstage view. A)Restore B)Fix C)Compaction D)Compact & 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. A)Erase B)Trash C)Delete D)Remove

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)Rename D)Save Name

File names cannot contain a(n)____. A)question mark (?) B)colon (:) C)space D)underscore (_)

Field names cannot contain ____. A)square brackets ([ ]) B)periods (. ) C)hyphens (-) D)accent graves (')

The Access window consists of a variety of components.These include the ____. A)Navigation Pane B)Content pane C)Object tabs D)Quick Access Toolbar

A field with a Yes/No data type can store only one of two values.The choices are ____. A)True/False B)One/Zero C)Yes/No D)On/Off

You can create a table in ____. A)Design view B)Blank view C)Layout view D)Datasheet view

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

A unique identifier also is called a primary key.

In Access,field names cannot contain digits.

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

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

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

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

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

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.

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

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

The AutoError Correction feature of Access corrects common data entry errors.

-As shown in the accompanying figure,you can move to the end of a table to a position for entering a new record by clicking the Insert record Navigation button.

-As shown in the accompanying figure,you can use the Last record button to move to the last record in the table.

-As shown in the accompanying figure,you can move to the first record in a table by clicking the Start record Navigation button.

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

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

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

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

Form view displays a single record at a time.

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

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

The DATABASE TOOLS tab provides commands to save a database with another name.

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

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

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

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

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.____________________

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.____________________

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.____________________

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

The rows in the tables are called ____________________.

A(n)____________________ contains a specific piece of information within a record.

A unique identifier also is called a(n)____________________.

-In the accompanying figure,the ____________________ Pane contains a list of all the objects in the database.

-In the accompanying figure,the words Datasheet View at the lower left of the screen appear on the ____________________.

-In the accompanying figure,the entire area that displays on the screen is called the ____________________ work area.

-In the accompanying figure,____________________ for the open objects appear at the top of the work area.

-In the accompanying figure,the database name,Bavant Publishing appears on the ____________________.

-In the accompanying figure,the buttons at the bottom-right edge of the screen are ____________________ buttons,which you use to change the view that is currently displayed.

The ____________________ data type in Access is referred to as Money in SQL Server.

The Short Text data type replaces the ____________________ data type in previous editions of Access.

____________________ view has more functionality for creating a table than Datasheet view.

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

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.

Society encourages users to contribute to ____________________ computing,which involves reducing the electricity consumed and environmental waste generated when using computers,mobile devices,and related technologies.

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

____________________ refers to the process of determining the tables and fields that make up the database.

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

Designing to omit ____________________ will help to produce good and valid database designs.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Field can contain any characters and the total numbers of characters cannot exceed 255.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Field can contain only monetary data.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Field can store a unique sequential number that Access assigns to the record.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -A commonly accepted shorthand representation for showing the structure of a relational database.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -View that shows a report as it will appear when printed.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -View that shows a report on the screen and allows changes to the report.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -View that shows a report on the screen and does not allow changes to the report.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Can include such information as the file's author,title,or subject.