ACCESS FEED: RE: [MS_AccessPros] Building an Access Database similar to this.

Rabu, 29 Juni 2011

RE: [MS_AccessPros] Building an Access Database similar to this.

Deb-

You certainly can build an Inventory and/or Sales management database
application using Access. Have you looked at the sample Northwind application
that comes with Access? Which version of Access do you have?

I built a fully-functional Sales and Inventory management app that comes with my
"Building" book. It was built using Access 2002, but it should run just fine in
any later version. The sample database is fully costumizable to suit your
needs, but be forewarned that it is fairly complex.

Amazon has the book for about $32 that comes with four sample databases and
sections that describe the design and workings of each. Or, you can just
download the sample from:

ftp://ftp.viescas.com/Download/Inventory.zip

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

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Deb
Sent: Thursday, June 30, 2011 3:38 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Building an Access Database similar to this.

Hi all,

I need to build a database for our biz. I had been looking at the following
program that does inventory management.

Video on how it works:

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

Manual
http://www.beading-software.com/jewelry-software-support/bead-manager-pro-suppor
t-manual/

My understanding is that this program was built in FileMaker Pro.

The reason I'm not buying it is that our Biz has 3 branches - jewelry
making, photography, and woodworking. The program is not customizable, so
the fields cannot be changed to fit each inventory... I need each branch to
have it's own stand alone database.

Is it possible for me to create something similar in Access? Do I start by
making forms - ie, parts, finished product, etc. I'm new at Access so I did
download a template that I have been playing with, but I'm confused on how
to link everything together to work like this program does...

Thanks!!

Deb

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

------------------------------------

Yahoo! Groups Links