ISTM 210 Exam 3 2025/2026 Exam
Questions and Verified Answers |
Already Graded A+
Quick Stove - 🧠 ANSWER ✔✔small co. that sells emergency preparedness
and backpack equipment. Location: Orem, Utah
Navigation Pane - 🧠 ANSWER ✔✔provides way for user to interact
w/various objects in database files
Types of Objects - 🧠 ANSWER ✔✔Tables
Queries
Forms
Reports
Tables - 🧠 ANSWER ✔✔used to store data in access. Columns- store data
fields
,rows- store database records. Most important
Queries - 🧠 ANSWER ✔✔used to find specific data you need from a
database. Does not give a copy of data, rather a diff view
Forms - 🧠 ANSWER ✔✔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 - 🧠 ANSWER ✔✔allow you to organize and present data. Aids in
managerial decision making. Generates from tables or queries.
Views - 🧠 ANSWER ✔✔different ways to look at an object
Access is a - 🧠 ANSWER ✔✔relational database
Naming fields should be - 🧠 ANSWER ✔✔meaningful and descriptive-
spaces not recommended, no special characters
Short Text - 🧠 ANSWER ✔✔store data that won't be treated like a number
for calculations. Ex. Phone #'s and zip codes. limited to 255 characters
Long Text - 🧠 ANSWER ✔✔stores large amts. of text. Limited to 65,536
characters.
, Number - 🧠 ANSWER ✔✔stores + and - #'s. Can contain decimal. Used for
calculations
Date/Time - 🧠 ANSWER ✔✔store date or time info. Can be formatted to
display in several diff ways.
Currency - 🧠 ANSWER ✔✔number data type that places $ symbol in front
Autonumber - 🧠 ANSWER ✔✔automatically insert value for autonumber
field when a new record is added to a table
Yes/no - 🧠 ANSWER ✔✔store data with only 2 possible values. T/F,
On/Off, Yes/No
OLE object - 🧠 ANSWER ✔✔used to store files created by other programs
like Word, Excel, etc.
Hyperlink - 🧠 ANSWER ✔✔used to store links to websites or other
folders/files on your computer
Attachment - 🧠 ANSWER ✔✔store files for database record. Can be any
type of file including pics, sound, and videos
Calculated - 🧠 ANSWER ✔✔used to create a field that is generated by a
formula. Refer to values in other fields for a record
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
3
Questions and Verified Answers |
Already Graded A+
Quick Stove - 🧠 ANSWER ✔✔small co. that sells emergency preparedness
and backpack equipment. Location: Orem, Utah
Navigation Pane - 🧠 ANSWER ✔✔provides way for user to interact
w/various objects in database files
Types of Objects - 🧠 ANSWER ✔✔Tables
Queries
Forms
Reports
Tables - 🧠 ANSWER ✔✔used to store data in access. Columns- store data
fields
,rows- store database records. Most important
Queries - 🧠 ANSWER ✔✔used to find specific data you need from a
database. Does not give a copy of data, rather a diff view
Forms - 🧠 ANSWER ✔✔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 - 🧠 ANSWER ✔✔allow you to organize and present data. Aids in
managerial decision making. Generates from tables or queries.
Views - 🧠 ANSWER ✔✔different ways to look at an object
Access is a - 🧠 ANSWER ✔✔relational database
Naming fields should be - 🧠 ANSWER ✔✔meaningful and descriptive-
spaces not recommended, no special characters
Short Text - 🧠 ANSWER ✔✔store data that won't be treated like a number
for calculations. Ex. Phone #'s and zip codes. limited to 255 characters
Long Text - 🧠 ANSWER ✔✔stores large amts. of text. Limited to 65,536
characters.
, Number - 🧠 ANSWER ✔✔stores + and - #'s. Can contain decimal. Used for
calculations
Date/Time - 🧠 ANSWER ✔✔store date or time info. Can be formatted to
display in several diff ways.
Currency - 🧠 ANSWER ✔✔number data type that places $ symbol in front
Autonumber - 🧠 ANSWER ✔✔automatically insert value for autonumber
field when a new record is added to a table
Yes/no - 🧠 ANSWER ✔✔store data with only 2 possible values. T/F,
On/Off, Yes/No
OLE object - 🧠 ANSWER ✔✔used to store files created by other programs
like Word, Excel, etc.
Hyperlink - 🧠 ANSWER ✔✔used to store links to websites or other
folders/files on your computer
Attachment - 🧠 ANSWER ✔✔store files for database record. Can be any
type of file including pics, sound, and videos
Calculated - 🧠 ANSWER ✔✔used to create a field that is generated by a
formula. Refer to values in other fields for a record
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
3
