does access have the fuctionality to do the following? 1

[projector1]

hi a am using office 2003. I have many excel spreadsheets that contain data such as pc inventory, printer inventory, laptop inventory, software inventory. I also have an excel spreadsheet i designed so that i could log any jobs that come. What this does is allow my manager to see what the workload is like and the status of any open jobs and also closed jobs.

I am now thinking about importing my data into a database that will have a front end that will allow me to do tasks such as record a job that has come in, print off a report of the printers we have that are made my Hp etc.

is this possible in access?

 

[franklin97355]

Yes.

 

[projector1]

as i am familar with the spreadsheets can i create some kind of button that when pressed will import data from the spreadsheet/s and add it to the table in question

also would you know of any good help sites that have examples of this type of situations

 

[franklin97355]

http://mvp.support.microsoft.com/

 

[BudTheGrey]

Yes, you can import Excel data into Access tables. It's really a pretty trvial matter. You can even "link" the Excel sheet to act as a "read-only" datasource, in a limit fashion.

However, I'd recomment that you give thought to saving yourself a great deal of time and trouble, and avoid re-inventing the wheel. Visit this site:

http://www.alloy-software.com/

and evaluate either the Asset management or Network management package.

 

[fneily]

If you're going to use Access, study up on Normalization. A single Excel spreadsheet usually creates three or more Access tables. Spreadsheets and Access tables only look the same, they are not. I run into this problem at every major company I visit.

 

[SimonDavis]

You might also think about importing the current data from the spreadsheets, and in future just using the database - Access is just as capable of gathering the data as Excel is, so why bother using the sheets at all?

That'll probably require a little work on setting up, but it sounds like a pretty straightforward project.