Computer Database Help

[Ste1]

I am building a database of all the computers at the company i work for. Each computer has a unique ID. I want to be able to enter the ID of a computer and have its details displayed. IE. A user enters 34321 and then computer 34321 shows up and has information about its history specification etc.

Where do i start?

 

[mhartman]

Hello:
The first step would be to decide and gather the entities you want to track or display about each computer, for instance, make, model, processor, etc.

Then you need to design your table and forms, queries, and reports.

Regards
Mark

 

[Ste1]

The main entities for the computers will be the system specifications

What i would like to know is how to set up the system so that the number can be entered to find the pc that matches it. What process do i go through?

Thanks

 

[The_Doc_Man]

This forum has an excellent search function. Try the following topics:
Inventory, Normalization, Design (separate topics, not combined)

Pat's advice is on the mark, but perhaps you need another viewpoint.

To build a database that relates to you business, you are building a MODEL of that business. You must identify the entities (perhaps you would prefer OBJECTS) and their properties. Here is an example of the thought process.

If you track PCs, an obvious entity is the PC table. If you also sell parts, you need a Parts table. If you sell pre-packaged software, you need a SWPackage table. If you sell services, you will also need to consider service contracts and work orders, stuff like that. Identify what your business works with.

If you sell things, you need sales orders (sales invoices?). If you buy things, you need purchace orders. These represent transactions to raise or lower your inventory levels.

In other words, imagine your business transacted on paper FIRST. Because there is an "old programmer's rule" that says, "If you can't do it on paper, you won't do it in Access."

 

[mhartman]

Hello

Enclosed is a basic example how to set up a database to track equipment and search for items by an asset or item control number.

This should get you started.

Regards
Mark