Access%20-%20CH%201%20and%202

Access%20-%20CH%201%20and%202 - Click to edit Master...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click to edit Master subtitle style 10/15/07 Dr. K. Chen Dr. K. Chen 11 CIS 2640: Business Reporting Book: Access 2007 Data Analysis Chapters 1 and 2 10/15/07 Dr. K. Chen Dr. K. Chen 22 Objectives l A brief introduction to Microsoft Access Tables and Queries l Relational Database l Primary key versus foreign key 10/15/07 Dr. K. Chen Limitations of Excel (1) l Scalability problems Max. 1048576 rows in Excel 2007; Max. 65536 rows in Excel 2003 and older. Excel cant handle big data sets. Large data sets take a long time to load and change in Excel A performance issue Excel (re)loads the entire file to memory l No transparency in analytical processes Too many cryptic formulas makes it difficult to understand (especially other peoples work) Dr. K. Chen 33 10/15/07 Dr. K. Chen Limitations of Excel (2) l Data are tied to presentation Formatting has to be done individually for data items Each cell has the potential of holding formulas, being hidden and containing links to other cells l Duplicate data in multiple worksheets are difficult to manage l Searching across worksheets and workbooks is clumsy Dr. K. Chen 44 10/15/07 Dr. K. Chen Deciding whether to use Access or Excel (1) l Size of data Excel loads the whole data file into RAM at once; Access loads only a portion of data into RAM Rows > 100000 & Access l Data structure Tables that bear some relationships with each other & Access Tables with no relationships & Excel Dr. K. Chen 55 10/15/07 Dr. K. Chen Deciding whether to use Access or Excel (2) l Suppose you would like to store information about customers and orders they have placed. Excel l Both Customers and Orders are stored in one worksheet. Problems? l Customers in one worksheet and Orders in another. Problems? Access l Customers in one table, Orders in another table, relationship is built by joining (or connecting) Dr. K. Chen 66 10/15/07 Dr. K. Chen Deciding whether to use Access or Excel (3) l Data Evolution Soon your business data will exceeds the capacity of Excel l Functional complexity MS Access allows for complex, multiple-step analytical processes l Shared Processing MS Access allows multiple people to access the...
View Full Document

This note was uploaded on 12/10/2008 for the course CIS 2640 taught by Professor Chen during the Fall '08 term at Western Michigan.

Page1 / 37

Access%20-%20CH%201%20and%202 - Click to edit Master...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online