Shared Flashcard Set

Details

Microsoft Access 2007
Getting Started with Microsoft Access 2007
66
Computer Science
Undergraduate 1
10/25/2010

Additional Computer Science Flashcards

 


 

Cards

Term
TERM
Definition
DEFINITION
Term

 

 

>=

Definition
To find numbers greater than or equal to 500, use which comparison operator?
Term

 

 

[SQUARE BRACKETS]

Definition
When referencing field names within an expression, surround the field name with ____.
Term

 

 

=COUNT([CITY])

Definition
Which of the following is the correct expression to count the number of records using a field named City?
Term

 

 

ASTERISK (*)

Definition

 

 

The wildcard character that stands for any group of characters is the ____.

Term
AT THE TOP OF EVERY PAGE (BUT BELOW THE REPORT HEADER ON PAGE ONE)
Definition
The Page Header section prints ____.
Term
CHECK BOX
Definition
Which of the following would most likely be used to display a Yes/No field on a form?
Term
CLICK, [SHIFT]+CLICK
Definition
Which technique would you use to select several controls in Form Design View?
Term
COMMAND BUTTON
Definition
This control provides an easy way to initiate a command or run a macro.
Term
COMMAND BUTTON
Definition
This control provides an easy way to initiate a command or run a macro.
Term
CREATE WIZARD
Definition
Which of the following is NOT a way to create a new form?
Term
DATASHEET
Definition
Click the ____ View button from Query Design View to display the resulting fields and records from a query.
Term
DESCENDING
Definition
Sorting in a Z to A, then 9 to 0 order is called a(n) ____ order.
Term
DETAIL
Definition
Text boxes bound to underlying fields are generally placed in this report section.
Term
FILTER
Definition
A(n) ____ is a temporary view of the data whose criteria are discarded when you close the datasheet.
Term
FORM
Definition
After making modifications in Form Design View, click the ____ View button to view the form and enter data.
Term
FORM
Definition
After making modifications in Form Design View, click the ____ View button to view the form and enter data.
Term
GROUP HEADER
Definition
A text box control bound to the field by which the records are grouped would most likely be found in which report section?
Term
GROUP HEADER AND GROUP FOOTER
Definition
Which two sections can be added to a report if you group records?
Term
GROUP, SORT, AND TOTAL
Definition
The Group Header and Group Footer section can be turned on or off in which pane?
Term
IS NOT NULL
Definition
____ will find all records where there is any entry in the field, even if the entry is 0.
Term
LABEL
Definition
This control is used to provide consistent descriptive text as you navigate from record to record.
Term
LABEL
Definition
Which control is most commonly placed in the Report Header section?
Term
LABEL
Definition
Which of the following is NOT a bound control?
Term
SELECT
Definition
In Form Design View, you use the white arrow pointer to ____ controls.
Term
SELECTION
Definition
This button filters records that equal, do not equal, or are otherwise compared to the current value.
Term
TO ENTER AND UPDATE DATA
Definition
Which of the following is NOT a common use for an Access report?
Term
TOGGLE BUTTON
Definition
Which control, when "pressed" displays "yes" information?
Term
COMMAND
Definition
The _______ button control provides an easy way to run a macro.
Term
CRITERIA
Definition
Limiting conditions used to narrow the number of records on a datasheet
Term
DETAIL
Definition
Text boxes that display data in underlying records are generally placed in a report's _____ section.
Term
DETAIL
Definition
Text boxes that display data in underlying records are generally placed in a report's ________ section.
Term
FIELD
Definition
The upper portion of Query Design View shows a table's ________ list.
Term
FIELD
Definition
In Form Design View, the ______ List contains the database tables and fields from the record source.
Term
FILTER
Definition
Creates a temporary subset of records
Term
GRID
Definition
In Query Design View, the query design ______ shows you the fields that you have requested for the query.
Term
GROUPING
Definition
The term ______ refers to sorting records plus providing a section before and after the group of records.
Term
IS NULL
Definition
Criterion that finds all records where no entry has been made in the field
Term
LANDSCAPE
Definition
Paper orientation that is 11" wide by 8.5" tall is referred to as ______ orientation.
Term
NULL
Definition
Is ______ criteria will find all records where no entry has been made in the field.
Term
PRIMARY
Definition
By default, records in a table datasheet are sorted on the _____ key field.
Term
QUERY
Definition
Creates a datasheet of selected fields and records from one or more tables
Term
QUERY GRID
Definition
The lower pane in Query Design View
Term
REPORT
Definition
A(n)______ is an Access object whose primary purpose is to create professional printouts.
Term
SORTING
Definition
Putting records in ascending or descending order based on a field’s values
Term
SYNTAX
Definition
Rules that determine how criteria is entered
Term
TEXT
Definition
Calculated expressions are entered in _____ box controls.
Term
TOGGLE
Definition
The ___ button control displays "yes" or "no" answers for a field.
Term
UNDO
Definition
[Ctrl][Z] is the quick keystroke for the ______ command.
Term
WILDCARD
Definition
Used to search for a pattern
Term
WILDCARDS
Definition
_____ are symbols you can use as substitutes for characters to find information that matches your find criteria.
Term
FALSE
Definition
SQL is the acronym for “simple query language”.  TRUE or FALSE?
Term
FALSE
Definition
Once you have filtered a datasheet to display a subset of records, you cannot sort the records.  TRUE or FALSE?
Term
FALSE
Definition
A filter can be used to create calculated fields. TRUE or FALSE?
Term
FALSE
Definition
A filter cannot be saved as a query.  TRUE or FALSE?
Term
FALSE
Definition
You would use line and rectangle controls to add data to a form. TRUE or FALSE?
Term
FALSE
Definition
A calculation can begin with a <>, >, or equal sign. TRUE or FALSE?
Term
FALSE
Definition
In Form Design View, the pointer that looks like a white arrow will move records. TRUE or FALSE?
Term
FALSE
Definition
Forms have more sections than reports do. TRUE or FALSE?
Term
FALSE
Definition
If a multicolored report is printed on a black and white printer, its colors will stay true. TRUE or FALSE?
Term
TRUE
Definition
The Find and Replace dialog box allows you to specify whether Access looks for search criteria in a single field or in the entire datasheet. TRUE or FALSE?
Term
TRUE
Definition
Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary sort field. TRUE or FALSE?
Term
TRUE
Definition
A query can be used to create calculated fields. TRUE or FALSE?
Term
TRUE
Definition
On a form, text box controls display data from an underlying record source. TRUE or FALSE?
Term
TRUE
Definition
The Report Wizard applies many formatting choices to a report. TRUE or FALSE?
Term
TRUE
Definition
Calculated expressions within text boxes start with an equal sign. TRUE or FALSE?
Supporting users have an ad free experience!