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
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TestPrepPros. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.82. You're not tied to anything after your purchase.
