Summary
Summary k201 lecture notes
- Course
- BUS-K 201
- Institution
- Indiana University
in class lecture notes for k201 at IU
[Show more]
Seller
Follow
Content preview
CHAPTER 2–Access IntroductionObjectives:
1. Research terms using the define: operator
2. Understand relational database objects and concepts
3. Understand the structure of the Premiere database
4. Understand how to locate data in tables
Flat file and relational databases
Database–an organized collection of structured information (data), typically stored in an
electronic computer system
- Collection of data organized into files called tables
Relational database–contains multiple tables that relate to each other through special
key fields
Flat file database–contain single table of data
- Relational databases more flexible than flat file
- Flat file creates more work as the same information must be stored under one
table
- Duplicate data will create inconsistencies
- If one part of the information must be changed, the entire table must
change
Using Access or Excel to manage your data
, Use Access:
- Have to track & record data regularly and display/export/print subsets of that data
- Anticipate several people working in a database
- Anticipate needing to add more tables to a data set
- Want to run complex queries
- Want to produce a variety of reports
- Examples:
- Managing contacts
- Inventory & asset tracking
- Order tracking
- Task tracking
- Organizing lending libraries
- Event planning
- Nutrition tracking
Use Excel:
- Optimized for data analysis & calculation
- Build models for analyzing data & writing formulas
- Require a flat or non relational view of data, when data is mostly numeric
- Want to frequently run calculations and statistical comparisons
- Want to use PivotTable reports to view hierarchical data
- Plan to create charts regularly
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 gabbyh123. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53340 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now