I need complete idiot proof excel setup database help. please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MadMoose - 12 Apr 2006 19:47 GMT

I need to learn all about Excel and how to make a database.. I have read
and read and done practise tutorials but I just cannot grasp the concept, it
completely goes over my head everytime. I am quick to learn when I am being
shown or told exactly what to do, can anyone help me learn all about Excel.. ?

Reply to this Message

JE McGimpsey - 12 Apr 2006 20:49 GMT

The first thing you need to know is that Excel is not a database
application, and while it is commonly used for databases, it doesn't do
them well. Expecting a database developed in XL to be "complete idiot
proof" is setting yourself up for disaster.

Without knowing anything about your data or your reporting needs, the
only thing I could tell you is that, in general, you should use rows for
records and columns for fields within recocords.

> I need to learn all about Excel and how to make a database.. I have read
> and read and done practise tutorials but I just cannot grasp the concept, it
> completely goes over my head everytime. I am quick to learn when I am being
> shown or told exactly what to do, can anyone help me learn all about Excel.. ?

Reply to this Message

Ron de Bruin - 12 Apr 2006 20:55 GMT

Here is a example
http://www.rondebruin.nl/copy1.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> The first thing you need to know is that Excel is not a database
> application, and while it is commonly used for databases, it doesn't do
[quoted text clipped - 9 lines]
>> completely goes over my head everytime. I am quick to learn when I am being
>> shown or told exactly what to do, can anyone help me learn all about Excel.. ?

Reply to this Message

MadMoose - 13 Apr 2006 04:26 GMT

Thanks for your help Ron de Bruin.. I have just started a job and I have
never used excel, access or anything like it before in my life, apparently
Access is my next task.. Yet my boss wants me to go figure everything on my
own or pester some newsgroups, so here I am.. lol. I managed to get a
database done.. there is just so much to remember and try and grasp with
excel..:-)
Hopefully it will all get easier with time.

> Here is a example
> http://www.rondebruin.nl/copy1.htm
[quoted text clipped - 12 lines]
> >> completely goes over my head everytime. I am quick to learn when I am being
> >> shown or told exactly what to do, can anyone help me learn all about Excel.. ?

Reply to this Message

Patricia Shannon - 13 Apr 2006 13:54 GMT

As you use it, it will become more clear. If you are doing macro
programming, liberal use of MsgBox is very helpful. Using MsgBox with
TypeName can be useful. When I started programming (in 1970, in IBM Assembler
Language), computer concepts seemed pretty murky. But I became an excellent
programmer (not just my own opinion). Now I am learning Visual Basic macros,
and finding the same thing applies for areas that are different from what
I've worked with before. Our brains actually grow new cells, and make new
connections when we learn new things, thoughout our lives. It sounds like
you are willing to learn, and are making new brain connections!

> Thanks for your help Ron de Bruin.. I have just started a job and I have
> never used excel, access or anything like it before in my life, apparently
[quoted text clipped - 20 lines]
> > >> completely goes over my head everytime. I am quick to learn when I am being
> > >> shown or told exactly what to do, can anyone help me learn all about Excel.. ?

Reply to this Message

MadMoose - 13 Apr 2006 04:20 GMT

Thanks for your reply McGimpsey.. My next task is Access apparently.. I think
I might send your reply to my boss.. because I don't think it makes a very
good database either. Hence why I have struggled with it.. setting myself up
for disaster sounds about right too.. lol..

> The first thing you need to know is that Excel is not a database
> application, and while it is commonly used for databases, it doesn't do
[quoted text clipped - 9 lines]
> > completely goes over my head everytime. I am quick to learn when I am being
> > shown or told exactly what to do, can anyone help me learn all about Excel.. ?

Reply to this Message

CLR - 13 Apr 2006 15:32 GMT

Goto thise sites, and others, and read and practice, practice, practice.
Also, read the newsgroups and try to come up with the answers yourself before
you read the responses,...........

www.mcgimpsey.com/excel/index.html
www.cpearson.com
www.mvps.org/dmcritchie/excel/excel.htm

hth
Vaya con Dios,
Chuck, CABGx3

Reply to this Message