BIM Final Review 2013 – Flashcards
Unlock all answers in this set
Unlock answersquestion
A ______ is a software tool that can be used to create a database; and create forms and reports using the data in the database.
answer
Database Management System
question
A _______ contains a specific piece of of information within a record.
answer
Field
question
A unique identifier also is called a ______________.
answer
Primary Key
question
_________ is the storing of a piece data in more than one place.
answer
Redundancy
question
__________ refers to the arrangement of data into tables and fields.
answer
Database Design
question
The determination of database requirements is part of a process known as __________.
answer
System Analysis
question
In the accompanying figure, the _______ Pane contains a list of all the objects in the database.
answer
Navigation
question
In the accompanying figure, the entire are that displays on the screen is called the _______work area.
answer
Access
question
In the accompanying figure, __________ for the open objects appear at the top of the work area.
answer
object tabs
question
For the Currency data type, Access automatically sets the ______ to Currency
answer
format
question
In _____________, the table is represented as a collection of rows and columns called a datasheet
answer
Datasheet view
question
The _________ feature of Access corrects common mistakes when you complete a text entry in a cell.
answer
Auto correct
question
To include all fields for a table in the design grid, click the ________ in the field list.
answer
Asterisk
question
The results of a query display in _________ view.
answer
Datasheet
question
To change the design of a query that is not currently open, right-click the query in the Navigation Pane and then click__________ on the shortcut menu.
answer
Design view
question
The __________ wildcard represents any collection of characters.
answer
Asterisk
question
A __________query is a query that prompts for input whenever it is used.
answer
Parameter
question
A ________ is a window containing the various properties of the object.
answer
Property Sheet
question
The accompanying figure shows a join of the Business Analyst and Client tables. __________ joins are used to show all the records in one table as well as the common records; that is, the records that share the same value in the join field.
answer
Outer
question
The accompanying figure shows a join of the Business Analyst and Client tables. ____ properties are the properties that indicate which records appear in a join.
answer
Join
question
The ___ function finds the smallest value in a group of records.
answer
MIN
question
Maintenance of the database can involve the need to ___________ periodically; that is, to change the database structure.
answer
Restructure The Database.
question
A __________ is a form that allows you to simultaneously view both simple form and datasheet views structure.
answer
Split Form
question
When you have created a filter using Advance Filter/Sort, you can save the filter setting as a query by using the ___________ command on the Advanced menu.
answer
Save as Query
question
To create a lookup field, select ___________ from the menu available data types.
answer
Lookup Wizard
question
If you plan to move your data to SQL Server at a later date, do not use ___________ fields.
answer
Multivalue
question
To create a multivalued field, create a _________ field being sure to check the Allow Multiple Values check box.
answer
Lookup Field
question
When an update query is created, a ____________ row displays in the design tab.
answer
Update To
question
To change grid lines in a datasheet, open the table in Datasheet view, select the entire datasheet, and click the _________ button on the Home tab.
answer
Grid Line
question
The property that the value in a foreign key must match another table's primary key is called _________________.
answer
Referential Integrity
question
When specifying referential integrity, one way to handle deletions is to ___________; that is, have Access allow the deletion but then automatically delete any related records in other tables.
answer
Cascade the Delete
question
To add the Business Analyst and Client tables to the Relationships window shown in the accompanying figure, click the Add button in the ________ dialog box.
answer
Show Table
question
In the type of relationship between the Business Analyst and Client tables illustrated in the accompanying figure, the infinity symbol indicates that one analyst is related to _________ clients.
answer
Many
question
To print a copy of a relationship, click the ______________ button shown on the accompanying figure.
answer
Relationship Report
question
A _________ conveys a visual representation of data.
answer
Chart
question
Worksheet ____________ typically contain descripitive information about items in rows or contain information that helps to group th data int he worksheet.
answer
Colums
question
The cell into which data is being entered is referred to as the ___________ cell.
answer
Active
question
As you type, Excel displays the entry in the __________ and also displays the Cancel box and the Enter box on the formula bar.
answer
Formula Bar
question
__________ corrects two initial capital letters by changing the second letter to lowercase.
answer
Auto Correct
question
If the next entry you want to make is in an adjacent cell, use the __________ keys to complete the entry in the current cell and active the adjacent cell.
answer
Arrow
question
Excels _______ which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.
answer
Sum Function
question
You can click the ______ button arrow (Home tab / Editing group) to view a list of often used functions.
answer
Sum
question
The automatically adjusted cell reference in a pasted formula is called a ______________.
answer
Relative Reference
question
The _______________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.
answer
Auto Fill Options
question
An increased ___________ gives more impact to text in a cell.
answer
Font Style
question
___________ indicates how text characters are emphasized.
answer
Font Style
question
The default font for a new workbook is _________ 11- point regular black.
answer
Calibri
question
A ______ chart that often is used to illustrate changes in data over time.
answer
Line
question
The function, or _________, of a worksheet is to provide is to a user with direct ways to accomplish tasks.
answer
Purpose
question
When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ___________.
answer
MM/DD/YYYY
question
If you have a long text entry, such as a paragraph, you can instruct Excel to _________ text in the cell.
answer
Wrap
question
One of the reasons Excel is such a valuable tool is that you can assign a __________ a cell, and Excel will calculate the result.
answer
Formula
question
A formula in a cell that contains a reference back to itself is called a __________________.
answer
Circular Reference
question
The / arithmetic operator indicates __________.
answer
Division
question
In the order of operations, the last operation Excel performs is __________.
answer
Subtract
question
Typing =av in a cell displays the ____________________.
answer
Formula Auto Correct List
question
You can press the _____ key to quit Range Finder.
answer
Esc
question
A ____ is a dot on the screen that contains a color.
answer
Pixel
question
To set row height to best fit, ____________ the bottom boundary of the row heading.
answer
Double Click
question
Excel includes a _____________ you can use to check a worksheet for spelling errors.
answer
Spell Check
question
Always take time to check the _________ of a worksheet before submitting it to your supervisor.
answer
Formulas
question
You can click the Page Layout view button on the ________ to switch to Page Layout view.
answer
Status Bar
question
___________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.
answer
Margins
question
__________ are values in cells that can be changed to determine new values for formulas.
answer
Assumptions
question
You can ensure corrections in your _______________ by carefully checking them using Range Finder.
answer
Formulas
question
A ____________ is a good way to compare visually a small set of numbers.
answer
3-D Pie Chart
question
____________ allows you to automatically to modify values in a what-if area of a worksheet based on a goal that you have for another cell in the worksheet.
answer
Goal Seeking
question
You know Excel is in copy mode when a small plus sign appears next to the block arrow mouse pointer during a ________ operation.
answer
Drag & Drop
question
Excel allows you to ________ the titles remain on the screen no matter how far down or to the right you scroll.
answer
Freeze
question
AND,OR, and NOT are ________ operations.
answer
Logical
question
__________ chart formatting is restricted greatly as compared to standard charts.
answer
Spark Line
question
You can specify the style and color for the parts of a spark line chart by selecting a style in the Styles group on the ______________________________________________.
answer
Spark Line Tools Design Tab
question
The ____________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.
answer
Color Bar
question
When Excel draws a ____ chart, it always positions the chart so that one of the dividing lines between two slices is a straight line pointing to 12 o' clock (or 0 degrees).
answer
Pie
question
A sensitivity analysis is another name for a ___________.
answer
What If Analysis
