Best way to create simple database?

[Krassus]

I'm a contractor and need to create a relatively database, which will allow me to enter project names, addresses, architects who designed them, general contracters who are bidding on them and so on. Then i want to be able to search by general contractor and see all projects they've bid on, or by architect and see all projects they've designed. How do i do this? MS Access? Or is there an easier way? I'm completely lost in that thing

 

[GeneralDisarray]

For something like that, Microsoft Excel would be the easiest. If you have it, just open it and take a look, it's fairly intuative.

 

[GasX]

MS Excel

sort by column...

 

[Krassus]

Hmm yeah. Seems a little low-tech though

 

[KeyserSoze]

It might be "low-tech" but why go with anything more complex if you don't need to. And you can always have it export to an Access Database in the future if you think you MIGHT need the functionality of Access. Or you can export in CSV files, and pull it into other data storage programs.



KeyserSoze

 

[Ness]

if you have access already, you might as well pick up a 10-20 dollar book on it from a bookstore and do a database. It sounds to me like you are going to need a system of 2 databases that should be linked, and a spreadsheet wouldn't do that. (1 data base for arc. one for cont., then maybe one for projects)

Excel COULD do the job, but it probably wouldn't be fun to maintain.

If you do decide to pick up a book, I suggest "Shelly Cashman Series Access 2000 Introductory concepts and techniques."



I would send you mine, but I want to hold on to it in case I'm ever in a situation like you
Amazon Used for 4.99

 

[cliftonite]

Originally posted by: Mwilding
MS Excel

sort by column...

 

[MillionaireNextDoor]

Originally posted by: cliftonite

Originally posted by: Mwilding
MS Excel

sort by column...