Databases and spreadsheets

What is a database?

The basic electronic information storage unit

A database is a collection of information organized to provide efficient retrieval. The collected information could be in any number of formats (electronic, printed, graphic, audio, statistical, combinations). There are physical (paper/print) and electronic databases.

A database could be as simple as an alphabetical arrangement of names in an address book or as complex as a database that provides information in a combination of formats.

How can we create a database in Microsoft Access? 

Before you create a database

Before you create an Access database, you must answer the following questions:

• What is the purpose of this database and who will use it?
• What tables (data) will this database contain?
• What queries and reports do the users of this database need?
• What forms do you need to create?

Answering the above questions will lead you to a good database design, and help you create a database that is useful and usable.

You can click on this link to look a video tutorial of databases in M. Access. 

http://www.youtube.com/watch?v=v2R3x9NWOD0

What is a Spreadsheet?

A spreadsheet is a grid that organizes data into columns and rows. Spreadsheets make it easy to display information, and people can insert formulas to work with the data. For example, there is a particular icon that has a formula to sum up numbers that are given. This icon is called auto sum.  Information can also be sorted and filtered.
    People use spreadsheet programs to learn about different kinds of things, and to make decisions. Spreadsheets are based on different varieties of subjects. This site will highlight the use of spreadsheets in the classroom.  You will find ideas for every subject.  On this website, we will be using Microsoft Excel.