computer

  • Thread starter Thread starter darlene handy
  • Start date Start date
What type of data do you want to put in your database. The program you can
use is Microsoft access.
 
microsoft data base
Brian Prior said:
What type of data do you want to put in your database. The program you can
use is Microsoft access.


microsoft dat
Click to expand...
 
Darlene

An alternative to Microsoft Access is Microsoft Excel. Do you have
either?


--


Hope this helps.

Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~
 
Gerry said:
Darlene

An alternative to Microsoft Access is Microsoft Excel. Do you have either?
Click to expand...


Er.... Excel is a spreadsheet application, designed for crunching
numbers and financial data. It's not even close to being a database
application.


--

Bruce Chambers

Help us help you:


http://support.microsoft.com/default.aspx/kb/555375

They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety. ~Benjamin Franklin

Many people would rather die than think; in fact, most do. ~Bertrand Russell

The philosopher has never killed any priests, whereas the priest has
killed a great many philosophers.
~ Denis Diderot
 
Gerry said:
Bruce

Please reconsider your statement. It may not be as sophisticated as
Microsoft Access but it is a database application.
Click to expand...


It takes a lot more than pivot tables to make a database. Excel
doesn't come close to even the long defunct DataStar or dBase3 in terms
of database capabilities.



--

Bruce Chambers

Help us help you:


http://support.microsoft.com/default.aspx/kb/555375

They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety. ~Benjamin Franklin

Many people would rather die than think; in fact, most do. ~Bertrand Russell

The philosopher has never killed any priests, whereas the priest has
killed a great many philosophers.
~ Denis Diderot
 
Bruce

So you concede that Excel is a database?


--


Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~
 
I guess that raises the question as to whether or not a spreadsheet (like
Excel) is a database or not. In some sense, it sure can be seen that way:
i.e, as a "database" of numeric data. But I don't think that's the most
conventional use of the term "database" (for a program).
 
I guess that raises the question as to whether or not a spreadsheet (like
Excel) is a database or not. In some sense, it sure can be seen that way:
i.e, as a "database" of numeric data. But I don't think that's the most
conventional use of the term "database" (for a program).
Click to expand...

Database: A collection of related electronic records in a standardized
format, searchable in a variety of ways, such as title, author, subject,
and keyword. ...

A spreadsheet, if it were organized with consistent columns of data of
the same type in a column, of a specific nature, allowing searching and
indexing, would be technically considered a database.

As an example, if you have a mailing list that contains both active and
inactive contacts, each column represents a specific type of data, you
could consider that a database.

If the columns contain different types of data, such as a mix of non
related information vertically, instead of only related data, this
dissimilar data per column would invalidate it as a database.

So, if a column had say:
RED
GREEN
BLUE
ORANGE
YELLOW
....

As long as it was only colors, it would could be considere a database.

If the same column was mixed with:
Red
12/1/2001
TIRE
=50*C$1$

Then the sheet would not be a database.
 
Back
Top