term1 Definition1term2 Definition2term3 Definition3
Please sign in to your Google account to access your documents:
What is a spreadsheet?
A program that allows you to eneter and manipulate values along with labels that tells what those values represent
What is microsoft Access?
An electronic database that stores data in tables
WHat is database?
A container that houses your information
What is a query?
Feature in database that allows you to answer questions about the info in your database
Feilds (columns) are called_________
Records(rows) are called __________
Attributes
Tuples
What is a feild type/data type
Type of data entered in a feild
What is feild size?
Maximum number of characters that is allowed in the feild
Describe the different feild types
Text- allows a combination of text, special characters and numbers that are not used in calculations. 255 characters eg. telephone numbers, address,email
Memo- allows a combination of text,special characters and numbers. up to 64000 characters
Number-allows numeric characters to be entered in feilds that are only involved in calculations
Currency- use data that involvess money eg salary,price,fee,cost
Yes/No- Allows you to choose one of two values
Date/time- Used for dates and or time eg. date of birth,appointment date
Need help typing ? See our FAQ (opens in new window)
Please sign in to create this set. We'll bring you back here when you are done.
Discard Changes Sign in
Please sign in to add to folders.
Sign in
Don't have an account? Sign Up »
You have created 2 folders. Please upgrade to Cram Premium to create hundreds of folders!