NEW
Font size
WorksheetsAccess Mod 1 Q2
Total questions: 40
Worksheet time: 20mins
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.
Change Column
Rename Column
Change Field
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.
Field Size
Format
Caption
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
Insert Column
Insert Field
Add Column
Add Field
To add a record to a table, tap or click the ____ record button.
Add New
New (Blank)
Last
Insert (New)
You can place an insertion point by tapping or clicking in the field or by pressing ____.
F2
F3
F4
F5
To delete a record, tap or click the record selector for the record, and then press the ____ key(s).
CTRL+DELETE
CTRL + Y
DELETE
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.
Customize
Manage
Options
Grammar
To save the changes to the layout of a table, tap or click the Save button on the ____.
status bar
TABLE TOOLS tab
Navigation Pane
Quick Access Toolbar
To import data to a table, tap or click the ____ tab on the ribbon.
Database tools
File
External data
Import
To open the Navigation Pane, tap or click the ____ Button.
Open Navigation Pane
Open Pane
Shutter Bar Open/Close
Navigation Bar Show/Hide
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.
Datasheet View
Open
Results View
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.
Open
SQL
Query Window
Design View
To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.
Close and Back Up
Back Up Current
Save As Back Up
Back Up Database
To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
Restore
Fix
Compaction
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.
Erase
Trash
Delete
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.
New Name
Redefine
Rename
Save Name
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
human resource management system
learning management system
word processing
The rows in the tables are called ____________________.
fields
files
records
views
A(n) ____________________ contains a specific piece of information within a record.
file
field
column
row
The ____________________ data type in Access is referred to as Money in SQL Server.
Short Text
Long Text
Currency
Primary Key
____________________ view has more functionality for creating a table than Datasheet view.
Layout
Normal
Report
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
INSERT
HOME
Design Query
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
Delete Field
Hide Fields
Freeze Fields
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.
digital
green
personal
recycle
A hard copy or ____________________ is information that exists on a physical medium such as paper.
printout
documented
formatted
webpage
____________________ refers to the process of determining the tables and fields that make up the database.
File, New
Pre-Planning
Database design
Formatting
The determination of database requirements is part of a process known as ____________________.
data mining
programming
requirements gathering
system analysis
Designing to omit ____________________ will help to produce good and valid database designs.
redundancy
primary keys
errors
size
To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query
Query
Design View
Query Design
Select Query
To save a query, click the Save button on the ____.
Status Bar
Quick Access Toolbar
CREATE tab on the ribbon
HOME tab on the ribbon
To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.
Datasheet View
Design View
Open
Run
To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.
Datasheet View
Layout View
Change View
Design View
To print the results of a query that is open, click FILE on the ribbon, click the ____ tab in the Backstage view, and then click Quick Print.
Preview
Query
Print Query
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.
curly braces { }
square brackets [ ]
parentheses ( )
single quotes ‘’
To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.
Use Parameter
Enter Values
Open
Run
Less than (<), greater than (>), and NOT (not equal to) are examples of ____.
compound conditions
comparison operators
compound values
conditions
The ____ operator allows you to search for a range of values in one field.
BETWEEN
RANGE
IN
SEARCH
To order the records in the answer to a query in a particular way, you ____ the records.
index
sort
arrange
list
To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.
Show
List
Sort
Order
To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
No
Yes
Off
On
