PLEASE HELP - NEW USER

  • Thread starter Thread starter Ethan
  • Start date Start date
E

Ethan

I am looking for help and ideas. I am building an
inventory database for salvaged vehicles and parts as well
as our cost, asking price, where we got it, and what we
did with it...all in all, I have 22 columns for each
item. Right now I have one big table with an alphanumeric
non- repeating series of inventory numbers (A100, A101,
A102...) as the primary key.

Ok...so now my questions.

1. I am trying to build a parameter query to pull up a
list of non-sequential inventory numbers, and it will not
work. Is a parameter query the best way? How do I get it
to work?

2. How do I put the pictures of the items in the table?

3. Can I make these into separate tables that are all
related by the inventory number as the primary key?

4. I also am attempting to create a Query that returns
records that have a yes in a yes/no field, is there a
quick reference cheat sheet for all of the expressions and
operators that can be used as criteria?

5. Any other advice is welcome.

Any help at all would be greatly appreciated

Thanks,

Ethan
 
Ethan said:
I am looking for help and ideas. I am building an
inventory database for salvaged vehicles and parts as well
as our cost, asking price, where we got it, and what we
did with it...all in all, I have 22 columns for each
item. Right now I have one big table with an alphanumeric
non- repeating series of inventory numbers (A100, A101,
A102...) as the primary key.

Ok...so now my questions.

1. I am trying to build a parameter query to pull up a
list of non-sequential inventory numbers, and it will not
work. Is a parameter query the best way? How do I get it
to work?
Click to expand...
What determines which parts to pull up?
2. How do I put the pictures of the items in the table?
Click to expand...
Not a good idea in Access, rather put links to where the pictures reside
outside of the database. If you have to put them in, put the data type as
OLE object.
3. Can I make these into separate tables that are all
related by the inventory number as the primary key?
Click to expand...
You can, but should only do so if they are really different things. If you
could post the layout of the table it would be easier to see what should be
split off. For instance if you keep the manufacturers name in the parts
table there should possibly be a separate table of manufacturer

Table manufacturer - manufacturer id, manufacturer name, all related
manufacturer info

Table parts - part id, manufacturer id, other part relevant information.
4. I also am attempting to create a Query that returns
records that have a yes in a yes/no field, is there a
quick reference cheat sheet for all of the expressions and
operators that can be used as criteria?
Click to expand...
The 'trick' with boolean is that you have to test for false/true -1/0 rather
than yes/no. Search in help for 'query criteria example'
5. Any other advice is welcome.

Any help at all would be greatly appreciated

Thanks,

Ethan
Click to expand...

Go through the NWind example database as and when time allows it shows most
of the basics.
HTH
Marc
 
Point 5: If you have 1 big Table, it is almost certain
that the Table structure is incorrect. To get the most
out of Access, you need to use the "relational" capability
of Access. This will generally require a number of
different Tables which are linked using the relational
capability of Access (and all other relational database
engine).

Suggest you check out the Relational Database Design
Theory first and re-design your Table Structure
accordingly.

Once your have the correct Table structure, other things
will follow nicely since Access is designed to work
effciently with databases that have proper relational
structure.

HTH
Van T. Dinh
MVP (Access)
 
Ethan,

If you would like some help with your database, contact me at the email address
below.
 
Marc,

I appreciate your posted suggestions. You said if you
could see the table structure it would help with making a
recommendation to me. So, hope do I post it?

The inventory numbers to pull up are determined by me,
just whatever I might need. Certain inventory numbers, or
inventory numbers with a specific type of engine,
transmission, or rear end.this does make sense right, I'm
not just babbling?

Just to clarify something you said, -1/0 is the same as
yes/no? So I can search for -1 and get all my yes's?
Assess is pretty cool.

Thanks so much for replying to my posting and I hope I am
not inconveniencing you by asking for more help.
 
hi,
Not at all, when work allows.
Marc,

I appreciate your posted suggestions. You said if you
could see the table structure it would help with making a
recommendation to me. So, hope do I post it?

The inventory numbers to pull up are determined by me,
just whatever I might need. Certain inventory numbers, or
inventory numbers with a specific type of engine,
transmission, or rear end.this does make sense right, I'm
not just babbling?
Click to expand...
It sounds like you need a category code with the inventory - is it possible
to place each 'set' of inventory parts into a category. A really complex
app, which I don't know that this app necessarily needs, might require the
ability to cross-section data.

So if you have category code - engine parts, transmission parts, fuel parts,
etc and then also have manufacturers a form can first ask for which
manufacturer and then which category - and the subform/new form return all
matching records.

If you look in the NWind demo db, the food is in categories and suppliers -
similar idea.
Just to clarify something you said, -1/0 is the same as
yes/no? So I can search for -1 and get all my yes's? Yup.
Access is pretty cool.
Click to expand...
It has its limitations but for small apps it does a lot.HTH
Marc
 
Back
Top