Tech Ed
Home
Teacher Guide
Time Lapse
Digital Life Survey
Footprint
Copyright
Creative Commons
Resumes
Cover Letter
Digital Story Telling
Gamestar Mechanic
Gamestar Mechanic 2
Keyboarding
Food Drive Flyer
Time Lapse Videos
Google & Word
Throwback Thursday
Word Cloud Life
Gamestar A
CyberSafety
Uploads
Excel Account Book
Excel Quiz Part 1
Excel Quiz Part 2
Contest - Motivator Posters
Math Tasks
Computer terms from Microsoft Office Suite
Access - a database application
use these files to answer the questions on this page
accesslesson2keyterms.pdf
File Size:
21 kb
File Type:
pdf
Download File
accesslesson3keyterms.pdf
File Size:
27 kb
File Type:
pdf
Download File
accesslesson4keyterms.pdf
File Size:
33 kb
File Type:
pdf
Download File
accesslesson5keyterms.pdf
File Size:
20 kb
File Type:
pdf
Download File
accesslesson6keyterms.pdf
File Size:
20 kb
File Type:
pdf
Download File
define these terms - enter the complete definition
All the answers come from the access files on this page.
*
Indicates required field
Name
*
First
Last
Creating a Database
Primary key
*
Alphanumeric data
*
Creating and Modifying
Reports
Report Wizard
*
Read-only
*
Data type
*
Report tool
*
Grouping level
*
Creating Queries
Condition
*
Report selector
*
And operator
*
Or operator
*
Integrating Access
Comma-separated values
*
Delimiter
*
Creating and Modifying
Forms
Multiple Items tool
*
Bound control
*
Form Wizard
*
Delimited data
*
Choose the best answer for each
CREATING A DATABASE
What makes data alphanumeric?
*
The field that contains a unique field value for each record in the table is called the
*
This determines the kind of data that you can enter in the field
*
Creating Queries
Selects records that match all of two or more conditions in a query
*
Selects records that match at least one of two or more conditions in a query
*
This is a way of telling the query which data you are interested in seeing
*
Creating and Modifying
Forms
This helps you create a form
*
This creates a form that lists all the fields in a datasheet format
*
Creating and Modifying
Reports
An easy way to access the report’s Property Sheet is to click the
*
Use this when you want to create a report quickly.
*
This organizes data based on one or more fields
*
Integrating Access
File format where commas separate the field values of each record in the data source
*
Data that is formatted using comma separators
*
Creating a Database
1.Which one shows alphanumeric data?
*
Monday, Tuesday, Wednesday,
1999, 2000, 2001, 2002, 2003
April 13, May 6, May 8, June 13,
CREATING QUERIES
Selects records that match one condition
*
And operator
Or operator
Selects records that match all conditions
*
And operator
Or operator
CREATING AND MODIFYING
FORMS
Use this to create a simple form quickly
*
Record Wizard
Data Wizard
Form Wizard
CREATING AND MODIFYING
REPORTS
Grouping Level
*
Deletes data
Organizes data
Alphabetizes data
You cannot change this data
*
numeric
grouped
read-only
Integrating Access
When data is formatted using comma separators, the commas are called
*
data
delimiters
commas
What does CSV stand for?
*
Common stock vault
Creative source value
Comma separated values
What program have these questions been about?
*
Excel
Outlook
Access
Do you know what EOCTs you will be taking?
*
yes
no
Submit