Hi all,

I'm new at Access and I am trying to figure out how to create a database to
keep track of tools in my shop (machine shop) and also to remind me whenever
individual tools are due for recalibration.

Does anyone have any information that can help me?

Thanks in advance,

Jim

On Mon, 23 Nov 2009 12:23:01 -0800, Jim Jenkins <Jim
(E-Mail Removed)> wrote:

>Hi all,
>
>I'm new at Access and I am trying to figure out how to create a database to
>keep track of tools in my shop (machine shop) and also to remind me whenever
>individual tools are due for recalibration.
>
>Does anyone have any information that can help me?
>
>Thanks in advance,
>
>Jim

Here are some general resources and tutorials to help you get started. I don't
expect anyone will have a machine-shop tool calibration database just sitting
around, you'll need to build your own - but Access can certainly handle this
task. Post back with any *specific* questions you may have.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]

Jim,

As John told you plus here's an idea work towards to get started.



Make a "Tools" table include the following fields: (shorten all of my
long explanatory names)

ToolNumber Type: Autonumber Primary key
NextCalibrationDueDate Type: Date/Time
Fields for general tool attributes per your desire like ToolName"
"ToolDescription" "Notes" "DateBought" "ToolPurchasePrice"
"StorageLocation" "AssetNumber" "CalibrationInterval" Etc.

Using the Form wizard, make a columnar style form named
"ViewWithFullPageForEachTool" and put all of the fields from your tool table
into it.

Using the query wizard, make a query named "TabularViewOfTools" nd put all
of the fields from your tool table into it.

Using the Query Wizard, make a query named
"ToolsWithPendingOrOverDueCalibration

And put "< Date()+5" (no quote marks) in the "criteria" row in the
"NextCalibrationDueDate" column.

Jim Jenkins wrote:
> Hi all,
>
> I'm new at Access and I am trying to figure out how to create a database to
> keep track of tools in my shop (machine shop) and also to remind me whenever
> individual tools are due for recalibration.
>
> Does anyone have any information that can help me?
>
> Thanks in advance,
>
> Jim

Not sure how many tools and what kind of reminders you need but Access
MAY be more than you need. If the number of tools is relatively small
(20-50) Excel might be usable and it's a whole lot simpler.

I'm not saying Access can't do it, it just might be overkill. Like using
a sledge hammer to drive a nail.

gls858