Shared Flashcard Set

Details

Microsoft Access 2010
n/a
26
Computer Science
12th Grade
12/17/2012

Additional Computer Science Flashcards

 


 

Cards

Term
Access
Definition
database management component of Microsoft Office
Term
database
Definition
collection of related information
Term
table
Definition
database object that contains data collected about a single type of person, place, or thing (e.g., employees, books, cars)
Term
form
Definition
database object used to enter new data in a table or review or edit existing data in a table
Term
report
Definition
database object used to present data from one or more tables in a useful manner, either on-screen or on paper
Term
query
Definition
database object used to locate records that meet one or more conditions defined by the user
Term
criteria
Definition
conditions defined by the user when forming a query (e.g., city = "Beckley" or age < 21)
Term
field
Definition
one piece of information in a table (e.g., Name, Address, Department)
Term
record
Definition
the complete set of fields for an individual entity in a table (e.g., all the information about one employee, one book, or one car)
Term

5 fields

7 records

Definition

How many fields and records in the table shown below?

 

[image]

 

Term
EmpID--because it is unique for every record
Definition

In the table below, which field is the best choice for primary key? Why?

 

[image]

Term
primary key
Definition
field that uniquely identifies one record from all other records in the table (e.g., SSN, WVEIS#)
Term
data type
Definition
identifies the type of data that will be stored in a field
Term
text
Definition
recommended data type for fields containing numbers on which no arithmetic operations will be performed
Term
Datasheet View
Definition
table view in which the contents of all records are displayed in columns and rows similar to a spreadsheet
Term
Design View
Definition
table view in which fields are added and removed and field information is displayed and edited
Term
Field Properties
Definition
Field Size and Format are examples of these
Term
wizard
Definition
stepwise guide to creating Access objects like forms and queries
Term
sorting
Definition
process of reordering the records in a table on the basis of one or more fields
Term
Find
Definition
operation that locates and highlights fields that match a criteria designed by the user
Term
Replace
Definition
operation that locates and highlights fields that match a criteria designed by the user and substitutes another value
Term
create new table - table design
Definition

Identify the functions of the buttons shown:

 

[image]  [image]

Term
create new form - form design
Definition

Identify the functions of the buttons shown:

 

[image]  [image]

Term
create new report - report design
Definition

Identify the functions of the buttons shown:

 

[image]  [image]

Term
query design - query wizard
Definition

Identify the functions of the buttons shown:

 

[image]  [image]

Term

A - first record

B - previous record

C - current record

D - next record

E - last record

F - new record

Definition

Identify the functions of the buttons shown in the Record Navigation panel:

 

[image] 

 

Supporting users have an ad free experience!