Question Don't know where to put this(major help needed)

[Jett]

Hey guys,

I'm new here and actually new to access 2003. I have deal with Vb.net but never access. I actually doing a intern and they want me to build a huge database. All there documents are spread out and all over the place as format of excel. I could just convert them into a access database, but they want all the excel in one huge or whole database. Since the database contain information about people they want to pull up certain person and see what his information is. My question is I believe that can be done, the problem is I'm new and I don't know where to start. I thought of just coding it, but there converting the access database so there no point of coding it. So a lot of explaining to me and a lot of help would be awesome.


Thanks a bunch,
Jett

 

[MSAccessRookie]

Welcome to the Access Forum. Sounds like you could use the same introduction to Access Programming that I used when I started a few months ago. A relatively Basic FREE Online training Service that uses the Northwind Database Model (you'll find out about that later) can be found here:

MS Access 2003 is here http://office.microsoft.com/en-us/training/CR061829401033.aspx
MS Access 2007 is here http://office.microsoft.com/en-us/training/CR101582831033.aspx

Take some time to experience a few of the features that Access has to offer, and if you still need assistance, the forum will be here, and you will be much better prepared with the kinds of questions that you need assistance with.

 

[Len Boorman]

Good advice above.

Access is absolutely not Excel in another wrapper.... as you will soon learn. So take the time to find out and you will save weeks of work.

Len

 

[dsigner1]

You need to define the problem before worrying about the solution.
The input side
1 What entities are they dealing with
2 What data do they have about each entity

The output side
What information do they need to run the business
3 What do they use the Excel to tell them about there business

If you actually manage to sort that out you will have delivered something valuable for them. Once they have signed off that this info is right then you or someone else can actually start to build the Access.

As suggested here you can learn about Access and I bet that turns out to take less time than the analysis. So you could do that as well if you are still on the assignment.

(Sorry about the previous partial post - it ran away from me)

 

[MSAccessRookie]

If you want to delete an errant post, edit it again. One of the command choices is delete the post. WARNING: IF YOU DO THIS TO THE FIRST POST, THE WHOLE THREAD MIGHT GO AWAY!