ISTM 210 Final Exam Newest 2025 Complete 200 Actual Exam Question
and 100% Correct Verified Answers/ Graded A+
1. A database maintained infor- object - inventory or items
mation about various types Events - sales that take place
People - customers, suppliers, employees
Places - location of business
2. Is allowing multiple users on Allows multiple users is good, but also bad
access good because people can delete, make mistakes,
change information, overwhelming
3. What are the Microsoft Ac- Not made for MacBooks
cess disadvantages
4. What are the five primary 1. database structure - create tables, fields,
functions of a database man- relationships
agement system? 2. Easy to add and change data.
3. You can query data.
4. Build in a report and present.
5. Create a form.
6. Lock database.
5. what is the navigation pane? Allows to view an access all your things made
6. What are the Microsoft ac- used by small medium business
cess advantages? Security - can lock it
Organization
Tablet friendly
Easy to install
Import data
Validation rules
Redundancy
One or more users can access it
7. What are the four types of tables, queries, forms, and reports
objects in access
8. What is another name for a entity
table
9. what does a table/entity con-
tain?
, ISTM 210 Final Exam Newest 2025
consists of rows that record data and sepa-
rated by fields
characteristic of a table
10. How are tables/entities linked by characteristic relationships b/w the
linked? two
11. Tables can be created in Datasheet View or
Design View.
12. What is datasheet view? the front side. shows content must be in this
to delete
13. what is design view? The backside
Modify
Add more fields
Sort
Set up criteria
14. What is a field/attribute? A single column in a table could be for name,
phone number, or address
15. What are the different data short text
types Long text
Number
Date/time
currency
auto number
Yes,/no
Hyperlink
Attachment
Look up
Calculation
16. What are the different types 1. simple vs composite
of attributes? 2. single vs multivalue
3. stored vs derived
4. null
17. stored vs derived
, ISTM 210 Final Exam Newest 2025
stored - like todays date 11/7/24
derived - calculations takes birthday and
finds age
18. single vs multivalue single - only have one (social security or UIN)
multivalue - have more than one (email ad-
dress, classes you take, books, pets)
19. null zero
does not have anything
not everyone has a car or phone
20. what is a record A row that collects data information
A unit of information in a table collection of
data elements
*do not want any redundant records
21. What is an input mask? text size
Shows how you want it to look
Set up how you want it formatted
22. What is the field descrip- optional
tion? Should describe what your field name means
23. What is the validation allows you to make sure criteria is met after
rule/validation text your rule
Allows you to create specific fields
24. What is the default value? automatically starts at a record
Can start at 10 or 11
Always starts at one
Try to use something very detailed
25. What is required? Required field has to be filled in
26. What is a form? used for entering, modifying, viewing
records, the title has to be meaningful, and
has to have good spelling and grammar
27.
and 100% Correct Verified Answers/ Graded A+
1. A database maintained infor- object - inventory or items
mation about various types Events - sales that take place
People - customers, suppliers, employees
Places - location of business
2. Is allowing multiple users on Allows multiple users is good, but also bad
access good because people can delete, make mistakes,
change information, overwhelming
3. What are the Microsoft Ac- Not made for MacBooks
cess disadvantages
4. What are the five primary 1. database structure - create tables, fields,
functions of a database man- relationships
agement system? 2. Easy to add and change data.
3. You can query data.
4. Build in a report and present.
5. Create a form.
6. Lock database.
5. what is the navigation pane? Allows to view an access all your things made
6. What are the Microsoft ac- used by small medium business
cess advantages? Security - can lock it
Organization
Tablet friendly
Easy to install
Import data
Validation rules
Redundancy
One or more users can access it
7. What are the four types of tables, queries, forms, and reports
objects in access
8. What is another name for a entity
table
9. what does a table/entity con-
tain?
, ISTM 210 Final Exam Newest 2025
consists of rows that record data and sepa-
rated by fields
characteristic of a table
10. How are tables/entities linked by characteristic relationships b/w the
linked? two
11. Tables can be created in Datasheet View or
Design View.
12. What is datasheet view? the front side. shows content must be in this
to delete
13. what is design view? The backside
Modify
Add more fields
Sort
Set up criteria
14. What is a field/attribute? A single column in a table could be for name,
phone number, or address
15. What are the different data short text
types Long text
Number
Date/time
currency
auto number
Yes,/no
Hyperlink
Attachment
Look up
Calculation
16. What are the different types 1. simple vs composite
of attributes? 2. single vs multivalue
3. stored vs derived
4. null
17. stored vs derived
, ISTM 210 Final Exam Newest 2025
stored - like todays date 11/7/24
derived - calculations takes birthday and
finds age
18. single vs multivalue single - only have one (social security or UIN)
multivalue - have more than one (email ad-
dress, classes you take, books, pets)
19. null zero
does not have anything
not everyone has a car or phone
20. what is a record A row that collects data information
A unit of information in a table collection of
data elements
*do not want any redundant records
21. What is an input mask? text size
Shows how you want it to look
Set up how you want it formatted
22. What is the field descrip- optional
tion? Should describe what your field name means
23. What is the validation allows you to make sure criteria is met after
rule/validation text your rule
Allows you to create specific fields
24. What is the default value? automatically starts at a record
Can start at 10 or 11
Always starts at one
Try to use something very detailed
25. What is required? Required field has to be filled in
26. What is a form? used for entering, modifying, viewing
records, the title has to be meaningful, and
has to have good spelling and grammar
27.
