Shared Flashcard Set

Details

Microsoft Access 2003 Set 4
Vocabulary and Concepts for Access
30
Computer Science
Not Applicable
03/18/2011

Additional Computer Science Flashcards

 


 

Cards

Term
detail lines
Definition
lines that are printed for each record that contain only those fields you specify and in the order you specify
Term
Database design
Definition
arrangement of data into tables and fields
Term
remove redundancy
Definition
What is  the one main principle in database design?
Term
redundancy
Definition
storing the same fact in more than one place
Term
d
Definition

Why is redundancy a problem?

a) it wastes memory space

b) it makes updating the database more difficult

c) there is a possibility that data will be inconsistent

d) all of the above

e) all but b

f) all but c

Term
normalization
Definition
a special technique that identifies and eliminates redundancy
Term
query
Definition
a question represented in a way that Access can understand
Term
Select Query window
Definition
a  special window where you create a query by making entries
Term
a
Definition

It is easier to work with a Select Query window if it is:

a) maximized

b) minimized

c) restored

Term
design grid
Definition
the lower pane in the Select Query window where you specify fields to be included, sort order, and the criteria the records you are looking for must satisfy.
Term
Queries by Example
Definition
What does QBE mean?
Term
QBE
Definition
a query language first proposed in the mid-70's, where users asked questions by filling in a table on a screen
Term
Edit; Delete
Definition
If you select the wrong field in the grid in the Query window, click ____ and then ____.
Term
Run; Query Design
Definition
Once you have created the query, you produce the results using the ___ button on the ______ toolbar.
Term
SQL
Definition
the most widespread query language where users type commands to find information
Term
* (asterisk)
Definition
Which symbol in the field list do you select to indicate that you want all the fields to be included in a query?
Term
Edit; Clear Grid
Definition
The simplest way to clear out entries in a query is to click ____ on the menu bar and click ______.
Term
c
Definition

Some database systems require that text data be enclosed in:

a) brackets

b) parentheses

c) quotation marks

d) colons

Term

False

 

Access inserts the quotation marks automatically

Definition
T or F: Access requires that you insert text data with quotation marks.
Term
text data
Definition
data in a field whose data type is Text
Term
wildcards
Definition
symbols that represent any character or combination of characters
Term
(*) asterisk
Definition
wildcard that represents any collection of characters
Term
(?) question mark
Definition
wildcard which represents an individual character
Term
asterisk, question mark
Definition
What are two wildcards?
Term
e
Definition

If you type Fa*, which records below would probably show up?

a) Fab

b) Fall

c) Face

d) Factory

e) all of the above

Term
f
Definition

If you saw something written T?m, which records would you expect to see:

a) Term

b) Tom

c) Tim

d) Tbm

e) all of the above

f) all but a

Term
False
Definition
T or F: You can't add or edit records in Query Datasheet view
Term
parameter query
Definition
a query that prompts for input whenever it is run
Term
field
Definition
When creating a parameter query, it is important that the enclosed value does not match the name of any _____.
Term
square brackets
Definition
You enclose the value of a parameter query in _______.
Supporting users have an ad free experience!