Mini Case 2 - Access Minicase Purpose: The purpose of this...

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

View Full Document Right Arrow Icon
Access Minicase Purpose: The purpose of this assignment is to recreate this database using Microsoft Access. Excel is often used to create spreadsheets and graphs and is also useful for calculations through formulas which use reverenced cells to automatically calculate an outcome depending on the variables in the cells. On the other hand, an Access database, like many other types of databases, is used to store and organize large amounts of data into tables. The database is essentially a series of linked tables containing their respective data. The database structure reduces redundant data which can be present in large spreadsheets, stores all data in one central location, increases data accuracy, and increases overall efficiency among other things. A database also allows one to query the data to produce detailed reports. A query allows one to determine, for example, “All the students who got B+ or greater in Desc 200 in the Fall 2008 semester” or “What is the best selling book on eBay in July 2009?”. As well as
Background image of page 1

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

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

This note was uploaded on 04/02/2012 for the course DESC 200 taught by Professor Xxx during the Winter '12 term at Concordia University Irvine.

Page1 / 2

Mini Case 2 - Access Minicase Purpose: The purpose of this...

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

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