BIM Access Chapter 1 Test
Fill in the Blank In Access, table and field names can be up to _____ characters in length.
64
Fill in the Blank A field with the ___ date type can contain an attached file, such as an image, document, chart, or spreadsheet.
Attachment
Fill in the Blank 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.
Auto Number
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.
AutoNumber
Fill in the Blank To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.
Back up Database
The simplest approach to recovery involves periodically making a copy of the database (called a(n) _____ copy or save copy).
Backup
Fill in the Blank 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
Fill in the Blank 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
Fill in the Blank To define an additional field in Datasheet view, tap or click the ____ column heading.
Click to Add
Fill in the Blank To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
Compact and Repair
Fill in the Blank The _____ data type in Access is referred to as Money in SQL Server.
Currency
Fill in the Blank To delete a record, tap or click the record selector for the record, and then press the ____ key(s).
DELETE
In Access, all the tables, reports, forms, and queries that you create are stored in a single file called a(n) _____.
Database
Fill in the Blank ____ refers to the process of determining the tables and fields that make up the database.
Database Design Process.
A(n) ____, such as access, is software that allows you to use a computer to create a database.
Database Management System
Fill in the Blank 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.
Database Management System
Fill in the Blank Access is a _______.
Database Management System
Fill in the Blank 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
Fill in the Blank 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
Fill in the Blank ___ view has more functionality for creating a table then Datasheet view.
Design
_____ view is only used to create a table or to modify the structure of a table.
Design
Fill in the Blank 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.
Design View
Fill in the Blank To import data to a table, tap or click the ____ tab on the ribbon.
EXTERNAL DATA
Fill in the Blank You can place an insertion point by tapping or clicking in the field or by pressing ____.
F2
True or False A record contains a specific piece of information within a field.
False
True or False Access 2013 has a number of reserved words, which are words that have a special meaning to Access. You cannot use these reserved words as field names.
False
True or False Database users typically use standard guidelines for naming tables.
False
True or False Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of memo.
False
True or False In Access, field names cannot contain digits.
False
True or False In Access, the columns in a table are called records.
False
True or False In Datasheet view, a table is represented as a collection of rows and columns called a list.
False
True or False Layout view allows you to make changes, but it does not show you the actual report.
False
True or False One way to undo changes to a field is to click the undo button on the status bar.
False
True or False The Character data type is used for a field that can store a variable amount of text or combinations of text or combinations of text and numbers where the total number of characters may exceed 255.
False
True or False The determination of database requirements is part of a process known as systems development.
False
True or False To preview and then print the contents of a table, use Table Preview
False
True or False To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation
False
True or False To remove empty space from deleted objects from the database, ou must condense the database.
False
Modified True or False if the statement is false, write the correct answer in the line provided. A field that has the calculated data type can store a unique sequential number that Access assigns to a record. ________________
False, Auto number
Modified True or False if the statement is false, write the correct answer in the line provided. 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.
False, Delete
Modified True or False if the statement is false, write the correct answer in the line provided. 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. _____________
False, Field
Modified True or False if the statement is false, write the correct answer in the line provided. The Term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ________________
False, Relational
Fill in the Blank A(n) _____ contains a specific piece of information within a record.
Field
Fill in the Blank A(n) _____ contains information about a given person, product, or event.
Field
Fill in the Blank To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.
Format
Fill in the Blank Society encourages users to contribute to _____ computing, which involves reducing the environmental waste generated when using a computer.
Green
A field whose data type is ____ can store text that can be used as a hyperlink address.
Hyperlink
the first step in database design process is to ___.
Identify the Tables
Fill in the Blank 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.
Insert Field
Fill in the Blank 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.
InsertField
____ orientation means the printout is across the height of the page.
Landscape
If a problem occurs, you can correct the problem by overwriti gthe actual database -- often referred to as the _____ database -- with the backup copy.
Live database
The _____ field size is for values in the range of -2,147,483,648 to 2,147,483,648.
Long Integer
Fill in the Blank 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.
Long Text
What contains a list of all of the objects in the database and is used to open an object?
Navigation Pane
Modified Multiple Choice The Access window consists of a variety of components. These include the ____.
Navigation Pane, Content Pane, Object tabs, and Quick Access Toolbar.
Fill in the Blank To add a record to a table, tap or click the ____ record button
New (blank)
Fill in the Blank A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.
OLE object
Fill in the Blank 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
Fill in the Blank 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.
Options
Another name for a unique identifier is?
Primary Key
When working with a report in access, there are four different ways to view the report. They are report view, ____ ____, layout view, and design view.
Print Preview
Fill in the Blank A hard copy or __________ is information that exists on a physical medium such as paper
Printout
Database ________, also known as metadata, can include information as the file's author, title, or subject.
Properties
____ are simply questions, the answers to which are in the database.
Queries
Modified Multiple Choice File names cannot contain a(n) ____.
Question mark or Colon
To save the changes to the layout of a table, tap or click the Save button on the ___
Quick Access Toolbar
Fill in the Blank The rows in the table are called ____.
Records
The rows in the tables are called ___.
Records
Fill in the Blank 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
What type of database is maintained by access, and consists of a collection of tables, each of which contains information on a specific subject?
Relational Database
Fill in the Blank 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
Fill in the Blank 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.
Rename Field
Fill in the Blank ______ words are words that have a special meaning to Access and cannot be used for the names of fields.
Reserved
To see the field size and/or caption for a field, tap or click the field's _____, which is the small box that precedes the field.
Row Selector
Fill in the Blank A field whose data type is _______ can contain any characters.
Short Text
Fill in the Blank To open the Navigation Pane, tap or click the ____ Button.
Shutter Bar Open/Close
For fields whose type is Short Text, you can change the field _____, that is, the maximum number of characters that can be entered in the field.
Size
Fill in the Blank The determination of database requirements is part of a process known as ___.
System Analysis
Modified True or False if the statement is false, write the correct answer in the line provided. 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
True or False A unique identifier is also called a primary key.
True
True or False Changing the column width in a datasheet changes the Layout or Design of a table.
True
True or 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
True or False Form view displays a single record at a time.
True
True or False Landscape orientation means the printout is across the length (height) of the page.
True
True or False Layout view shows a report on the screen and allows the user to make changes to the report.
True
True or False Redundancy means storing the same fact in more than one place.
True
True or False Standard properties are associated with all Microsoft Office documents and include author, title, and subject.
True
True or False The Currency data type is used for fields that contain only monetary data.
True
True or False The Navigation Pane contains a list of all the objects in the database.
True
True or False The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.
True
True or False The process of determining the tables and fields that make up the database is referred to as database design.
True
True or False The status bar, located at at the bottom of the Access window, presents information about the database object, the progress of current tasks, and the stats of certain commands and keys.
True
True or False When Access first creates a database ,it automatically creates a table.
True
True or False When you link to data in a worksheet, the data appears as a table in the Access database but it is maintained in its original form in Excel.
True
Modified Multiple Choice A field with Yes/No data type can store only one of two values. The choices are _____.
True/False, Yes/No, and On/Off
For each field in your database, you must determine the field's data ____, which indicates what can be stored in the field.
Type
To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.
Undo
What area do you work on objects such as tables, forms, and reports?
Work Area
