ISTM 210 - Final Exam Latest 2024 -2025 Complete 250 Actual Question
with Correct Detailed Answers (Verified Answers) Graded A+
1. What consists of exter- Thumb drive
nal hard drive? -CON: If lose, the data is gone
-PRO: Saves data
2. When creating a data- - Needs to be accurate (real-time) (save as .ac-
base what are some cdb) (.laccdb means locked)
things you need to think - security & privacy
about? - what type of information will you collect? (First
name, last name, addresses, cc info?)
- keep details of when you sell stuff
- needs to be accurate
- updated in real time to keep track of supplies
3. What is DBMS? What -Database Management System
will it allow you to do? - Allows you to create different types of tables,
reports, queries, & forms
- allows you to manipulate & control data
- helps prevent redundant info (cause businesses
to lose money)
- placed on network (everyone uses)
4. What is a database? - collection of data for business use
- need to know business to know what info needs
to be included in database
- file cabinets & files
5. What do databases al- Enter, access info, and analyze data
low you to do?
6. Database maintains info -Objects: inventory
about various types: -events: transactions or sales take place
-people: customers, suppliers, employees
-places: location of purchase & sales
7. DBMS allows for many -add
decisions and options -modify
when creating: -update
-delete
8.
, ISTM 210 - Final Exam Latest 2024 -2025
While allowing the user -control access
to: - lock down security
- maintain data
- controls data
9. Microsoft Access Ad- -security
vantages (used by small -organization
businesses) -tablet friendly
-easy to install
-import data from excel or other software
-allows you to create validation rules
-redundancy
-more than one user that can access it at a time
10. Microsoft Access disad- -Mac can't use
vantages -multiple users can delete or change info
-can be overwhelming for new users
11. 5 primary functions of a • Database structure
DBMS? -create tables & within those fields you create
relationships among different tables
-easy to add new records and change field values
-delete records
-allows you to querie the data
-has a built in report
-allows you to create forms
-protects data
12. What is backstage view? Allows you to print & save and has options
13. Navigation pane? Allows you to view & access all of your database
objects
-forms or tables is already default into the naviga-
tion pane when creating them
14. What is the best way to -always pull from data
name your objects? -put initials in front of name to create tables
-what your boss wants
, ISTM 210 - Final Exam Latest 2024 -2025
15. Another name for a Entity
table?
16. Table entity? Person, place, & thing, transaction, & event (noun)
17. What does a table con- -consists of rows that records the data & separat-
tain? ed by columns (fields)
-field: characteristic of the data in the table!
18. How are they linked? Creating relationships between the two tables
19. Data sheet view? Front side where you see all info and data
20. Design view? Backside that allows you to modify data and add
more fields and sort (setup criteria basically)
21. Field/attribute? Data types you can use for different types
- know data types!
22. Types of attributes? -short text
-long text
-number
-date/time
-currency
23. Short text (non calculat- -Used to store most data that won't be treated like
ed numbers) a number such as text, telephone numbers, and
zip codes.
-this type is limited to 255 characters and can be
any combination of numbers, letters and symbols
24. Long text -used to store larger amounts of text
-this type is limited to 65,536 characters and can
contain any combo of letters, numbers and sym-
bols
25. Number
with Correct Detailed Answers (Verified Answers) Graded A+
1. What consists of exter- Thumb drive
nal hard drive? -CON: If lose, the data is gone
-PRO: Saves data
2. When creating a data- - Needs to be accurate (real-time) (save as .ac-
base what are some cdb) (.laccdb means locked)
things you need to think - security & privacy
about? - what type of information will you collect? (First
name, last name, addresses, cc info?)
- keep details of when you sell stuff
- needs to be accurate
- updated in real time to keep track of supplies
3. What is DBMS? What -Database Management System
will it allow you to do? - Allows you to create different types of tables,
reports, queries, & forms
- allows you to manipulate & control data
- helps prevent redundant info (cause businesses
to lose money)
- placed on network (everyone uses)
4. What is a database? - collection of data for business use
- need to know business to know what info needs
to be included in database
- file cabinets & files
5. What do databases al- Enter, access info, and analyze data
low you to do?
6. Database maintains info -Objects: inventory
about various types: -events: transactions or sales take place
-people: customers, suppliers, employees
-places: location of purchase & sales
7. DBMS allows for many -add
decisions and options -modify
when creating: -update
-delete
8.
, ISTM 210 - Final Exam Latest 2024 -2025
While allowing the user -control access
to: - lock down security
- maintain data
- controls data
9. Microsoft Access Ad- -security
vantages (used by small -organization
businesses) -tablet friendly
-easy to install
-import data from excel or other software
-allows you to create validation rules
-redundancy
-more than one user that can access it at a time
10. Microsoft Access disad- -Mac can't use
vantages -multiple users can delete or change info
-can be overwhelming for new users
11. 5 primary functions of a • Database structure
DBMS? -create tables & within those fields you create
relationships among different tables
-easy to add new records and change field values
-delete records
-allows you to querie the data
-has a built in report
-allows you to create forms
-protects data
12. What is backstage view? Allows you to print & save and has options
13. Navigation pane? Allows you to view & access all of your database
objects
-forms or tables is already default into the naviga-
tion pane when creating them
14. What is the best way to -always pull from data
name your objects? -put initials in front of name to create tables
-what your boss wants
, ISTM 210 - Final Exam Latest 2024 -2025
15. Another name for a Entity
table?
16. Table entity? Person, place, & thing, transaction, & event (noun)
17. What does a table con- -consists of rows that records the data & separat-
tain? ed by columns (fields)
-field: characteristic of the data in the table!
18. How are they linked? Creating relationships between the two tables
19. Data sheet view? Front side where you see all info and data
20. Design view? Backside that allows you to modify data and add
more fields and sort (setup criteria basically)
21. Field/attribute? Data types you can use for different types
- know data types!
22. Types of attributes? -short text
-long text
-number
-date/time
-currency
23. Short text (non calculat- -Used to store most data that won't be treated like
ed numbers) a number such as text, telephone numbers, and
zip codes.
-this type is limited to 255 characters and can be
any combination of numbers, letters and symbols
24. Long text -used to store larger amounts of text
-this type is limited to 65,536 characters and can
contain any combo of letters, numbers and sym-
bols
25. Number
