Re: How do I create an Excel database?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It can be argued that the proper place for a database is database management
software like Access but I use Excel extensively for this purpose and, at
least for me, it works well.

If you think of the old record cards, all the information on the card is a
record. Each piece of information on the card is a field.

On a spreadsheet each row is a record and each column holds a piece of
information so is a field.

It is important to design a spreadsheet not just type everything in. By
design I mean stop, have a cup of tea and think about what is wanted. This
cane be defined as input (data to be put in) and output (what you want to do
with the date - including pivot tables charts etc.) What you are doing is
the middle bit and now you can appreciate that if you don't get all three
elements designed properly you'll be foerever tampering with it to get it
right.

On the input side I would recommend that you split data as much as possible.
For a person's name you will need a field each for "Miss/Mr/Mrs/Ms", First
name, Initial, Family name. For the address you will need a field for
"Building", "DP1" (Distribution point1 - House number), "DP2" (Distribution
point2 - Road), "Dependent locality" (locale), "PostTown", "Postcode". It
is easy to bundle information together but this approach ensures that you
don't have to unbundle it when trying to analyse date. The rest of the
field are up to you but bear in mind my comment on splitting data.

On the output side I can't comment as I don't know the purpose to which data
is being put.

Hope this helps.
Regards.

Bill Ridgeway
Computer Solutions

"Kenn Holmberg" <Kenn Holmberg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5208F078-B149-44D4-B536-17E290C7FC38@xxxxxxxxxxxxxxxx
>I am a new user, and am required to create an Excel database. Any hints
>would
> be helpful. The online documents are not clear. Also, where is the "Field
> button" ?I am using 2003 Standard Edition.


.

Relevant Pages

  • Re: O/R Mapper
    ... > as OO design is not just about data in isolation. ... the proper tooling/methods are used which fit with the approach chosen. ... >> of the reality to come to the proper result. ... > constraints into a database where they do not exist in the object ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Open source alternative for MsAccess?
    ... These are not RAD database application development systems that can ... The design reflects the purpose of the product. ... VB is not VBA and VBA is not VBA as used in Access. ...
    (comp.os.linux.development.apps)
  • Re: How do I create an address book in excel?
    ... It can be argued that the proper place for a database is database management ... It is important to design a spreadsheet not just type everything in. ... On the output side I can't comment as I don't know the purpose to which data ...
    (microsoft.public.excel.newusers)
  • Re: How do I create an Excel database?
    ... > It can be argued that the proper place for a database is database ... Each piece of information on the card is a field. ... > design I mean stop, have a cup of tea and think about what is wanted. ...
    (microsoft.public.excel.newusers)
  • Proper database design input needed
    ... I have a question about proper table design. ... the CustNum for a reference back to the customer and call it good. ... This would require me to change the database structure to add the ...
    (microsoft.public.access.tablesdbdesign)