Is Access the right tool?

Sharpedge · 03-14-2009, 06:13 PM

I use checklists to collect data while I am auditing for compliance to specific quality systems. The data is then used to create a report for the client to use to make corrections (if needed) to their system.

It has been suggested to me to use a database program such as Access to make my checklist with and then based on the answers a query could be run and a report created.

I don't have a lot of experience with Access so I am having are hard time visuallizing this could be done.

Can it? Or do I need to consider a tailored program for my application?

traveler · 03-15-2009, 01:13 AM

Access is an excellent relational data base program.

You would flip if you knew all the programs out there in the world that are based on Access.

Do a demo or tutorial with Access to see how it works. Excel can be set up as a database but it is not as powerful as Access and cannot be set up with easy ways to put the data in, store the data, query the data, and report the results of the query.

__________________
Asus X48 Rampage Formula / Intel Q9450 2.66 @ 3.2 / 2 x 2GB OCZ Reaper HPC PC2 8500 /
VisionTek Radeon HD3870X2 OverClocked Edition / 24" DeLL Ultrasharp 2408WFP monitor /
Western Digital Raptor X Hard Drive / Two Western Digital Caviar RE2 WD5001ABYS 500GB 7200 RPM SATA 3.0Gb/s Hard Drives /
Creative SoundBlaster X-Fi Elite Pro 7.1 / Creative Gigaworks S750 7.1 Speaker System /
Lian Li 343B cube case / PC Power & Cooling Silencer 750 Crossfire Edition /
IOGEAR GCS1782 GCS1782 Dual-Link DVI KVMP switch with 7.1 audio

03-14-2009, 06:13 PM	#1
Sharpedge Registered User Join Date: Dec 2002 Posts: 95	Is Access the right tool? I use checklists to collect data while I am auditing for compliance to specific quality systems. The data is then used to create a report for the client to use to make corrections (if needed) to their system. It has been suggested to me to use a database program such as Access to make my checklist with and then based on the answers a query could be run and a report created. I don't have a lot of experience with Access so I am having are hard time visuallizing this could be done. Can it? Or do I need to consider a tailored program for my application?
(Offline)

03-15-2009, 01:13 AM	#2
traveler Where to next? Join Date: May 2001 Location: South Florida Posts: 18,491	Access is an excellent relational data base program. You would flip if you knew all the programs out there in the world that are based on Access. Do a demo or tutorial with Access to see how it works. Excel can be set up as a database but it is not as powerful as Access and cannot be set up with easy ways to put the data in, store the data, query the data, and report the results of the query. __________________ Asus X48 Rampage Formula / Intel Q9450 2.66 @ 3.2 / 2 x 2GB OCZ Reaper HPC PC2 8500 / VisionTek Radeon HD3870X2 OverClocked Edition / 24" DeLL Ultrasharp 2408WFP monitor / Western Digital Raptor X Hard Drive / Two Western Digital Caviar RE2 WD5001ABYS 500GB 7200 RPM SATA 3.0Gb/s Hard Drives / Creative SoundBlaster X-Fi Elite Pro 7.1 / Creative Gigaworks S750 7.1 Speaker System / Lian Li 343B cube case / PC Power & Cooling Silencer 750 Crossfire Edition / IOGEAR GCS1782 GCS1782 Dual-Link DVI KVMP switch with 7.1 audio
(Offline)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode