ACCESS FEED: RE: [MS_AccessPros] New with a Q

Rabu, 24 April 2013

RE: [MS_AccessPros] New with a Q

Dan & Deana-

Access is perfect for this. But first, you need to learn a bit about
designing Relational databases. Ideally, you would have a Materials table
that lists the item number, description, and price. In your work order
table, you would create a "foreign key" on Item Number that points to the
Materials table. In a form, you would use a combo box to pull rows from the
Materials table and set the Item Number in the work order items table when
an item is selected. You could use the After Update event of the combo box
to grab the current price if necessary.

Take a look at the Northwind sample database in Access 97. Specifically,
look at Orders and Order Details. In the Orders form, there's a subform
that saves rows to Order Details, and it has a combo box that pulls product
ID from the Products table. When you select a Product, it copies the
current price to the Order Details row.

Hope that gets you started.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dan Davis
Sent: Wednesday, April 24, 2013 8:28 PM
To: Access Group
Subject: [MS_AccessPros] New with a Q

I joined my husband(Dan) and I(Deana) to this group looking to see if Access
can do what Dan is wanting it to do.

Here's my Q:
Dan draws house plans in his spare time, and when he types up material lists
for his customers he's having to type out the descriptions for each item
over and over.
Is Access a good program for listing many individual construction item
descrictions/ item #s / prices / quantity /

and with that standard list, then enter quantities that can be printed off
in a list form... and ONLY printing off the list of those with quantities
and not every item in the material list?

I hope I'm explaining this well enough. Access may be an over kill for this
type of project. We have Access 97 and Excell. We don't know enough about
either to develop this on our own. So I'm reaching out for help here. I'm
use to working in Yahoo Groups and am getting Dan warmed up to the idea.

I'd appreciate any info or advice for this. Thank you! Dan and Deana

[Non-text portions of this message have been removed]