ISTM 210 Exam 3 ACTUAL UPDATED QUESTIONS AND CORRECT ANSWERS
Quick Stove small co. that sells emergency preparedness and backpack equipment. Location:
Orem, Utah
Navigation Pane provides way for user to interact w/various objects in database files
Types of Objects Tables
Queries
Forms
Reports
Tables used to store data in access. Columns- store data fields
rows- store database records. Most important
Queries used to find specific data you need from a database. Does not give a copy of
data, rather a diff view
Forms Used to make entering new or updating existing records easy. A window that
displays data in a table. Only shows one record from the table at a time.
Reports allow you to organize and present data. Aids in managerial decision making.
Generates from tables or queries.
Views different ways to look at an object
Access is a relational database
Naming fields should be meaningful and descriptive- spaces not recommended, no special characters
Short Text store data that won't be treated like a number for calculations. Ex. Phone #'s and
zip codes. limited to 255 characters
Long Text stores large amts. of text. Limited to 65,536 characters.
Number stores + and - #'s. Can contain decimal. Used for calculations
Date/Time store date or time info. Can be formatted to display in several diff ways.
Currency number data type that places $ symbol in front
, Autonumber automatically insert value for autonumber field when a new record is added to a
table
Yes/no store data with only 2 possible values. T/F, On/Off, Yes/No
OLE object used to store files created by other programs like Word, Excel, etc.
Hyperlink used to store links to websites or other folders/files on your computer
Attachment store files for database record. Can be any type of file including pics, sound, and
videos
Calculated used to create a field that is generated by a formula. Refer to values in other fields
for a record
Lookup Wizard simplifies data entry. Presents user w/list of items to choose from when entering a
new record.
Field Properties can be modified for a field
Field Size determines how large field will be, numbers stored in field can be, and precision.
Text- determines how many characters will be stored for each record
Input Mask used to set rules on how data will be entered for a field
Default Value used to automatically set a starting value for a field when a new record is added
to table
Validation Rule/Text work together. Check values when entered into table to make sure they fit a
specific rule.
Required used to make sure that a value is entered into a field when a new record is added
to the table
Primary Key first field in a table used to uniquely identify each of the records
Foreign Key when a field is used to link two tables
Well designed data base Advantages -less costly
-easy to use
-helps ensure data integrity (consistent & accurate)
-avoid data redundancy
Quick Stove small co. that sells emergency preparedness and backpack equipment. Location:
Orem, Utah
Navigation Pane provides way for user to interact w/various objects in database files
Types of Objects Tables
Queries
Forms
Reports
Tables used to store data in access. Columns- store data fields
rows- store database records. Most important
Queries used to find specific data you need from a database. Does not give a copy of
data, rather a diff view
Forms Used to make entering new or updating existing records easy. A window that
displays data in a table. Only shows one record from the table at a time.
Reports allow you to organize and present data. Aids in managerial decision making.
Generates from tables or queries.
Views different ways to look at an object
Access is a relational database
Naming fields should be meaningful and descriptive- spaces not recommended, no special characters
Short Text store data that won't be treated like a number for calculations. Ex. Phone #'s and
zip codes. limited to 255 characters
Long Text stores large amts. of text. Limited to 65,536 characters.
Number stores + and - #'s. Can contain decimal. Used for calculations
Date/Time store date or time info. Can be formatted to display in several diff ways.
Currency number data type that places $ symbol in front
, Autonumber automatically insert value for autonumber field when a new record is added to a
table
Yes/no store data with only 2 possible values. T/F, On/Off, Yes/No
OLE object used to store files created by other programs like Word, Excel, etc.
Hyperlink used to store links to websites or other folders/files on your computer
Attachment store files for database record. Can be any type of file including pics, sound, and
videos
Calculated used to create a field that is generated by a formula. Refer to values in other fields
for a record
Lookup Wizard simplifies data entry. Presents user w/list of items to choose from when entering a
new record.
Field Properties can be modified for a field
Field Size determines how large field will be, numbers stored in field can be, and precision.
Text- determines how many characters will be stored for each record
Input Mask used to set rules on how data will be entered for a field
Default Value used to automatically set a starting value for a field when a new record is added
to table
Validation Rule/Text work together. Check values when entered into table to make sure they fit a
specific rule.
Required used to make sure that a value is entered into a field when a new record is added
to the table
Primary Key first field in a table used to uniquely identify each of the records
Foreign Key when a field is used to link two tables
Well designed data base Advantages -less costly
-easy to use
-helps ensure data integrity (consistent & accurate)
-avoid data redundancy
