ISTM 210 Exam 3 [2026/2027] | UPDATED ACTUAL
Exam Question and Answer | A+ Verified
• 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
• Normalization -✓✓ process of organizing tables and relationships in a database
Exam Question and Answer | A+ Verified
• 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
• Normalization -✓✓ process of organizing tables and relationships in a database
