Excel

[silentnick]

Hi guys,

I have been asked to do some work on a database for someone, not entriely sure what at the moment but I think it is mainly organising it better and allowing a search by a variety of methods etc.

I know the basics of excel - and have made simple macros in the past.... are there any resources (web based or books) that would be helpful for me to read? Any tips?

I'm not getting paid for this, but want to give a very very good impression, so hints for formatting etc would be greatly appreciated!

Thanks a lot

[Darryl]

A database? You're getting confused somewhere along the line, if you need to do a database, you're not going to be using Excel, it's a spreadsheet. Which do you actually need help with?

[Charlie_B]

Indeed, for a database you want to be looking at something like MS Access. It's not too hard to learn how to make a useful database with.

[Garrett]

excel for math functions

access for cataloguing and databases.

I have the easiest time manipulating both applications by using the keyword help function and then experimenting from there... but I'm a hands on learner that way.

Anyone of us could send you to a dozen links, but Darryl has said it best when he asked what do you need. Much easier attacking issues than making broad enough generalizations hoping to encompass what you need.

[silentnick]

Ooops, my mistake!

Yes Access I guess would be better... I haven't actually received the data yet, but will be back with more direct questions when I do!

Thank you

[CountZepplin]

Access is weird if you've never played with databases before, though it kind of clicked for me after a few week of programming :P

Queries... learn the different types, how to use them, and get your > < = != things in order. Also, remember true/false boolean variables can be shown as 0 and 1.