A(n) ___ contasins information about a given person, nproduct, or event.
B) record
____words are words that have a speciaal meaning to Access and cannot be used for names of fields.
A) Reserved
In Access, table and field names can be up to ____ characters in lenght.
64
A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exeed 255'
Memo
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.
D) AutoNumber
A field whose data type is ___ can store an OLE object, which is an object linked to or embedded in the table.
B) OLE object
One way to create a table, is to click _____ on the Ribbon and then click the Table button,
D) Create
when you create a table in Datasheet view, Access automatically adds a field called _____ as the first field in the table.
D) ID
To define an additional field in Datasheet view, click the ____ column heading.
D) click to add
to undo the most recent change to a table structure, click the ____ button on the Quick Acces Toolbar.
A) undo
to delete a field in a table, right click the column heading for the field and then click ____ on the shortcut menu
B) delete field
to change the name of a field, right click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name
rename field
to insert a field between existing fields, right click the column heading for the field that will follow the new field and the click ____ on the shortcut menu
A) insert field
in the accompanying figure, the key symbol that apears in the row selector for the Business Analyst Number Field indicated that Business Analyst Number is the _____ for the table
a_ principal key
b) foreign key
c) primary key
d) main key
c) primary key
to open a table in Design view, right click the table in the navigation pane and then click ____ on the shortcut menu
A) design view
to add a record to a table, click the ____ record button
New ( blank )
you can place an insertion point by clicking in the field or by pressing _____
F2
to delete a record, click the record selector for th record and the press the ___ key
delete
to change the orint orientation, click the ____ button on the Print View
Landscape
to specify Autocorrect rules and excptions to the rules, click File to open a backstage view, click ____ and then click Proofing in the dialog box that displays.
obtions
to import data to a table, click the _____ tab on the ribbon
B) external data
to save the changes to the layout of the table, click the Save button on the _____
D) quick access toolbar
to open the navigation pane, click the ____ button
A) Shutter bar open/close
to view the results of a save query, right click the query in the navigation pane and click ____ on the shortcut menu
open
to create an initial report that can be modified in layout view, click _____ on the create tab.
report
to quit Access, click the ____ button on the right side of the title bar
close
to compact and repair a database, click the ___ button in the information gallery in the backstage view
compact and repair
to back up a database use the Back Up command on the ____ tab in the backstage view
A) save and publish
to rename a database objectm right click the object in the navigation pane and then click ___ on the shortcut menu
rename
In access, the rows in the table are called recordsz
True
A unique identifier also is called a record key
False
redundancy is the storing of a piece of data in more than one place
true
in access, table names cannot contain digits
false
the maximum number of characters allowed in a field whose data type is text is 255 characters.
true
in one to many relationship, each row in the first table may be associated with many rows in the second table
true
fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo
false
The status bar contains a list of all the objects in the database
False
when access first create a database, it automatically creates a table
true
in datasheet view, a table is represented as a collection of rows and columns called a list
false
one way to undo changes to a field is to click the undo button on the Quick Access Toolbar
true
As shown on the accompanying figure, you can uuse the End record button to move to the last record in the table
false
A soft copy is information that exists on a physical medium such as paper
false
green computer involves reducing the environmental waste generaqted when using a computer
T
landscape orientation means the printout is accross the length (height) of the page
T
to print a wide database tablem a table whose contents do not fit on the screen, you will need portrait orientation
F
the textcheck feature of Access corrects common mistakes when entering text in a cell
F
Form view displays a single record at a time
T
report view shows a report on the screen and allows the user to make changes to the report
F
standard properties are associated with all Microsoft Office documents and include author, title, and subject.
T
the database Tools tab provides commands to compact repair a database
F
A (n) _________ is a software tool that can be used to create a database; add, change, abd delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data in the database.
database management system
dbms
the rows in the tables are called _____
records
A (n) _________ contains a specific piece of information within a record.
field
A unique identifier also is called a (n) _________.
primary key
_______ is the storing of a piece of data in more than one place
redundancy
______ refers to the arrangement of data into tables and fields
database design
in the accompanying figure, the _____ Pane contains a list of all the objects in the database.
Navigation
in the accompanying figure, ______ for the opeb objects appear at the top of the work area.
object tabs
________ view has more functionality for creating a table than Database view
Design
If it is desirable to have a name other than the field name that appear on thr top of the column in Datasheet view, change the field's _______ to a different name
caption
for the currency data type, access automatically sets the _____ to currency
format
to move a field, click the column heading for the field to be moved to select the field, and then ________ the field to the desired position.
drag
in _______, the table is represented as a collection of rows and colums also called a datasheet.
Database sheet
to move between the upper pane and the lower pane in the Table Design window, press ______ on the keyboard
F6
the _____ feature of Access corrects common mistakes when you complete a text entry in a cell
Auto Correct
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
D) query design
in the accompanying figure, the lower pane in the window where you enter criteria is called the ______
D) design grid
in the accompanying figure, you can delete the table by right clickng the field list and clicking ______ on the shortcut menu.
A) remove table
in the accompanying figure, the client table was added to query by selecting the table and clicking the add button in the _____ dialog box
D) show table
in the accompanying figure, you can enter BC76 in the _____ row of the client number field to find all clients whose client number is BC76
D) Criteria
in the accompanying figure, you can remove a clumn by clicking just above the field name to select the column and then clicking the ___ key(s)
A) delete
to save a query, click the Save button on the _____
quick access toolbar
to change the design of a query, right click the query and then click ____ on the shortcut menu
A) 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 the click quick print
d) print
to use a parameter query, right click the query in the navigation panr and then click ______ on the shortcut menu
A) open
in the accompanying figurem the criterion for curent due is 0. The query results for this query will display _____ in the current due field
$0.00
in the accompanying figure, the criterion for current due is 0. To find all clients whose current due amount is greater than 1,000.00, erase the 0 and enter ____ in the criteria row of the current due column.
> 1000
in the ccompanying figure, the criterion for current due is 0. to find all clients whose current due amount is $2,000,00, erase the 0 and enter ____ in the criteria row of the Amount paid column
2000
less than (<), greater than (>) and NOT (not equal) are examples of ____
A) comparison operators
to order the records in the answer to a query in a particular way, you ____ the records
sort
to sort the records in a query, specify the sort order in the _____ row of the design grid below the field that is the sort key,
sort
use a query to ___ tables; that is, to find records in two tables that have identical values in matching fields.
C) join
to use the report wizard to create a report for a query, select the query in the navigation pane, click ____ on the ribbon and then click the report wizard button
D) create
to export data from a query to Exel, selet the query in the navigation pane, click ____ on the ribbon, and then click the Exel button
a) external data
b) database tools
c) create
d) office export
a) external data
to use the expression builder to create a calculated field, select the column in the field row, right click to display the shortcut menu, and then click ______
B) build
to cinclude calculated fields in queries, enter a name for the calculated field, a (n) ________ and then the expression in one of the columns in the fild row
colon (:)
to display the entire query for a calculated field, select the column in the field row, right click to display the shortcut menu, and the click_____
A) zoom
you can include ______ in calculations to indicate which calculation should be done first.
parenthesis ( )
to include the total row in the design grid, click the ____ button on the design tab.
C) totals
to calculate statistics for only those records that satisfy certain criteria, select ______ as the entry in the total row fo the field, and then enter the criterion in the criteria row
where
to indicate grouping, in access, select ____ as the entry in the total row for the field to be used for grouping
group by
to create a crosstap, click the ___ button on the create tab
D) query qizard
when you enter text data in the criterion, you must enclose the text in quotation marks.
false
the asterisk (*) wildcard represents any individual character
false
the question mark (?) wildcard represents any invidual character
T
to find all clients whose names begin with Gr, enter Gr* in the criteria row of the design grid
T
to enter a criterion for a particular field without displaying the field in the results of the query, include the fild in the design grid, enter the criterion, and remove the check mark from its Show cehck box
T
the query that prompts for input whenever it is run is a run-time query
F
to create a parameter query that will prompt users to a city name as input, place [ Enter City] as the criterion in the City field
T
to enter a number in the criterion, type the number without any dollar signs or commas
T
unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches)
T
to find all clients whose amount paid is greater than $1,000.00and whose business analyst is analys 11, enter each criterion on different lines
F
to find all clients whose amount paid is greater than $1,000.00 or whose analyst is analyst 11, enter each criterion on the same line
F
the field or fields on which records are sorted is called the sort key
T
if you specify more than one sort key, the sort key on the left will be the minor sort key and the one on the right will be the major sort key
F
when you sort data in a query, the records in the undrlaying table are actually rearranged
F
to create a top values query, use the top values box on the design tab to change the n umber of records to be included from All to the desired number
F
you cannot create a form for a query
F
the only calculated fields you can create in Access are whose involving addition
F
grouping means creating groups of records that share common characteristic
T
to include all fields for a table in the design grid, click the ______ in the field list
asterisk (*)
to change the design of a query that is not currently open, right click the query in the navigation ane and then click _____ on the shortcut menu
design view
________ are symbols that represent any character or combination of characters
wildcards
the ______ wildcard represents any individual character
question mark (?)
A (n) ______ query is a query that prompts for input whenever it is used
parameter
to combine criteria with ______, place the criteria on the same line.
