 |
What do you use Microsoft Access for?
Posted on 01/29/04 10:51 AM
Posted by ghubbell - UA Administrator
Posts: 1939 - Loc: Rigaud, Quebec, Canada
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Survey for UtterAccess.com members
If you have a moment please.
Thanks!
Gord 
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/29/04 12:25 PM
Posted by Dogswell - Utter Access Guru
Posts: 503 - Loc: California
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
My wife is not computer friendly, so I made her a user-friendly recipe book. She loves it.
At work I use Access as a Log Book to keep track of what’s going on and for parts ordering. Also, for spending and budget tracking.
Here is a list:
Recipe Book
Log Book
Telephone Book
Parts Ordering
Purchase Ordering
Budget Tracking
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/29/04 04:51 PM
Posted by peterbj - New Member
Posts: 1 - Loc: South Australia
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I have developed two databases for the local Country Fire Service. [One] for recording Incidents attended, including membership and statistics and [Two] for recording and quick access to identify available hydrants in any given road in the area.
A Government Department to record investigations into Fraud (with statistics)
Two databases for a Private investigation firm.
It is a great hobby for a retired person and certainly keeps the old brain ticking over.
By the way, thanks for the DB sample involving passwords and security level for MS Access. I have been trying to achieve the same using an InputBox without much success.
Keep up the good work.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/30/04 02:36 AM Attachment (168 downloads)
Posted by Ernesto - Utter Access Addict
Posts: 129 - Loc: Argentina - Tucuman Province
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I started with Access 2000 during 2000. Now I'm using 2002 version.
As I work in a university in a social development field, my firsts dbs had matter with popolation with the goal of distinguishing poor people from no poor people; I completed many of these works with excel because its charts facilities. Then I made some other dbs like a library db, a very simple admministration db, a food bank db, an NGO's db, a volunteers db, ecc.
During 2001 argentinian crisis, I began the design of a db that I finished a few time ago, to collect data from children and adolescents and to valuate their growth (weight and stature), taking into account our growth standards. This db do many calculations through vba code (considers polinomical equations). I'm very proud with its performance altough is not completely "normalizated" because it saves in tables many calculated values. Because its complexity or "my limits" I couldn't find a solution for not saving the calculated values. This db uses excel charts that are called from vba code. It also records other items regarding health as diseases, vaccines, arterial pressure (U.S. standards -complex-), biochemical analysis, dentistry data, ecc, and personal-parents-housing data.
All of my dbs are standalone. Just only one is located in a intranet. I use to split them.
In the region where I live, possible in all my country, there's not a culture that allows or facilitates the use of databases (except in banks or bussiness organizations). Also, it is very hard to find people to data entry and to use dbs every day. I think there's a no constancy culture. Many pc user have the micosoft office package (piracy), but only a few use access.
At this moment I'm thinking in commercial offering many of my db or similars. But there are many problems. One is that users needs access and no all pc users have access. And also pc user appreciattes programms that no depends of other prgramms. Access Runtimes are very heavy. What to do?
It takes me a long time to understand Access and to reach a not bad level. Could I expect other return from access different of the proud or pleausure I feel using it?
I put a powerpoint file with pictures of some of the control panels of my dbs and forms, in the case someone wants to take a look. It is a near 500 kb file.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/31/04 05:09 AM
Posted by cs51 - Utter Access Addict
Posts: 135 - Loc: Chennai, India
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Hi friends thank U for your kind help in solving the problems of many.
Access is great because of the power of crosstab queries.
I usually use MSACCESS for educational purpose only teaching the elementary Select queries and Simple Macros and Basic Modules. I will hereafter refer to UA for enhancing my knowledge in Access as well as VB
Thanks
Quote:
If winter comes
can spring be far behind
P.B.Shelley
--------------------
Best regards . Have a nice day
cs
Nothing Succeeds like Success
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/31/04 10:17 PM
Posted by Boxhead - Utter Access Addict
Posts: 61 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
First used Access 5 years ago when I was a sales manager at a new technical training center (MCSE). We had students work off part of their tuition by cold-calling local businesses. Had a form for entering their contact info and 5 bullet points they would discuss. They'd click each point they talked about and check a box if there was any positive response to that topic. We'd then send a letter based on the prospect's response and follow up with another call. Also built a point-and-click resume builder for the students.
Truth is, I found I enjoyed building and managing the databases more than the selling.
Since then I've gone to work for a larger company and have built databases for contests, analyzing customer trends, measuring sales results, tracking salesforce activities, and just about any sort of data manipulation I could think of to figure out what happened last week and predict what will happen next week.
Ironically, I'm still in sales but most recently I've been building some tools for my customers to simplify international shipping and documentation requirements, shipment tracking, and invoice analysis.
At home, my 8 year old daughter is keeping track of my golf scores in a db we built together (she likes to humiliate me) and my 13 year old son and I are about to embark on building a db to try to figure out the 'dominant-gene mapping' he is working on in Science class.
At the most basic level, I suppose, I use Access to fill a personal need to create new things. It seems so much more 'respectable' than writing poems.
John
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/02/04 07:00 AM
Posted by jeffers - Utter Access Member
Posts: 5 - Loc: Swansea, United Kingdom
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
At work (until recently) I used Access to run Nonconforming product DBs and complaints DBs and issue weekly and monthly reports. Also set up forms for use to show anybody in the factory the state of complaints and Nonfonforming products on a daily basis.
At home I use Access to keep a track of my fishing exploits, and photgraphs.
--------------------
Geoff
The Lord said smile for things could be worse, so I smiled and things became worse
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/02/04 11:14 AM
Posted by Rodders - Utter Access Addict
Posts: 81 - Loc: UK, Belfast
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
At work I use MSAccess to connect to multiple online MySQL Databases (data collected by online PHP driven forms) to download applications for entry to and for placments from the Graduate Management Development Programme (Based In Belfast) that I work on and to store the Participants details and our Clients details.
At home I have developed a database for my Fiancee's Design Business to store her clients details and purchasing and order details.
Thankyou for asking. (What are you going to do with all this info? is it just curiosity?)
Rodders
--------------------
Just because you are paranoid doesn't mean people aren't talking about you...
|
|
● Re: What do you use Microsoft Access for? [Re: Rodders]
Posted on 02/02/04 02:45 PM
Posted by ghubbell - UA Administrator
Posts: 1939 - Loc: Rigaud, Quebec, Canada
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Well, I'll copy the 'original' post here:
Quote:
....
This is by no means a scientific survey or would it be treated as such - I'm just trying to come to grips with these current issues with the 2003 version, and how it may benefit / detriment you and I here at UtterAccess.
Myself, along with a few others, have delt with a few 'issues' with Access 2003, and let's say, a few directional changes in how Access is constructed and how it continues to be developed. I am curious to know as much as I can, such as why certain features within Access appear while others disappear. Now, this has to come from somewhere: Either input directly to Microsoft, corporate decisions - something somewhere?!... I can only speculate.
If I (you and I) read through the replies, I think it gives a fairly good idea of how Access is really being used - not necessarily how it was designed to be used. Look forward to what Access may become, and I feel you and I can then better weigh how some of our current and future projects may or may not still be possible using this software. Like it or not, the success of the UtterAccess relies somewhat on the success of Access software, so again, I'll try to understand and gauge how UA should be developed or altered to best suit the needs of this audience.
Overall, to date, I find the replies fantastic and fascinating - and I do hope everyone will keep adding to the list - or re-adding should a new project come up. I don't have the numbers as to how many copies of Access version 'whatever' have been sold, versus how many are actually used to any extent, then versus how many 'real' Access users actually find UA, but from these replies, I believe UA can display a fairly legitimate view of Access users - and the usage is very broad and diversified - although...
I am still not seeing to date, in my opinion, either a great number of Access users moving towards 'Access and the Internet', or a demand for it - and this puzzles me a little as it appears to be the direction that Microsoft is now pointing Access.
Hope to hear from many more of you.
Thanks very much,
Gord Hubbell
Webmaster, www.UtterAccess.com
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/03/04 11:15 AM
Posted by tfman716 - Utter Access Addict
Posts: 116 - Loc: new york
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use access to develop small to mid level applications for a town hall...I have not mastered macros or modules yet but am looking to get to know these better. I have been working with access for about 2 -3 years now and almost everything I know about it I learned on my own and from this site.
I find access very helpful when creating searches for different records and when you are creating a database that will only be used by a small amount of people. As far as Access 2003 is concerned I haven't quite figured out all the new innovations and updates that are used but overall I have found it very helpful. I have wanted to employ Access on to a web page or such but in the past it just seemed to difficult to handle. I am not sure if the new version of Access makes this easier or not since I haven't used it too much.
This site is great and should continue and Microsoft should understand what developers really want as apposed to what they think we want.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/03/04 03:00 PM
Posted by GroverParkGeorge - Utter Curmudgeon
Posts: 10553 - Loc: Gresham, OR
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Gord:
I have a simple, perhaps overly simple, theory. MS wants us to move to "Access and the internet" because that envirnonment conforms to their vision of the "connected" workplace--no more complicated than that. Stand-alone PC workstations are a thing of the past in that vision, so there is no reason to give them much thought, let alone accommodation.
George
--------------------
Some say Google is evil. Some say MS is. "Darned" if I Google, "darned" if I Bing.
MS Access MVP 2010
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/04/04 07:58 AM
Posted by anseris - Utter Access Enthusiast
Posts: 48 - Loc: Mozambique
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I'm really proud of an access database I helped build last year, as part of a project to improve the efficiency of a provincial government office which assessed claims for land tenure, and also assessed and received payments for land tax. Not only did the db help the staff work more efficiently, but it reduced opportunities for corruption in the process (meaning the financial kind, not the data kind).
At the moment I'm working on dbs to keep track of human resources data. Later this year I am slated to start work on a db to store information about disaster preparedness, e.g. the available resources in various locations, their state of repair, etc. These dbs are for local NGOs.
All these dbs have to run on computers far from the top of the line.
anseris
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/04/04 11:44 AM
Posted by janineo - Utter Access Enthusiast
Posts: 20 - Loc: Wells, England
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use Access in business.
I inherited an Access based application when I joined the company and have been working on it (on and off) ever since!
It's essentially a phone bill analyzer that we send out to our customers along with their phone bill data. Think business phone bills, not home phone bills.
Produces lots of reports on their data, provides filters for those reports and other stuff. It wasn't designed very well in the first place, but I'm slowly making it better with lots of help from this and other forums! Thanks everyone.
Janine
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/04/04 02:54 PM
Posted by WER - Utter Access Enthusiast
Posts: 31 - Loc: Cleveland, OH USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I first started using Access back in 98 while in the USAF. Working in the Mobility section at the "Flight" level, it was our responsibilty to ensure our personnell an equipment were able to deploy anywhere in the world within 72 hrs of notice. We used access to track and forecast personnel training and immunization requirements, as well as our equipment's scheduled maintenance dates. We were recognized for achieving 100% pass rates during inspections. Once we showed our database to high ranking individuals it was adopted at the "Squadron" level (muliple "Flights") and "Wing" level (multiple "Squadrons").
I now work as a field representative in the Workers Compensation department for a large trucking company. I use access to track information on individual employee injuries: treating physician, light duty schedule, appointment dates etc. I use the information to provide regional, terminal, and departmental managers with weekly, and monthly reports.
I must admit that Access has been an invaluable tool to me in my career.
I wish to deeply thank all of those at UA who have given me help in the past, and to those who may help me in the future. 
--------------------
Bill
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/04/04 09:57 PM
Posted by Diehammer1 - Utter Access Enthusiast
Posts: 24 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I only started using Access in December and have already created:
Software for a Major French car manufacturer which stores all their customers details including which dealer the customer bought from. It is used for courtesey calls and to help sales people get the customers to attend sales events.
My second project was for data entry for a Gas company. It allows the user to enter details on customers and arrange call dates while allowing the user to see which jobs have been done, call back dates and job which have still to be done. (This is the first project in which i used a switchboard.
My latest project is an Invoice system for the same company. It allows users to enter the invoice details on a form such as date invoice number descriptions etc. I used expressions for the first time in the project to calculate the NET AMOUNT, VAT and TOTAL. Once the form is closed the NET AMOUNT is then stored in the table along with Date, Customer, Invoice Number etc which allows the books to be done quicker and easier than before.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/05/04 03:24 PM
Posted by kfield7 - Utter Access Veteran
Posts: 479 - Loc: Sacramento, CA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I am an environmental engineer, working for an international consulting firm, and as such use Access primarily to develop environmental tools, although I sometimes get on smaller side projects.
My first exposure to Access was with Access 2.0, sometime around 1995. I started developing using Access97.
Some of my work includes:
Wood Furniture manufacturing MACT compliance tool
Aerospace maintenance facility compliance tools (emissions, compliance)
Fugitive emisisons monitoring tool
Various coatings emissions accounting tools
SARA TRI calculation tools
Remediation project tracking tool
Various air emissions tools, interfacing with other databases.
Industrial hygiene personnel monitoring.
I have also used Access as an intermediate tool in data migration between old and new systems.
I also created a church member database.
I am mostly self-taught but learned a lot from the Access Web before I found this site. I have found Utter Access to be very educational, often discovering things I had never thought of or considered.
I enjoy the professional "can-do" attitudes generally conveyed here.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/05/04 04:48 PM
Posted by TerryGM - New Member
Posts: 3 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I have been writing applications in Access for the past five years. Started with debugging and improving code to a frontend for the company labeling software for industrial customers, worked with Access ver 2.0 then. After moving from Product Support into the IT department, I started designing Access Database Applications for various uses. First project was for generating reports from FrontRange Solutions HEAT database using Access 97, first time working with a SQL database. The app would allow users to pull help desk calls according to various criteria, fiters and sort methods. Uses about 12 different basic report formats that the frontend customizes with data to show.
Next project was a Cartridge Maintaince System written in Access 97 and MS SQL backend, we rebuild laser toner carts. The application would generate serial numbers, track what builders worked on each cart, and other tracking information. Exported serials to file for import into MAS 90 accounting system, then tracked each serial number as it was shipped out using Invoice numbers from MAS 90. Also tracked RMA numbers from HEAT call ticket software to notify user when they were recieving the carts back for rebuilding.
This has now been partially re-written in Access 2K to include abilities to generate offsite serial numbers, in mexico actually. No longer export the serials to MAS 90, now when a cart is shipped it is tied to a sales order number. Later the new application pulls the Invoice number for the sales number from MAS 90, and merges the data into the old database. We still do RMAs the same way, but no longer recieve all the carts back. This new method still allowes personal to track carts through out thier lifetime.
Working on a Inventory/Bin location management system now using Access 2K, MS SQL backend, and asp.net for mobile devices. Have done many other smaller projects, an employee birthday, and aniversary db that would update web pages on intranet web server, various report generators, work order indexer (don't ask it's a mess), and such.
Have moved into vb, working on various .net languages too. I still like creating frontends using access, so much quicker than other methods. Speaking of such, better get back to latest wants on the IBLMS app. Why can't these people tell me everything they need and want in the first place?
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/06/04 02:12 PM
Posted by rjbudke13 - Utter Access Addict
Posts: 59 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I run the entire gamut with Access: I use it at work for Time & Billing purposes and for Work Order management. At home I use to track our households various collections (matchbox cars, hot sauces, comics, rubberducks, snow village...). Anything I can think of I try and use it for.
--------------------
Continued Success
-Ryan
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/07/04 08:40 PM
Posted by aryder - Utter Access Addict
Posts: 140 - Loc: Alabama, USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I originally used Access to set my mother's business up to track her clients' birthdays, anniversaries, etc. Then when I opened my own business, I set it up to track all my clients, do my billing, and keep track of my tax deductions, etc. Then I set one up to track my family tax deductions. Since then, I've had friends ask me to do different ones for them. I wrote one for an auction house and am currently writing one for a friend who sells on Ebay.
I haven't done anything with data access pages. I quit using Access macros after the first one for my mother. I like to code as much as possible. One, it helps me grow and learn and, two, it lets me understand exactly what's happening at any given moment.
Angie
--------------------
Harvest, AL USA
Why is the word "abbreviation" so long!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/11/04 11:42 AM
Posted by Lemonstar - Utter Access Veteran
Posts: 204 - Loc: Charleston, WV
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I work for a Highway Dept and use Access for the following. I have learned databases trial and error since the early 90's with limited time for learning. I started out with Paradox (DOS version) and switched to Access/Windows environment. I realize I'm not accomplished when I see the knowledge on this board but I have learned enough to greatly improve work efficiency in many small work areas within the department compared to systems that were used previously, either on a spreadsheet, word processor or old DOS program.
-Processing of FEMA Events for Disaster Damage
-Maintaining Roadway History Files
-Tracking progress of various permit requirements for building bridges
-Encroachment Permits, Emergency Authorizations, Bonds
-Research Projects
-Various Correspondence tracking/deadlines
-Citizen's Request for Assistance
-Training
-Summer Employee Records
Utter Access has increased my ability to learn much more quickly because of the quality help that I receive when I post a question which prevents me from having to dig through tons of books and help screens that may or may not lead me to the answer. Thanks to everyone of you!!!
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/11/04 02:58 PM
Posted by Bucephalus - Utter Access Addict
Posts: 54 - Loc: Kentucky
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use Access in HR for everything and all are used on a local area network (LAN), some by people around the world. (Slow)
I have a training matrix DB for 800+ emps
I have Symbol# request DB to speed up the new product process and orders.
I have a retired Attendance DB, KRONOS took over.
I have a shortage DB for Buyers and Supers to communicate shortages quickly
I built a Parking lot DB for tracking license and # tags
I maintain a Six Sigma db for tracking waste %
Discipline Log
Job Bid posting DB
I use Access for everything!
Using quick-load tables for repetitive data, you can't beat Access.
I love this software, you learn something new everyday! And hats off to Utter Access, it's been an big help!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/13/04 11:54 AM
Posted by chemist - Utter Access Addict
Posts: 170 - Loc: Dublin, GA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I am using Microsoft Access as a front for information coming out of an AS/400 system. Currently I am working toward developing a scheduling system for a textile manufacturing plant. 
--------------------
I am always amazed at the number of people who think they can't.......and find themselves to be right.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/13/04 01:02 PM
Posted by houseofharman - New Member
Posts: 1 - Loc: Pullman Washington
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
We use Microsoft Access to monitor workload and as a tracking system for paperwork. We generate monthly reports that are part of a balanced scorecard system which monitors effectiveness and efficiency of our office. Our accountants use it to track what reports are due when and as an invoicing system.
|
 |
● Re: What do you use Microsoft Access for? [Re: chemist]
Posted on 02/13/04 01:34 PM
Posted by LakeGator - Utter Access VIP
Posts: 1526 - Loc: Tampa, Florida
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
This brings back great memories. In 1972, I worked on a team that developed a labor scheduling for a textile plant in Greenville, South Carolina. This application was in FORTRAN on an IBM 370/165.
The most exciting part of the application was handling the days when daylight savings time went into effect. People had to be scheduled for two consectutive (but different) 2 AM hours.
Have fun!!
--------------------
Keep smiling  Free advice is worth every penny
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/13/04 05:35 PM
Posted by ChristineInDC - New Member
Posts: 1 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
At work I manage a basic association management database (contacts, events, orders, etc.) and a fundraising database, both in Access 2000. Also, I use Access-based statistical software called EpiInfo (http://www.cdc.gov/epiinfo/) at work, so I have a variety of Access files that store survey data. I use Access to build any created/recoded variables needed, and then can use EpiInfo to run crosstabs and perform statistical tests.
At home I have a database of my books (what I own, what I've read, what I'd like to buy, etc.) and I'm strongly considering building a recipe database.
-Christine
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/14/04 10:11 PM
Posted by MrJaven - New Member
Posts: 1 - Loc: MN,USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I am curantly using it to build a network administration tool box that tracks eatch (administrative)users actions and to stock pile any and all scripts and other tools used with command line options used by the user so we can track and repeate anything we do that fixes a problem so that we can all become fat and lazy over time
moto: if your IT staff works hard somthing is not working well
--------------------
when you THINK you know look it up
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/16/04 11:54 AM
Posted by faragher - Utter Access Veteran
Posts: 416 - Loc: Devon, UK
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Uses so far:
Commission tracker - records sales and calculates commission, produces statements etc
Billing/Payroll system - Proud of this one, but still being developed - takes the 2000+ seperate jobs done by 50+ staff for 75+ clients monthly and whups it into some sort of order
Bill of Materials system, linked to Sage Line 100 - my head still hurts when I think of this one - recursive calculations are scary!
And some other bits and pieces...
Thinking about Access and the Web / the connected office / the great big WiFi Broadband super-duper web etc etc. This really discounts small business applications. The business I help run only has one computer, we use it to type letters, send emails and do billing and payroll. Thats it. We don't need two, we don't need to communicate with our Hong Kong office over the 'net - because we haven't got one (this is a local business, for local people).
Microsoft seem to be in risk of concentrating on SME upwards, missing a huge and luctrative market that requires very simple and easy to use solutions to everyday tasks - this was the computer revolution we were promised! I love XP because it's comparatively stable and my mother-in-law can use it, and I don't want the water to be muddied with additional options and connectivity.
Seem to have started ranting
jf
--------------------
"On Time. On Budget. Working. Pick two."
Confused? You will be.
Try a little lemur for inspiration.
__________________________________________
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/24/04 05:02 PM
Posted by EAllen - Utter Access Enthusiast
Posts: 27 - Loc: Oregon, USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Just discovered this site; looks like a great resource.
I use Access 2000 at work to track and apply costing information products our company buys and sells.
Product is bought, processed and sold all withing the same database. Using complex forms.
Opposite of 'chemist' above, my reports output information to our company's AS/400 accounting system. My DB has just about reached the limits of what the version I use can do. So I look forward to learning about some of the new improvements/changes.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/20/04 02:59 PM
Posted by kukui - Utter Access Veteran
Posts: 273 - Loc: U.S.A, Southern New England, RI, Frosty Valley
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
During the day I work at an environmental testing laboratory. Our Laboratory Information Management System (LIMS) was built using Access 97. We store all the data of a sample that comes into our facility, in our LIMS. Physical description of the sample, when it was samples/received, types tests to be performed, and the results of the tests. We also use it for generating paper and electronic reports. The electronic reports are anything from a simple CSV file to a multi-file sample and result coded nightmare. Access has made development of the electronic reports much easier.
At night I teach ballroom dance. They have been using paper records for everything and want to try and put together an application that will house all the information. Teachers and student information (not so hard), scheduling of lessons (not bad but formatting the displayed schedule will be a challenge), and finical data including payroll. So if anyone has any suggestions, please send them.
This forum is great, keep up the great work.
--------------------
-- Scott
Normalize till it hurts. De-normalize till it works.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/29/04 09:58 AM
Posted by jujutsumaster - Utter Access Enthusiast
Posts: 34 - Loc: United Kingdom
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
First had a dabble with access about 7/8 years ago and seemed to pick it the basics fairly quickly but didn't have much need to develop applications. Since becomming performance improvement manager for my local authority in UK saw the need to reduce paper chases, improve efficiency in specific areas and provide connectivity between departments and produce corporate management reports.
Out of exasperation developed a corporate performance management system to collate performance statistics and provide a monthly monitoring and reporting framework. Recognised by a national agency as excellence in local government (this one .
Also a db to track important enquiries/correspondence, setting target times dependant on nature of enquiry. Allows transferability of ownership between departments and corporate reporting and stats.
Corporate absence monitoring db with full stats analysis.
Desk top timesheet system for a department required to recharge external agencies for work done based on hourly rates of employees
One or two other statistical and tracking dbs where inputs are gathered from several departments.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/15/04 10:14 PM
Posted by JVanKirk - Utter Access VIP
Posts: 3714 - Loc: Northumberland, Pennsylvania
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I created my first db with Access 2.0 in 94. I made a Work orders/Customer Service db on an old 386 box. I had to remove all other office suite products just for te ting to be somewat efficient. I ave dabbled with it ever since, and am addicted to Access. I am self taught so there are things to learn yet, I just recently started really getting involved in the VBA side of it and WOW. My biggest project to date was a db I started to repair then realized it just plain needed rebuilt. The directorate I was in was going to pay inthe neighborhood of $20,000 for someone to come and repair it. Wen I saw what they needed I volunteered to take it on. Too bad I couldn't have made some of that money but when you're in the Army you get paid the same no matter what you do. But it was a great learning experience. It tracks around 500 copiers, payments and adjustments, amount of copies made and amount exceeded the contract etc etc. Recently I created a Tasking/Work Order db for my current unit. I am about to create a solutions db over the next few weeks which will allow us to record fixes to differant problems and refer to them quickly in the future.
This site has been an incredible help at getting me where I am now in my Access abilities. I thought I was pretty darn good till I logged on here and realized I was at the tip of the iceberg. Now I am a little further along, hopefully will be back to feeling good about my abilities in a few more months of reading Rick Hicks and Jacks and everyone else's posts. Keep them coming, I am taking it all in and db'ing it my master db(the noggin).
Jason
--------------------
Jason VanKirk
PA Dept. of Environmental Protection / GIS Coordinator
If I had Superman powers everything would be easier
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/21/04 12:27 PM
Posted by MJohnson - New Member
Posts: 2 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I've returned to a previous hobby - sewing - and am attempting to use Access to build a database of all my fabrics with a picture as well as other pertinent information like quantity on hand. Wish me luck!
Mary
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/22/04 02:43 PM
Posted by sstaccess - Utter Access Member
Posts: 9 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I am trying to teach myself Access 97 at work by using wizards and design view. I have been working at it for 2 years. At work, I have databases on the intranet to track inventory, customer drawing library, changes to internal procedures in the Document Control area. The hardware calibration recall system is controlled by a db, also the vendor rating system and various tracking logs.
At home, I am just starting to use Access 2000 and have created a home inventory db to collect data on what is in the house and save to CD for offsite storage in case of disaster (fire, flood, etc.).
I am new to this site and hope to learn more about Access by finding solutions to my problems here and by reading the problems of others and how those problems are resolved.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/22/04 09:59 PM
Posted by popsdrown - Utter Access Member
Posts: 15 - Loc: St. Louis
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I used Access 97 to collect and cleanse manufacturing data - spares, supplies, vendors - for 6 manufacturing plants and then created output files to load into SAP. I wrote another application for a telephone reservation center to book public tours for a new LDS Temple. It handled over 275,000 entries. Now I am supporting an application in Access 2002 that supports an antique business with a data feed from eBay.
Love Access!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/30/04 11:06 PM
Posted by treeless - Utter Access Guru
Posts: 960 - Loc: Yuma, AZ
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I started way back in Access 95. Developed a database for the wife's greeting card company.
Then there was a problem at work. We got a 5-channel trunked radio system at two sites, and the Govenment wanted annual utilization reports, by channel, by site. The problem was the system only put out flat file ascci reports (1 report per day, per site), so someone was assigned to go through a print out and add up all the transmissions and busies, by channel, by site. I developed a database that imported the basic data from the flat files, by site, channel, time, whether it was a call or busy, and the duration in a table, then generate the reports needed. Not only did this get the required Government reports out, but now we could look at the data during any timeframe, in any number of 'views', allowing us to determine when there are irregularities in the system and helping us find the technical problem, and will ultimately detemine when the system will require expansion.
Since then I've developed databases to assist in tracking investment program exection, tying into external financial tables, and an application to track needed investments.
--------------------
J. Hamilton
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/04/04 02:13 PM
Posted by stan1941 - Utter Access Member
Posts: 8 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use Access to track several multi million dollar Engineering, procurement and construction (EPC) projects. Projects have many components, Most usually maintained in spreadsheets. Access is used to link the spreadsheets and bring it all together into a tracking and reporting tool.
Tables includeing Projects NO & names, Phases NO & name, Original budget, change order & deviation log, current budget, purchase order logs, construction contract logs, owners cost . When all the stars are in line I can download accounting information with payroll, expenses and invoices on Monday Morning and provide a up to date cost report for all open project by noon. The project managers can then review & edit their "forecast at completion" and issue a weekly report. noting any budget under or over runs.
My problem is I didn't do the programming and much of it is well over my head and my programmer is no longer around. So necessity is the mother and I learn as I need fixes.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/05/04 05:24 PM
Posted by leduncan - Utter Access Enthusiast
Posts: 33 - Loc: Western WA - Go Mariners!
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use Access mainly for business. I am new to this website, but not Access. I have primarily taught myself with books and the internet.
Currently at work I manage the db that tracks all pilots, flight engineers and crewmen qualifications, physicals, etc. Creating reports with soon to be (30, 60, 90 days) expired. Also use Access at work as a test generator. Having a database of hundreds of multipule choice questions you can build tests with any amount of questions and create a "master" with the answers.
I've just jumped into the private industry (if you haven't figured it out my primary job is the military 18+ years). I have created a db for a friend to track Ebay auctions and all the stuff that goes with that. I am currently building a database for a Ceramic's shop. (My first paying customer!) It is my most challenging project yet.
Of course, like many others, the Access addiction runs off into my personal life. db's for everything from organizing pictures, baseball card collections, home inventory...the works.
I think a great addition to this site would be it's own database with all of the great db's people on this string alone have created that would enable them to upload sample (no data) dbs to share with others. Does anyone know if there is anything like that other than the 7 or 8 samples in the forums?
Anyway, this site has already helped me get over a couple of hurdles (saving me some forehead skin).  I think that UA is great! Keep up the good work!
Eric
--------------------
Using Access2K and 2003, FrontPage2002
Arguing with a flight engineer is like wrestling with a pig in the mud. Sooner or later you realize the pig is enjoying it!
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/07/04 04:20 PM
Posted by river6 - Utter Access Enthusiast
Posts: 41 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I use Access to: make a Call Log application for Hipaa compliance and workflow for self-funded government insurance office. Also, use Acess to gather and audit premium against membership for health, life, and dental premiums (generate exception reports). Use for payment tracking.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/16/04 09:31 PM
Posted by LenaWood - Utter Access Ruler
Posts: 1283 - Loc: Hermiston, OR - Umatilla Chemical Agent Disposal F
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
At work I use Access 97 and have Access 2000 at home.
I started using Access as a challenge from my former boss nearly four years ago. The company paid over $2,000 for a database that didn't function as they had invisioned (not that it was a bad database, just wasn't what they wanted...they were not sure what they wanted either). After asking many many questions, I designed the Safety Action Tracking System (SATS). Through reading books, searching the internet and finding forums such as this one I was able to create something that was functional beyond their imagination...now that I have a bit more experience, I often wonder why it works.
Since then I have changed jobs and now build, maintain and update databases on a daily basis...thanks again to forums such as this one. I have built databases to track Surety/Security Findings, Track Employees and their status in the CPRP, track Emergency Preparedness Exercise findings and observations. One of the databases that I am quite proud of the time it saves me is our Accountability Database. I use this database to make Accountability Card - which is also used for a second form of Identification on site. Although it is simple, it stores links to pictures and easily allows recreation of the Accountability Cards that get lost or need to be remade for name or department changes.
There are other databases I have built, but they are all very similar to the ones I have listed.
Many thanks to this site for helping me improve my skills. People at work think I am so good at what I do...I just tell them behind a good database is a wonderful forum filled with even more wonderful people making it work.
Lena
--------------------
Proud Grandma to Ronan Daniel 05/18/08
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/18/04 10:39 AM
Posted by murdo_2002 - New Member
Posts: 4 - Loc: Perth, Scotland
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I first used access on an IT course in Glasgow to learn about databases. I had had a brief flirt with it when I worked for my previous company (3M) but did not get far due to lack of time/training.
I use Access at home for two things: to track my job applications and as an address book. I decided to use it as an address book instead of Outlook. I could customise access a lot easier 
I also do voluntary work for a charity. I am adapting their database which they use to generate statistics as well as log some details.
Therefore I find I am learning about Access. Utter Access great to use to find answers to niggling queries.
Thanks
Murdo
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/29/04 04:46 PM
Posted by CopyKat - Utter Access Enthusiast
Posts: 24 - Loc: Charlotte, NC
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Greetings All,
I'm currently building an Access front end to a SQL db solution that uses a SNMP to monitor a fleet of networked mutifunction printers in a major hospital system. The goal is to be able provide a high level of detailed reporting on the volume/usage/problems/ trends of the fleet. I've also added other functionality such as automated supply ordering and tracking ect.
I started with Access because I wanted to increase my pc knowledge and ordered a training CD. After the course I had no clue what Access was. This was frustrating to say the least so I decided I needed to build a database just to learn Access. So I built a db that tracked and reported some of the functions of my job at the time. It was a hit and other people in the same job as I began to use it. The rest is history. I just wish that I could spend more time working with it. Seems I'm always needing to do other things. Oh well...
Love the web site. It's the only fourm that I use.... Thanks to All !
Kevin
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 06/20/04 03:47 PM
Posted by Budlong - Utter Access Member
Posts: 15 - Loc: Los Angeles
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
Several years ago I got so annoyed at Peachtree Accounting (antique data structure, artificial limitations, unbalanced trial balances) that I learned Access and put together my own double-entry accounting system. Access has its annoyances, but not nearly so severe as that Peachtree system. The benefits are worth every hour spent in front of the computer.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 08/05/04 03:40 PM
Posted by lindav310 - Utter Access Member
Posts: 13 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Started using Access in 1998 when I inherited my high school class list in Excel format. I knew that there had to be a better way, had MS Office Professional at my friend's house, imported the excel - and self taught myself. Took a database class, used the Class List as my project, and truly tweaked the performance of the information. That was when I learned I really liked the logical application of Database management.
Next step was to create a database for my Church's religious ed program. (They used a paper ledger to track all info.)
Now, I work with a Web-based Time and Expense Database at work. It was created about 5 years ago, with some definite structural/normalization problems. I am actually afraid to make any changes though, because we have massive asp code depending on the current structure.
Although I hate the asp for debugging, I really do enjoy working with Access.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 08/19/04 05:55 PM
Posted by drelliotg - New Member
Posts: 2 - Loc: new york
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I am a physician who wrote a custom practice management application in microsoft office 2003 and scansoft's dragon naturally speaking v7.3. to run my offices. I dictate nto dragon as a voice recognition application to transcribe my medical records which is saved as a word file and then composes various consultation reports and correspondance letters as necessary. The demographic and financial record data is held in excel and linked to access to establish relationships among the various tables. Access prints the invoices and then holds the financial reconcilliation data to link back to excel for financial analysis of the entire practice (cash flow and tax planning). Powerpoint takes pictures and turns them into a presentation for public and professional speaking engagements. Outlook is how I receive order from my wife on what to bring home for dinner........................................
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 10/29/04 12:30 AM
Posted by Marty - Utter Access Member
Posts: 10 - Loc: California
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I use it at work to track various inspections of scales and gas pumps. And issue invoices and such
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 11/18/04 02:02 PM
Posted by dharvest - Utter Access Addict
Posts: 56 - Loc: Georgia, USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I started using Access when I was working at a Port Authority. We were storing large numbers of rolls of paper to be shipped overseas and needed an inventory program. The existing software that was developed for the port was very good at tracking containers, but terrible at tracking rolls of paper to go into those containers. I set up an inventory system to interact with the vendors' information downloads, scanners, handwritten information and uploads to the vendors. It ended up being a terrific timesaver. I'm still learning more about Access (especially Visual Basic) and am currently working at designing a package to manage the scheduling needs of a convent which is also a retreat center. I have looked at a lot of software packages which can do most of what they need, but have not found one to match their particular requirement, so I'm designing one myself. We are currently having their mailing list put online, but I'm not sure if thy're using an Access-based platform or not.
|
|
● Re: What do you use Microsoft Access for? [Re: drelliotg]
Posted on 11/23/04 11:06 AM
Posted by beyondnerd - Utter Access Addict
Posts: 151 - Loc: Schnecksville, PA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
drelliotq,
I'm the director of a non-profit community mental health center and I'm planning a similar db to the one you described. One of the key features will be incorporating speech recogniyion for the psychiatist's. Do you have any tips. Have you or anyone else ever tried using the speech recognition to input text directly into an access db. I would appreciate any advice.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 12/06/04 08:05 AM
Posted by geilsc - Utter Access Enthusiast
Posts: 38 - Loc: London, United Kingdom
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I'm a professional database developer working for an insurance company in the City of London. I use Access to connect to corporate SQL server db's and run reports/do data extracts and to develop stand alone apps. Been using it since Access 1 or was it .87 (all so long ago). Will occasionally use Visual Basic to connect to SQL or Jet db's if I'm absolutely dragged kicking and screaming but Access is such a handy datacentric tool its way easier to use than VB for db work. All my db's are heavily coded and use hardly any macro's. Very rarely interact with the web but then again our comapany dosn't encourage people trying to publish to the intranet so that's probably why.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/06/05 09:45 AM
Posted by twigleaf - Utter Access Veteran
Posts: 216 - Loc: Halifax, United Kingdom
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I started with a small database to link three departments that wanted to share information (sales, production, marketing) but used creaky excel spreadsheets that were massive and unworkable. (way too many records and information.)
Made the Db to get out of my actual work. Left there and heard that no one wanted to use the new Database I created - not shocked. That was AC97
New place of work relied on lots and lots of spreadsheets and paper to store stuff. Costly stuff if lost. Despite some Lotus databases and the skill set to do some DB's instead. I created three there, purchase log, phone log and a sales log. All of which helped me and the other staff. That was AC2000 and full of macros... They were then the best thing I knew.
Left there and moved onto IT in Insurance where I have now started designing on 2003. They paid for a training course in VB and things lifted from that. I have created six so far to help process inprovements, sales logs, phone logs and customer details for in house stuff. Auditing etc. Ranging in scale from 2 users to 12 users and with management and directors requiring access for audits and monthly reports.
I am now working on SQL for the larger databases and have become responsible for the 40 + existing databases used throughout the company for everything from purchasing, accounts to sales and marketing. It seems the skill set is EITHER basic windows packages ilke Excel and Word. OR Massive skills like C++, SQL etc.
Access fills a nice niche in the middle at workable databases that run on any Pc for a cheaper MS licence and little or no conflicts with hardware, networks and even the more stupid user can work
--------------------
Cheers
"Some acquire greatness, Others have greatness thrust upon them. You my pointless little friend, have let greatness fly far above your head."
"...but neither of us can understand Access 2007"
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/14/05 03:52 AM
Posted by Beilby - New Member
Posts: 1 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I have been thrown into maintaining an Access db for the Wildlife Rehabilitation Hospital I volunteer at. I have developed databases in purely visual environments before, but it turns out this guy is all VB - and I don't know any VB (or have anything like the time to learn it). So I am looking for a VB programmer who would like to work on a volunteer basis to help modify and extend this system.
Where can I post this request? I realise this isn't entirely the right forum, but I couldn't see a better one in the huge list of forums at this site.
Anyone interested directly, please email me via gary at beilby dot com. Other than that sorry for hijacking this thread - at least I told you what I'm using Access for
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/15/05 02:14 PM
Posted by bingowens - Utter Access Member
Posts: 7 - Loc: Chicago, IL
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I have been using Access for regulatory reporting for unclaimed property and all related processes. From mining data out of our data warehouse, to analysis and ultimately providing data/backup for the annually filing of unclaimed property will all 50 states.
Bing
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/24/05 04:28 PM
Posted by fish360 - Utter Access Enthusiast
Posts: 48 - Loc: NY
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
Managing a camp waterfront. Keeps track of the swimming classes the campers have passed as well as what swimming tag color they have.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/11/05 08:30 AM
Posted by Jason_Pend - New Member
Posts: 2 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
i only use microsoft access for college projects at the moment!!
Jason_Pend
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/11/05 12:53 PM
Posted by likajoho - Utter Access Guru
Posts: 593 - Loc: Oklahoma
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use Access at home and at work for data management of many kinds.
I've learned, besides for creating relational databases, it's also a much better way to manipulate unrelated table data to view and print in different ways without compromising the data.
It's also an alternative way to view data from database programs that are not so friendly. If you can export the information, you can usually import it into Access.
At work I have developed the following databases:
1) CMInAccess - Store,view, query & report data from a FoxPro based program called Campaign Manager, which doesn't give me the flexibility I need. (The only thing I lack on this is an ability to read some of the text fields which do not export to a db or txt format. Any ideas on this?)
2) Payroll - Completes IRS, FEC & other payroll/contract related government forms.
3) Survey - Record & analyze survey responses
4) Contact - Manage contacts
5) Work Log - Print various reports from my work log for reporting to & invoicing clients
6) Committee - Combination donor management & financial database used to record, reconcile & report on all financial transactions, as well as extract donor information.
7) Royalties - Record clients' oil royalty receipts for reconciliation with 1099s, determination of depletion method, & completion of IRS forms
8) Auto/Mileage Logs - for preparing tax returns
At home I have developed databases to:
1) Index genealogical publications
2) Record & submit cemetery surveys & indices
3) Manage personal contacts
4) Manage club membership records
5) File ideas
6) Index libraries
7) Record volunteer hours & mileage
I also now create short-term databases to manipulate data I previously used Excel for. Whenever I have a worksheet I find myself sorting, totaling, and viewing in more than one way repeatedly, I know it's time to take it to Access.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/19/05 05:42 AM
Posted by Zeev - Utter Access Addict
Posts: 128 - Loc: Los Angeles, CA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Since I love Computers and databases, I wanted to take the challenge of building my own database to control my business contacts, companies I am doing business with, products I purchased and more. By doing so I wanted to gain more control of my info and to better learn databases. I think I did well. Few features are not working yet, but most does.
A note to this community! - I posted two question on the form page. within couple of hours I got the solution to one. I thank you. I hope I will be able to help this group too.
Zeev
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/26/05 10:37 AM
Posted by biggie277 - Utter Access Member
Posts: 6 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I work in the prison system. I started out with Paradox in the mid'90's. The data base was already in use and I learned by using it. I developes a small Paradox db to track each prisoner's progress. A couple of years ago we converted to MS Office. While some complained of the difficulty in use, I was able to develope a better database. In addition to monitoring a persons prograss, we use it to automatically change a prisoners cell in our count sheets(reduces errors in typing names and numbers), our count sheets (excel) automatically takes the iinfo from Access and places the person properly. I then developed another excel program whch automatically places a person in schooling classes and (temporarily) removes them from the class if they are ill, and places them bac in the proper class once they are better. We monitor their age and I can within minutes generate a report that helps me verify that people are placed in rooms based on age criteria.
I have developed a seperate db that allows a person to automatically place all of our prisoners on a work assignment. One report generates an overall report with everyone's name, number and work assignment on it, two other reports that generate only the specific reports(work assignments) needed and another report to generate a specific report. These reports are on smaller sized paper (about half a sheet) which has caused me some difficulty in getting the reports to generate properly.
Our db's are not linked to the internet(due to security issues), but are on servers.
I have done this all on my own, mostly from trial and error and * for DUMMIES books. My wife took a college ACCESS class a couple of years ago and I believe I knew more than the instructor. This is not saying much for me. I know that there have got to be very knowledgabe people out there to help, but finding them is difficult. I have been able to follow most of the rules for data redundancy, etc., but have had a few problems with reports, but an unable to find answers in any books, to date.
I am looking forwaard to this forum.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/31/05 03:09 PM
Posted by doctor9 - Utter Access VIP
Posts: 4786 - Loc: Wisconsin
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Five years ago I was hired by a testing lab thru a temp agency to do basic office manager stuff. The lab had a few primitive data entry forms in Alpha5, which no one really liked. So I sat down with the users, designed similar forms in Access, but with an eye towards easy data entry. Today I'm a permanent employee, and I've designed forms that do stuff like calculating Slope and Intercept based on IF tests so complex that I need to document my process in multi-page Word documents. One of my latest databases successfully stores .jpg photos of test results as BLOBs, and displays them in reports on demand without the bloat.
Frankly, if it weren't for my Access skills, I'd probably still be renting, rather than paying off a mortgage.
On the side, I'm helping my wife with her photo studio. For instance, I've created a master checklist of specific wedding shots she can get. The customer choses off which ones they want, and she prints out a list of "must have" shots that she can take with her on location.
Someday I'll get some free time to do the data entry on my old comic book collection. I taught myself Access while creating a comic database with the criteria that _I_ found important, rather than just downloading one off the 'net. I'm also developing a database of the 35-year history of my community theatre so we can see what roles a certain actor has played in past productions, and who directed, and what did the program cover look like, etc. Theoretically, a shrunken version of the IMDB.
Dennis
--------------------
"I refuse to answer that question on the grounds that I don't know the answer." - Douglas Adams
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/04/05 04:05 AM
Posted by soma1958 - Utter Access Member
Posts: 11 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
If you want to know what microsoft access is used for then
Its a relational database system used to store data and can be retrieved at request and in the desired form .For example -as in your case -the calls system may contain date,time,calling number,name,location,and subject etc.How ever, when you want to enquiry you can search by any required field or more .You can make the data available on network for other people to share information in controlled manner.
The analysis and database design depends on your level of knowledge in the subject.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/06/05 05:04 PM
Posted by tergarone - New Member
Posts: 1 - Loc: Chicago, Illinois
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I run GeoNetworks reports ... that software allows us to save the data from the report pages to MS Access tables. I then link the tables to perform queries to respond to RFPs from healthcare brokers. Mostly reporting and research.
tergarone
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/07/05 08:47 PM
Posted by ozysolutions - Utter Access Enthusiast
Posts: 39 - Loc: CA, USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I have created many databases including: Address book, student grading, customer, contract management, employee management, stock control, and too many others to list. I started using Access for Windows 3.1. Before that I used Dbase, filemaker pro,. I love access at it is easy to get the results you need. Now I create databases for small business.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/22/05 01:25 PM
Posted by mrspruitt - Utter Access Addict
Posts: 64 - Loc: Alabama
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I am designing an auditing application for a cusomters' software quality department.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/22/05 05:28 AM
Posted by Simon123 - Utter Access Member
Posts: 17 - Loc: Australia
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use Access for curriculum development and management. The database links Training Specification (TS) Course Training Outcomes (CTOs) with Learning Outcomes (LOs), Assessment Criteria (ACs), course-ware, assessments, questions, references and resources.
Back in 1994, I used Access as a user friendly front to Micro Management Expert – so workers could easily input maintenance data.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/23/05 11:45 AM
Posted by tjs - Utter Access Addict
Posts: 75 - Loc: Surrey, UK
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Our db was started in '93 using whatever version of Access was available then. I inherited this in 1999. We use it for most things:
Customers & contacts
Suppliers & contacts
Sales lead tracking
Inventory
Parts ordering
We upgraded to Access 2000 in 2000 but not any further. Fortunately, most of what I have to do it is just 'tinkering'! However, I wouldn't have been able to do much of the tinkering without the help of UA. Thanks to all of you.
--------------------
Unus est usquequaque in excrementum, tantum profumdum ut umquam varias
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/29/05 04:29 AM
Posted by irobbie - New Member
Posts: 0 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I use Access 2003 to maintain membership info for a country wide group of car clubs which all have the same interest - Cadillacs. The database is set up to hold data about the member, their membership status and the cars they own. The data is maintained by a 70 years old person with no training and very little knowledge of computers.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 06/21/05 08:23 PM
Posted by baldy_man - Utter Access Member
Posts: 5 - Loc: Durham, UK
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Mainly at work. Holding data on vehicle quality, we use one database to compile data from 5 other databases to create reports for all & sundry to view. My biggest headache was solved by UA & I will be eternally grateful. Now I pick up lots of hints by scrolling through all the various threads, as & when I have time.
--------------------
Beat me with a stick if I am being stupid!
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 06/25/05 11:45 PM
Posted by StewartTanner - Utter Access Member
Posts: 5 - Loc: Coffs Harbour NSW Australia
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I don't use MS Access as such, I just develop in it.
I've been making my living from MS Access development since 1996.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 06/27/05 01:12 PM
Posted by strike22 - New Member
Posts: 2 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use Access on and off to make smaller and less complex databases, such as small inventory, or for small businesses.
I use MS SQL and ASP as my primary programming/coding projects. Access is an occasional program, however it is a beneficial program for most databases with around <15,000 records, because it has a tendency to "crash". SQL has the capability of holding more records, however there is some more hardcoding required.
The options for creating a database, or managing a database are out there, it just depends on the user's capabilities and limits to determine which is best for them.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/12/05 07:39 PM
Posted by mrado - Utter Access Member
Posts: 5 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I am a teacher and use access for my records. I have developed a database for school reports which a school in England is using. I am developing another database for a different school to track pupil progress etc. but this is proving more tricky and testing my self taught knowledge of access to the limit. I am looking to develop my knowledge of SQL and VB so I can use code better. This site is fascinating and has helped me lots already.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/13/05 03:08 PM
Posted by gadgetgalky - Utter Access Addict
Posts: 137 - Loc: Kentucky
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I have written several simple databases with one to eight or so tables, forms, queries, reports, macros etc complete with switchboads over the years. Nothing complicated.
I have one medium sized database shared on a LAN where the location of parts are tracked. It uses several tables, queries, forms, reports and macros to accomplish this. There are many action queries involved. We also export data from this database to bump up to our production system when needed for reports. It's not too complicated and fairly stable. Data is imported from our main production system for the master tables. We utilize the switchboard to make it look like a system and easier to use.
I have another large database shared on a WAN that keeps up with inventory that is both owned and consigned and the activity between the two ownerships. Parts are requisitioned via a report from one building to the other. There are separate screens to accomplish in's, out's, move's, vendor returns, physical inventory, etc.
--------------------
Patty
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/18/05 02:06 AM
Posted by balboa - Utter Access Enthusiast
Posts: 38 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Professionally I have developed several databases for a few clients that have ranged from a Non Profit Service Organization (company wide database that stored member info, donations, ticket sales for events, numerous mailing lists, etc - my most ambitious project to date); A retail outfit that needed order entry and tracking (a majority of their orders were recieved by email and needed to be entered semi automatically, numerous reports including partial and final invoices); A training facility that needed to track students, courses, tests, payments, etc; and a few other small projects.
On a personal level I have built a financial database that tracks investments and liquid assets, with minimal data entry. Most dataentry is accomplished thru automated web queries. Reports and Charts have been standardized and are all push button.
I have had a few potential clients express interest in connection to the internet but have personally shied away from it as that is not my strong suite and have rather prodded them into more "mainstream solutions". All the normal training manuals deal with Access Pages in a very simplistic manner and don't talk about security and all the other stuff you need to know. Frankly it intimidates me a bit.
Love this site. Had a couple of your VIPs pull my butt out of the fire on more than one occasion.
Pete
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/21/05 12:37 AM
Posted by The_Catlady - New Member
Posts: 3 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use it to match up Excel spreadsheets for me! I just point it at a few Excel worksheets and then design a query to match them up. This serves 2 purposes: 1) it tells me, with a left outer join, whether data is missing from the second worksheet; 2) it enables me to quickly combine data from various tables at once and export the results into yet another worksheet for my end-user to see.
People I work with are amazed at the quick results I can obtain this way. Often I have previously queried (into Excel) the data out of our ERP tables, which is faster to do if you're only pulling out 1 to 3 tables at a time. Then I do the matchup with Access and send the user the results.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 08/05/05 07:47 AM
Posted by Linsky - New Member
Posts: 1 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I use Access at work for contacts and customer visits. I'm still really new to it though and find it exciting when I do the least little thing that actually works! Can anyone tell me if I can import a .dat file using Access? And since I'm really new to UtterAccess too, where do I post general questions...am I at the right place here?
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 08/09/05 12:49 AM
Posted by magicmusic - Utter Access Addict
Posts: 117 - Loc: Washington (state)
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
what I've learned has been by reading books.
I developed a db over 6 years with two people different IT people (who had major differences in how to accomplish tasks) to track students in our university choral program. It tracks their history - which ensembles they've been in, as well as the normal address phone, major. It inclludes their high school, since I often go out and work with high schools, it's nice to be able to say who came to our univ. from that school. Am currently trying to find a way to merge and send letters to each school - "We appreciate so and so being in our groups, thanks for your role in helping them as a musician, etc."
Other dbs:
*Repertoire used for Honor Choirs - when I guest conduct, helps me not duplicate, or gives ideas for other groups
*Single Copy file - over 6000 pieces of music, is tied to my CD DB (not very well at the moment) with what cd's those pieces appear on
*db for the material for my dissertation - Access generated a few reports that were included (on L'homme armé mass kyries out of the renaissance)
I'm working on designing a db to track a choir festival we hold and I run for 115 choirs from over 70 schools, 5 hired clinicians.
Entries, school info, ensemble info, clinician info, etc. I'm trying to do it "right", according to the "Database Design for mere Mortals" book I found and was impressed with.
I've already picked up more than a few tips from UA. This forum is a breath of fresh air - well run and full of knowledgeable people. I know how much I don't know when I read the posts of super-knowledgeable people (although, then I think of how many of them would know much about the L'homme armé tradition and feel be... no, not really - I just wonder why they'd want to
Gary
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 08/19/05 09:56 AM
Posted by kissinger - New Member
Posts: 1 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I built my own complete analytical accounting system under access 1.1, gradually upgraded it, it now runs under access 2000 and 2003 it is multi-currency (all menu's and reporting are in dutch) and it is only working for Belgian VAT reporting etc...
I also use access for administration of the club I am president of (ACVA), mailing lists etc..
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 09/13/05 09:34 AM
Posted by MrSiezen - Utter Access Ruler
Posts: 2067 - Loc: Den Bosch - Netherlands
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I've developed a system consisting of a frontend, backend, overhead and administrator. The frontend is used by a 12-lady sized call centre. It constantly provides them with new contacts to call, helps them process whatever they achieve while calling. The administrator prints letters, creates management information and creates a backup of the backend database, and this all happens around midnight.
The overhead system contains a management information system with charts and such, a CRM, and lots of other uses like the Call Center control board, which I'm pretty proud of. It shows exactly what everyone is doing, where they are calling, and thing like if they are on schedule.
When I'm done with it, and have polished everything out, it will be sold along with our whole company concept for international use... Pretty curious how much they'll ask for it
--------------------
UA Rulez!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 10/26/05 01:02 PM
Posted by China_Rider - Utter Access Enthusiast
Posts: 44 - Loc: Pennington, NJ
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use Access to: manage data, manage staff, manage resources, provide useable data from diverse and seemingly unrelated bits of flotsam, it's a reporting tool, a time keeper, production tool, statisical aid, I use it to house business info, telephone directories, mailing lists, client lists, indexable lists of every imaginable shape and size, it helps to organize the strucutre of life into relationships and create unity out of a vast void of chaotic digital static.
Cheers!
Percy
--------------------
Between the idea, And the reality
Between the motion, And the act; Falls the shadow
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/12/06 07:15 AM
Posted by dhassen - Utter Access Enthusiast
Posts: 29 - Loc: Preston, Lancs, UK!
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
a massively complicated school database for reports, acheivements, classes marks etc.
use VBA modules fairly exstensively
never used data access pages ever!
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/04/06 01:55 PM
Posted by StevieSue - Utter Access Member
Posts: 5 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I use it in career consulting to track client progress through the curriculum. This the first database I have actually persisted with anyway. Have used it hit and miss in the past as I learned the program. ~Stevie
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/05/06 11:21 AM
Posted by alancossey - Utter Access Veteran
Posts: 318 - Loc: Norfolk, UK
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Non-conformance reporting (with Excel and Outlook)
Mission critical production reporting and analzying using a local mdb to store data then append to an Oracle database (the local database is available even if the network is down) with Excel, Outlook and Oracle
Manhours, production and downtime recording
Telephone database
Safety showers database
Breathing apparatus database
Gunsmith stock control
Production control (with SQL Server back end)
Hotel bookings
Local history society document database
Risk analysis
Membership database
Accounts
--------------------
Alan Cossey
Premier Data Technologies Limited
www.premierdatatech.co.uk
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/16/06 05:38 PM
Posted by Brooklin - New Member
Posts: 2 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I designed a database I call LIST of EVENTS to enter information about individuals I find while researching our family tree.
By putting in as much info like dates of birth, death, marriages, and locations (including churches), it helps to isolate those who are likely to be our family. I've included spouses, children, and sources as well. I can do so many reports and using a wide array of search criteria it's been great. Each individual has his/her own ID number. Before there was an enormous list and no way to really compare the data.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/18/06 10:16 AM
Posted by FrixTheron - Utter Access Addict
Posts: 93 - Loc: Germany
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Build my first database to keep track of all the girls dated by my frathouse.... things like what they liked or disliked, phone nrs, pictures, ex boyfriends ect - A must have if you were looking for a date on a friday night....
later we added a module to store and retrieve recepies for drinks....
Now i use access to gether and compare time scheduling data and costing data stored on large SQL servers
Wish i was still in uni....
--------------------
"In an Infinite Universe, Anything is possible.. Even Survival" Douglas Addams
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/18/06 11:01 AM
Posted by GreenThumb - Utter Access Member
Posts: 9 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I started using A97 in 1998 at work to track employee hours on 3rd shift because HR was not there when the employees had questions about their hours worked or how much vacation they had available. Nobody wanted to wait a day to get their answer and neither did I. So my first, self-taught, database tracked the employees' start and stop times and their vacation usage and accrual (percentage of all hours worked including OT). It was quite a challenge to get the reports to show total hours worked and total vacation accrual because the time accruals would turn over at 24 hours and many employees hours spanned 2 days (start before midnight), and I found that the formulas that I used in Excel did not work the same in Access.
Next I built a db that would track labor productivity for 13 different assembly lines by line, shift, and model numbers pulled from an antiquated MRP system on a UNIX server. The data is then linked to an Accounting db that tracks "Standard Units" based on assembly time and is used for pricing new models. This was my first real challenge for a multiuser environment and dealing with strict data entry controls to prevent false data.
We also use Access for scheduling assembly lines, tracking scrap & rework, QA incident reports, internal ISO 9000 audits, tool calibrations, insertion machine setup changes where there are 75 different parts on a machine at any given time with over 3000 different parts available to go onto the machine. This db will tell the operator what parts to change from one assembly to another and what location they are in on the machine. It allowed us fleibility to change the locations on the machine to reduce changeovers because previous change overs were documented on paper. We used barcodes to read the part numbers and the locations on the machine to accomplish this.
At home, I have started using A02 to develop a db to track my wife's clients for her salon, their contact info, perms used, products purchased, and hair color formulations, and plan to include client appointment scheduling. My next upcoming project at home will be a db to track the different hybrids of Irises that I am growing along with pictures and potential new hybrids developed.
I have read a lot of the uses that have been listed and it has helped me form new ideas of what I can use it for. And some of the other projects here are so out of my league, We're not worthy 
I just recently found UA and to think that development could have been so much easier if I would have found you sooner. 
You have me hooked!!!!
--------------------
"I have come to realize that the second oldest profession in the workd (Politics) bears a striking resemblance to the oldest (Prostitution)" Ronald Reagan
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/28/06 11:31 AM
Posted by andy8009 - New Member
Posts: 0 - Loc: Cincinnati, Ohio, USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I use Access to pull data together for ad-hoc reporting from other RDBMS's such as Oracle, SQL, and Access. Links to tables in foreign databases allow me to pull data together. Mostly IT requests and effort hours stored in Lawson Oracle database glued to tracking data in Access.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 04/28/06 04:40 PM
Posted by ASMITH5RGV - Utter Access Enthusiast
Posts: 34 - Loc: South Texas
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I am an accountant that got my degree in CS in the late 80's. I programmed in Cobol and RPG for 4 years then got out of it and into accounting. I continued to dabble in Access but nothing spectacular. I recently started working for a large vegetable co. (Nationwide) who runs an old mainframe and uses queries with excel for their cost reports. I wrote a couple of easy Access cost reports and now I have been put into the DP department to move all the excel cost reports to Access! The problem is that I am not that good in Access. I went to Barnes and Noble, picked up a VBA Access book and am going from there. This site has been a godsend for me. I hope to be able to repay the many favors soon.
Al
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/21/06 11:16 AM
Posted by cableguy - Utter Access Guru
Posts: 750 - Loc: Las Vegas NV
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
at the moment im building a database for my [cable] company and learning the program at the same time. it seems im not the only one whom has learned this program as a result of using it for some task as an alternative to sloppy super-mathy spreadsheets.... so im just comein around in case things come up... so far i tend to be able to learn how to accomplish whatever task as long as i can take a whole day to figure out how to do it so i dont know if ill be around much but im glad i found a joint where people seem to discuss the program in such detail
--------------------
§ččĄä§,
Carl F. (aka Cable Guy)
Business ops super-coordinator/admin!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/26/06 11:19 AM
Posted by AQM_UK - Utter Access VIP
Posts: 4339 - Loc: Suffolk, England
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Hi Gord.
I used to use Lotus 123 and realised when I got into access that trying to write databases in a spreadsheet in like banging your head against a wall, day in day out.
When I was with my previous company, I wrote loads of application.
Some were for data capture, manipulation and reporting. Some were just for reporting data from an ERP system.
The bigget project was an 8 month write for a contracting process.
This involved gathering global data of purchases, and then based on the category that the user was working one, it would prepare an RFI (request for information) from plants globally and based on their answer may request further information.
This would then be analysed by Category managers, who would send this to vendors to bid on.
The vendors bids would be analysed by the system and contracts awarded from here.
This was then prepared into a contract for the vendor to sign, entered to the ERP system and savings calculated from here.
As a result, I got promoted.
Others were like an archive database I wrote to keep track of documents in boxes, generating a box number for the box to be archived off site.
Worked great as long as you did not have a Bozo who entered data like "Philip's papers, Various" Chocolate teapots come to mind here.
I have written a customer database for a water softening manufacturer, so he can contact customers when it is time for then to have a service. This allows all callout paperwork and mailshots to be eaisly generated, and any callout for repair or serice only takes the user 4 key strokes to add the data. My client is over the moon about the tool.
Outside work I have written membership database for groups I belong to, and a project managemnt tool for planning the timeline and events needed to be done when putting on a play.
All great stuff.
What I do notice is that I turn to access for almost everything and stay away from excel.
I was, until this year limited to A97, but now use A2003.
I do not use DAP yet. Probably because I know and can deliver using forms and reports so have not thought about them yet.
Not sure if this is what you wanted but.
Jim
PS Gord, the new search and disply stuff is very cool.
--------------------
Insanity - Doing the same thing and expecting a different result - Albert Einstein
Normalis(Z)ation here
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 09/21/06 04:16 PM
Posted by fairyvicki717 - New Member
Posts: 0 - Loc: Bradenton, FL - uSA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I'm new to the forum, but thought I'd put in my 2 cents' worth. I previously created a database to manage the legal cases at a hospital. Currently, I'm attempting to put together a database to record the purchase orders that we generate - items that we buy from our vendors. Unfortunately, I'm having problems with it, as I've never created this particular kind before. Any kind of help would be wonderful! So far, I love this forum!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 10/02/06 04:49 PM
Posted by Dinghus - Utter Access Addict
Posts: 157 - Loc: Hawaii
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use it to beat cockroaches to death. 
Primarily I use it for small websites. But lately I've found a small niche of people in LARGE companies that want quick Access db's for things like attendance monitoring. The company IT depts don't want to be bothered with such small projects so I get to scarf them up. Had to get back up to speed since the last time I created Access applications with forms and reports was with Access 97. Just a tad different from 2002/3 which most of them have.
--------------------
I hate computers
Destroying Your Fear of the Web
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 10/19/06 02:14 PM
Posted by cbteng101 - Utter Access Addict
Posts: 155 - Loc: Massachusetts
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Strictly business. Have used access for approx 10 yrs. Developed programs for Quality Assurance .
Reject/Corrective action , Vendor Rating, Customer Drawing/Specifications, Metallurical/Welding Inspection, Test Data report databases.
Recent developments have been Job Costing , Sales/ Quoting databases.
Being a self trained programmer, Mech Eng degree, I have found a lot of info in this forum to be a great asset.
Keep up the good work.
--------------------
I never drink alone. I have to buy all the rounds.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 12/04/06 03:41 PM
Posted by jltaylor - Utter Access Member
Posts: 14 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
If you can believe it, I work in I.T. kind of a help desk situation and I took an Access class a long time ago but honestly I have never built anything that worked. This is something I would like to explore a little more but because of lack of time, and what to come up with to try to design so lack of ideas, I haven't attempted anything yet let alone visual basic. I guess I just need to get in and try something. How did all of you start? Ground zero in teaching yourself? Books? Out of Interest?
JT
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 12/05/06 12:06 AM
Posted by datAdrenaline - Utter Access VIP
Posts: 11827 - Loc: Evansville, IN And Purcellville, VA : USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Out of need and interest ... My employer needed a lot of informaton analysed, so I wrote a Lotus 1-2-3 Macro to do it ... My Dad needed a payroll program, so I wrote it in Alpha 4 (DOS dbase compatible program). Basically most of my learning came from having a project to do, then using the proper tool to do it in. My employer sent me to school for ~1yr to learn a thing or two about embedded controllers (Engine/Transmission Controllers). The code used for those was a mix between C, Modula-GM and Assembly. Now that often presented challenges! ... It was hard to develop a program which did not have a user interface!!! ...
--------------------
Brent Spaulding | datAdrenaline | Access MVP
Pay it Forward ... It will enrich the lives of many!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/02/07 10:36 AM
Posted by MikeJ - Utter Access Veteran
Posts: 222 - Loc: Quito, Ecuador
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Mostly in law enforcement. (But I did do one for a parish I used to attend -before a transfer to another place. Getting one on the good side of the book)
I have been doing this for awhile and feel dumber ever day when I read of the creative thngs being done with access. Saw the NYPD switchboard today. Never thought of that...and transparent forms...the list goes on. Think the search form is ahead of sliced bread.
Have some concerns
security. Hear a lot that access is not secure.
Number of users and record locking. Seems to limit the scope of access.
The web. Access has gotten some negative reviews for web use. But hope it isn't so. In a developing country the web based approach would save a lot of headaches...and money.
UA is great. The responses are timely and the help outstanding. Without UA I would have given up a long time ago.
Mike
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/04/07 09:45 PM
Posted by bobed - Utter Access Member
Posts: 15 - Loc: Michigan
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Simple to moderately complex applications for work (before I retired) myself, family and small business acquaintainces. Most recently developed a player/registration application for the Michigan Thumb Area kids athletic league, which my daughter administers for fun. This is the characteristic application for which Access was created: players, parents, teams, coaches, schedules, sponsors, advertisers, uniforms, equipment, multiple sports, 100 specialized reports and forms, several tough queries, lots of automation including realtime Saturday morning registration for 50 kids, fee collection and management. A really fun project for me, including user documentation.
I also proved to myself that remote Access development is perfectly viable. My daughter lives 60 miles away, and we exchanged evolving requirements and evolving code via email and phone over the 3 month development period.
As an Access devotee, now retired and with time available, I would do projects and or assist on a cost plus basis because it is a hobby for me. Surely there are those who need database solutions, often without knowing it and perhaps daunted by the fear of high cost. Over the years I have helped many acquaintances find the right approach just by knowing when and how to apply DBMS.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/20/07 11:04 AM
Posted by The_Catlady - New Member
Posts: 3 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use Access strictly as a utility for reading, matching up and/or merging either text or Excel files (or both), and then exporting the results (usually to Excel.)
It is fabulous at telling me which records do not exist in both of 2 datasets. And using Link Specs allows me to take a very long text file and export it perfectly to Excel time and again while only having to set up the columns for importing or linking just the first time.
And it allows me to write short adhoc queries against our Production database tables so that I don't tie things up over there, and then to put them all together into a single dataset via Access linking them all together and then exporting the results.
Very cool!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/27/07 11:25 AM
Posted by mbhknight - New Member
Posts: 0 - Loc: Croydon, Greater London, England
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I have used Access over many years mainly for personal databases for example.
One of my hobbies is genealogy and I have an access database of all towns villages and cities in England, Wales and Scotland and I'm just building one for all of Ireland.
I also use access to keep control of all the junk mail I get. I mail the sender asking them to remove me from all their mailing lists and databases and if they still persist I threaten them with action under the (UK) data protection act giving them exact details as to when I asked them to remove my name. As a result I've gone from getting at least 5 or 6 of these irritating letters a day down to about 1 a month. Try it yourself it means you only get mail that you want and not lots of annoying sales tripe.
I love access and at the moment I'm building a database of all my jazz records with details of bands performers etc.
I'm sure I'll find other uses for it but I'll also be investigating MySQL for online stuff.
Keep smiling 
--------------------
Mike Knight
info@InstructiveToys.com
Website www.InstructiveToys.com
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 06/29/07 08:02 AM
Posted by LReichel - Utter Access Member
Posts: 10 - Loc: South Africa
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
We use ADPs connecting to MS SQL only (both SQL 2000 and 2005 is supported).
We have a full ERP solution for our non-profit organization. It has one main ADP, and 22 child ADPs. There are about 2,000 forms and reports in these ADPs. In the SQL database we have 1,500 Tables, 1,000 views and 7,000 Stored Procedures. It is installed in our branches in 120 countries of the world. The UI is translatable, and we have a full Spanish version and limited translations in many languages like German, Japanese, etc. Branches can add their own translated text. We have mangaged to develop very tight security on the ADPs. We probably have around 4,000 users around the world using this software. In the one of the larger branches we have hundreds of installed users with about 300 users logged on concurrently.
No, its not for sale (nor free). It just proves the power of ADPs as a development tool (and we hope Microsoft does not ever ditch it). Using Access relieves the developer from intricate developer language issues and long discussions about user interface options. He can concentrate on the business needs.
--------------------
Lionel
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/02/07 12:58 PM
Posted by RicardoSR - New Member
Posts: 1 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Hi,
I used Access since 1993, today I'm use Access 2007 and I'm very glad about the current Access Developer Extensions and the Access Runtime will be free but I'm disappointed because its not ready the Runtime yet.
I use access to develop accounting and administrative tasks like:
- Payroll
- School Control with calendars and time sheets.
- Invoicing
- Taxes
- Production and costs systems
- Logistics
- Registerings systems in conventions, congress, expos etc.
I consider Access very versatil and very fast to develop sirius database applications, as access developer I mainly focus on the logic of the bussines not only in the complex programming with toos like C# or VB. The simple things always be better.
Ricardo Sanchez Rodriguez
México City
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 08/08/07 11:34 AM
Posted by chickdj - New Member
Posts: 0 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Hi,
I started to use it when Office XP came out, and I discovered that I could use it (and a purchased active X control) to generate barcodes as we needed them. That opened the way to solve a business problem, and I hav'nt looked back!
I work in a multi-site manufacturing company, and we use access based "departmental apps" to solve a number of versatility issues that we have with the corporate systems (they are not versatile!)
I now have all these in operation...
- an application on 10 heat treatment lines (in UK and Belarus) generating labels and capturing output data...
- another application creating shipping data for customers, drawing from the same database...
(Both the above draw data from an AS400 system via ODBC linked tables)
- one that generates production order documentation in Russian for the Belarus plant
- one that manipulates quite big volumes of raw sales and stock data, transforming it into an SQL database ready for reporting and Data Cube creation.
- one that manpulates raw data from an RFID access control system to produce reports
- one that we use for managing maintenance requests on the shop floor
- and my latest creation builds on the wonderful Phidgets interface kits, capturing a host of real-time machine data, and feeding back performance data to operators and management alike. I'm especially proud of this one.
In many ways, it's a shame we have had to resort to home grown solutions, but I'm really pleased to have had the opportunity to solve real problems, and to help to improve productivity!
In addition to all the above, I regularly turn to Access to handle large scale ad-hoc data manipulation tasks, and complex simulations that Excel cannot handle very well.
I have just started to look at Access 2007, especially the runtime edition.
This sounds like an absolute blessing, and we are making our first live experiment (with one of the above apps, converted to 2007) tomorrow.
Best regards, Dave
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 10/01/07 12:45 PM
Posted by gruverdk - New Member
Posts: 0 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I use Access as a front end to manage and manipulate data which is stored in SQL databases on a SQL server.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 10/04/07 11:47 AM
Posted by lasgsd - Utter Access Member
Posts: 5 - Loc: SE Wisconsin, USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
My main job is teaching co-workers to use the MS Office products - Word, Excel, PowerPoint and Access.
I've been using Access since the late 1980s / early 90s - used Paradox first. I helped develop a corprate travel data management system which I then went on the road and trained the customer on how to us it.
I've gone from developing to training to support, back to developing, back to support and finally, now, I'm back in training (which is what I love).
I help co-workers develop databases in Access to help them with their jobs. Most of the projects are small, single user projects. I try to teach the users DB skills as I help them create their programs.
I use Access for many personal projects. My husband and I do pet photography and I created the DB we use to track customers and their photo orders.
Lauri
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 11/22/07 05:41 PM
Posted by cassidym - Utter Access Addict
Posts: 141 - Loc: Virginia
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I support an office of about 150 people; none of whom has the remotest idea how to design databases using Access. In short my main databases are:
- Personnel DB
- Travel DB
- Tasks DB
- Training DB
I have a bunch of other ones but these are the main DBs and my customer loves them. I split the Travel DB into a front and back end thus allowing each employee to log their own travel and vacations. In fact, got the idea of how to do that on this very site.
And here's a question: Can I be to into Access? Why just the other night I actually dreamt in VB. In my sleep addled brain I dreamed that the user had asked me to program a report format to make the letters appear in vermilion under certain conditions. Problem was I wasn't exactly sure what vermilion looked like so instead of writing the code as RGB(,,,), I just wrote vbVermilion. Do other Access nuts have dreams like this? Maybe I should get into Excel. No, I like Access too much.
--------------------
Mike Cassidy
SELECT * FROM users WHERE clue > 0: Zero rows returned
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/10/08 02:33 PM
Posted by Hottie7579 - New Member
Posts: 1 - Loc: Dunedin, FL
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
I use Access to create reports for our Customer Database at my job! I use the queries to generate information based on certain needs of the managers! in my old job i used Access to enter in Sales Leads and enter in Follow ups for the sales staff. We also used it to keep track of the Customer's products. It was our Main Database for our customers!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/13/08 10:29 AM Attachment (27 downloads)
Posted by CVFoote - Utter Access Enthusiast
Posts: 49 - Loc: OHIO
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I recently designed a database to prepare rate sheets for the insurance company I work for. Prior to my idea agents would have to find the appropriate Excel Spread sheet for the payroll mode, then find the worksheet for the industry code, then pick the items they wanted by cut and paste or deleting those they don't want.
I created a great interface, screenshot attached, and agents were very excited about the application. I made the mistake of showing my idea to corporate IT and in January they are releasing their own version. Of course I am just a little dissappointed because I thought I might make a little side income from the hours I spent on it. Still, I also learned a lot building the database.
I am always looking for new ways to use Access, design forms and reports and just have fun with it.
Carl Foote
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/16/08 10:32 PM
Posted by edgeare - New Member
Posts: 0 - Loc: Malaysia
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Why I use Access Database? I use this database for my organizations to store what frequencies assigned to them.... only simple database...
--------------------
...scientia est potentia
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/18/08 01:45 PM
Posted by jamesfred - Utter Access Addict
Posts: 133 - Loc: Tennessee
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I'm working part time in the Plant Services department of a university. I've been using Access to track maintenance records for HVAC equipment associated with all buildings owned by the university: academic, administrative, support dept facilities, dorms, rental housing, and rented commercial property. This includes a regulated filter change schedule which determines when filters should be checked, changed, etc. (some for health reasons such as food service areas and health center). We archive these records on an annual basis to track the technician's conformance to the schedule.
Another db tracks work performed on campus locations showing labor and materials used. This one is by far the most complex and challenging since it requires downloading from another system to an Excel spreadsheet, manipulating the data using Macros and then uploading to the Access db. At any given time a work request can be called up and the requestor can see progress/cost to that point in time. Another handles invoicing for work and materials used by outside entities (sister organizations). Another database tracks faculty/staff and student rental units (not dormitory).
Reports generated by each db are submitted to a central accounting office for posting to the general ledger. The accounting package won't reliably accept an upload from Access.
I appreciate the forum and wish I had discovered it sooner.
--------------------
Jim O------
A clear conscience is usually the sign of a bad memory.--Steven Wright
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/04/08 12:35 PM
Posted by Scarpo80 - New Member
Posts: 4 - Loc: London, England
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I joined a small but fast growing business 7 years ago to run their HR dept. We had about 500 employees when I started and all their info was kept on an Excel spreadsheet. Seeing the limitations of this as we grew I put in place an Access database.
We now have over 3,500 employees and, due to the high turnover of staff in the retail industry in the UK, records on over 15,000 people on this same database all with their employment, training, salary and personal data stored. It works really well and has cost us nothing. Plus I can continue to develop it and add to it in a way that suits us. It's only limitations appear to be what I'm able to learn how to do and I nearly am always able to find a way around a problem.
I've had salesmen come in from bespoke HR software companies quoting Ł30k plus for their product only to look at the one I've set up and admit that theirs can't do it any better (although perhaps a bit tidier; my back office stuff has got a bit messy).
I'm very proud of it and it shows how powerful Access can be. I'm also entirely self-taught (books and messing around). I think Access is a great bit a software and certainly nothing anyone with a bit of IT savvy should be afraid to try out.
I've just recently discovered the forum and it's been incredibly helpful already.
Scarpo80
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/20/08 06:43 PM
Posted by OldBirdman - Utter Access Member
Posts: 10 - Loc: Oakland, CA, USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I use it for personal use, altho I may have a business interested in my current project (will need touch screen).
I am a birder (aka bird watching), and I want to keep track of what I have seen, when, and where. This is a very similar problem to a standard business application, with products (bird species) and customers (locations), where a purchase order (sightings at location on a specific date) may contain a list of products ordered (birds seen) on a specific date.
My current project is to access a database with just the mouse, and with larger, more 'user friendly' controls than Microsoft supplies. Data entry will of course require the keyboard. Navigation controls, the close button, and scrollbars are too small for older people. Also, it takes too much effort to find a record in an alphabetical list once that list is over 25 rows. There are over 10,000 species of birds, and ~1500 start with "B".
I am self-taught. Most of the books I've tried were worthless, so I learned using Access 'Help' and the internet.
OldBirdman
--------------------
OldBirdman
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 03/28/08 01:48 AM
Posted by car313 - Utter Access Member
Posts: 10 - Loc: Tirupati, AP State, India
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
My situation is very similar to Ernesto's. Especially about the piracy and about difficulty in getting data entry done.
I primarily use Access for maintaining simple static data related to my work with STD/HIV/AIDS. (That would mean Sexually Transmitted Diseases/Human Immuno Virus/Acquire Immunodeficiency Syndrome for people from other areas of work). No need for relationships, junction tables, VB code and macros, and select querries. So I can say I am perhaps using about 10% of the capabilities of Access. Apart from that I mainly use the program to learn it as thoroughly as I can.
car313
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 05/23/08 09:41 AM
Posted by jamesfred - Utter Access Addict
Posts: 133 - Loc: Tennessee
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
The DBs I've developed consist of several. On is for scheduling/tracking filter changes for over 700 HVAC units affiliated with our University. This had originally been tracked using Excel which contained monthly tabs showing units (along with size of filter and date changed) according to a pre-determined need. Very cumbersome. Now tables help generate reports with coded times for groups of units to be serviced in addition to a pick-list of what tech needs to take with them for that particular group. When tech has completed each group a date is assigned for time of service. A report can be generated to monitor how well tech is doing job.
Another db tracks faculty/student housing rentals showing current/past occupants as well as any maintenance required in the unit's upkeep (captured through use of a subform). This db also contains rental rates per unit, contact information of renter, move-in/out dates, particulars about what unit has (number of bedrooms, heat source, sq ft, etc.).
Yet another db tracks all work orders for any maintenance performed on campus as well as material costs. This db contains stock room inventory table, work order detail (hours/period work done) table, customer information table for items purchased by staff, affiliated entities, invoice header table, invoice detail table.
Each db is designed to provide reports/forms for looking up any type of information a supervisor/director wishes to view for any type of function be it productivity of an employee, cost of maintaining a piece of equipment or rental unit, etc. This is what makes the versatility of ACCESS so great. Just about any question you can ask can be answered somehow. Also UA has been most helpful when I've run into a problem for which I couldn't find any other source for a solution.
Thanks for being there.
--------------------
Jim O------
A clear conscience is usually the sign of a bad memory.--Steven Wright
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 06/11/08 10:55 AM
Posted by Coulsdon - Utter Access Member
Posts: 7 - Loc: London, UK
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Hi folks,
I am the Site Manager for the Coulsdon High School (soon to be Coulsdon Academy). I've been tinkering with Access and Excel over the years, and now I think it's time to use them in earnest.
I have a 'Master' Access 2003 database, where I keep as much information about what I do in there, such as Lettings Contacts, Furniture Stock, Key List, etc. etc. They're basically all tables, but no real purpose other than to store information. However, I am now in charge of maintaining the Portable Appliance Testing , or PAT, and have started to develope a database for the purpose of keeping records and issueing of reports; consisting of an Inventory and sub-forms for the recording of test results.
At the moment, it is about 90% to my likeing, but I have run out of steam (halfway through the Access 2003 Bible, and I can't see for looking!).
I was just wondering, if any kind soul out there had any time on their hands, and the enthusiasm to help me complete the project, I would be eternally greatful?
Cheers... Robert
--------------------
** I can't make up my mind whether I'm indecisive, or not! **
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/09/08 02:25 PM
Posted by johnharveyk - Utter Access Veteran
Posts: 248 - Loc: AZ
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Started with '97 in 1998.
We sell glasses to restaurants, and restaurant supply business. Access is the backend DB for Orders, CMs, POs, tracking and customer research applications. We've about 15 different programs, some of which are pretty esoteric, such as researching the sales trends of particular items to particular customers, or categories of customer.
As we are adding product images to many applications, we are bumping the 2 gig limit. Therefore, we'll probably convert to SQL as the back end. To that end, I'm converting queries to T-SQL as time allows.
Access has its quirks (I'm still PO'd about the printing "improvements" in 2007.) but it has allowed a one person part time programmer to deploy some pretty sophisticated applications and modify & update them fairly easily.
UA has been a real help to me. While I've never actually solved a problem by posting a question, viewing other's issues has given me innumerable tips and help (that darn printer setup issue for one ((said I was still PO'd))). While I find few questions where I think I may contribute, and I'm not always sure that I can really help, the occasional "Thank You" response does really validate my efforts and brighten my day.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/23/08 01:16 PM
Posted by JimBud - Utter Access Addict
Posts: 58 - Loc: Canada
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I have volunteered for the non-profit organization Make-A-Wish of Southwestern Ontario (kid's with a life threatening illness) - now in my 16th year.
Back in 1995 - I started to create a database for their needs as a non-profit organization which at that time no other chapter in Canada had a database system and the London chapter was using WP51 and Lotus 123.
I had no experience in databases or VBA so this was a learn as you go project - beg, borrow and steal what ever I could to make it do what ever was required. I basically was making changes to accommodate their needs as they arose.
I was finally able to clean up the database this year which enabled me to run the debug compiler and make a MDE file which made me feel pretty good as I had'nt been able to do this before.
Thank's to the UA forum and the experts - I have been able to make improvements to some of my VBA code making things work better and also improve the appearance of reports and forms.
This site has been great for me and I hope it continues - I have found most of the members and VPs are considerate of VBA in-experienced mess arounds like me - and I certainly appreciate it.
JimBud - a getting old cranky man with soft heart.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/27/09 07:09 PM
Posted by doris7264 - New Member
Posts: 2 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Essentially, I build Access databases when data volume or complexity outgrows Excel spreadsheets.
I like the fact that Access will store the query definition instead of the results, particularly parameter queries. The query definitions can be much more complex than in Excel, as well. If a piece of information is the result of a calculation, Excel would require the formula on each line; but in Access, I can just have the value calculated when I need it. An update query is a lot faster and more trustworthy than a Ctrl-H search and replace, too. The analytical possibilities are so much better.
At the same time, an Access database remains within the reach of the end-users, not the IT department that might get around to making requested modifications someday, maybe. Hyperion is a wonderful tool, but it's too sophisticated for most of my clients to do day-to-day or ad hoc analysis.
Recently, I built a database to track capital lease contracts for a client. Since a single customer may have multiple leases, and a single lease may cover multiple machines, and a single lease may have different payment amounts over the term of the lease, I split the data into several related tables. I built input forms and menu forms for my end-users, so they never have to go into the Navigation Pane. With end-users who don't know Access, it's much safer. The company upgraded from Access 2003 (or earlier on some machines) to Access 2007 in the middle of the user acceptance testing, so we basically had to start testing all over again. 
I originally started programming Access in the mid-1990's under Windows 3.0. We had just created a data warehouse with the daily report information from all our subsystems, and I didn't want to have to enter data from paper reports into a reconciliation spreadsheet. So I built Access databases linked to the data warehouse by ODBC, and queries to aggregate the detail data. Then I exported the results from each subsystem into Excel format and created reconciliation spreadsheets that could read from the download files and compare amounts. For example, general ledger balances against loan subsystem totals. Having the ultimate reconciliation in Excel allowed the reconciliation accountants to enter adjustments and explanations for reconciling items. In that version of Access, the reporting capabilities weren't that good, as I recall. You'll notice, that was when I went from doing reconciiations to creating tools for other people to do them. Yay!
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/09/09 11:07 PM
Posted by ClintC - Microsoft Corp UtterAccess VIP
Posts: 186 - Loc: Redmond, WA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
here is a blog post of some of my favorite quotes and a tag cloud of the key words from this thread. I really enjoyed reading this thread.
--------------------
Clint Covington
Senior Program Manager Lead, Access
Microsoft Corp.
http://blogs.msdn.com/access
|
|
● Re: What do you use Microsoft Access for? [Re: ClintC]
Posted on 02/10/09 01:07 AM
Posted by ClintC - Microsoft Corp UtterAccess VIP
Posts: 186 - Loc: Redmond, WA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
BTW - the above tag cloud was generated using www.wordle.com. Handy little tool...
--------------------
Clint Covington
Senior Program Manager Lead, Access
Microsoft Corp.
http://blogs.msdn.com/access
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/10/09 04:38 AM
Posted by paulsh - New Member
Posts: 0 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I am a self-taught Access developer.
I run a volunteer run company delivering free 5KM running events accross the country every saturday. Today we have 12 events taking place each saturday and delivering 1500 results (runners). I've been doing this for four years now and we have ammassed 100,000 records. Each result is stored and reproduced on the web giving the athlete access to their entire running record with us.
Each event is self contained and almost completely self sufficient. We have deployed an Access solution whereby the event capures and manages their own results, sending the final result set to the HQ for processing.
Take a look at www.parkrun.com and go to the results page for any of the results to see whats been achieved.
Its been an amazing journey. I started out as a luddite and now i'm a fairly accomplished progreammer.
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 02/25/09 09:00 AM
Posted by graffy76 - Utter Access Enthusiast
Posts: 48 - Loc: IL
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I'm entirely self-taught. I'm a Civil Engineer in the transportation field (I work for a state DOT). At work, I've used access for several things:
An analysis tool which determines the median unit price of road construction "payitems" (like guardrail, asphalt, paint striping, culvert pipe, etc.). It uses a database of over 500,000 records which are retrieved over the web (I start an Excel instance from within Access VBA to automate web data retrieval). The data is previous bids made by contractors on state projects over the last eight years. To analyze the data, I borrowed the analysis algortihm from a couple unrelated Master's theses on K-Means data clustering and coded it in C++. Then, I call the DLL from within Access and it returns the "most common" median prices observed for the selected payitem. It works perfectly. The tool also charts median prices for visual inspection.
A database which tracks proposed road improvements for the area which I oversee. I developed a way to take pictures of a location and add comments / captions on my Blackberry, email it to myself, and then have Outlook automatically append it to an Access database. I couldn't use Access 07's data collection because my blackberry doesn't support HTML tables nor does the built-in data collection feature allow you to add data to an attachment field. So, I wrote my own system, using custom tags in the email body to denote each field. I plan on using my custom email data collection system with some Access 2003 apps I'm working on for my church.
A databse which tracks proposed improvements to buildings in the maintenance yards I oversee. I used several Access 07's "Attachement" fields to create albums of pictures taken of the facilities. The database also takes data and automatically updates a Word form stored on the local intranet. When it's done, the database can take the Word form and the pictures and create a PDF "package" that we can submit to our central office for their approval of the proposed improvements.
A database which tracks salt usage for snowplows. Since salt was so expensive this year, the onus was on us to track it better. I wrote a form that every plow driver fills out at the end of the shift, recording how much salt they spread and miles driven. I then enter it into a database I quickly wrote to track it. Still under development, it promises to give us great data on the ways we use salt and where we tend to use the most.
In the end, it's always been a "seat of the pants" development effort. Most of my information has come from various websites, not the least of which is UtterAccess.
I'm always curious to see what MS will do next with Access (i.e., in 2007, I think the attachments object is a great idea, but the split form is a dud). Most of the time, however, I find myself writing custom solutions to get what I want.
To the credit of MS, I've found that if I can imagine it, I can code it...
|
 |
● Re: What do you use Microsoft Access for? [Re: ClintC]
Posted on 02/25/09 02:38 PM
Posted by Willem - Utter Access Veteran
Posts: 463 - Loc: Amersfoort, The Netherlands
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
...small typo.. it's http://www.wordle.net/
Nice word-scramble though!
--------------------
Cheers,
Willem
Cash is King!
|
|
● Re: What do you use Microsoft Access for? [Re: ClintC]
Posted on 05/13/09 12:50 AM
Posted by Omega3817 - New Member
Posts: 0 -
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
Our State database has some serious deficiencies and limitations so I have built several databases to fill our needs and expand our capability & efficiency. One is a supplemental Booking & Inmate Records database that allows us to track way more data and generate much more useful reports (including fingerprint & photo cards) than the state system does. It is also much more user friendly and simple to use. Another is an Inmate Time Accounting program used to calculate complex time sheets that involve multiple sentences, prior service credits, good time awards, parole eligibility, and much more. Another is the Incident Report program that I developed to streamline the process for both the report writers, supervisors, hearing advisers, Records Officer, and Disciplinary Chairman. It has a lot of automated features and generates all required documents with little effort. I also created a Chronological Log in Access to replace the manual paper documents that we used to use. One more is the Inmate Worker database that I built to manage our prisoner workers. It tracks their assignments, worker history, and payroll, among other things. I have also created a number of form generators in Access, such as Warrant Request Affidavit software, Petition to Revoke Probation software, to name a couple. Then there is an Inmate Classification program that calculates and generates documents after processing complex data after very simple input. I have also created databases for capturing Shift Supervisor Reports, Administrative Segregation Admissions, Special Incident Reports, Security ID Card creation & documentation, Shakedown Reports, Prisoner Count Records, and Firearms Training & Qualification and Weapons Maintenance & Management Records. All of these not only provide for the required logging, document generation, and record archiving, but many statistical reports as well. I have made a number of other smaller programs too but I think you get the idea. I first began programming with Symantec's Q&A dos database but later discovered MS Access and never looked back.
|
|
● Re: What do you use Microsoft Access for? [Re: ClintC]
Posted on 07/01/09 04:29 AM
Posted by the_captain_slog - New Member
Posts: 0 - Loc: England - UK A small island north of France
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
To make my life simple - started a new job with the NHS (UK - National Health Service) in a small information dept with varying staff skills. They like to do a lot in Excel MANUALLY!!!! I am lazy and dont like the repetitive, sort on this field , delete if equal to XYZ etc. that we do for monthly reporting. So I use Access to automate what I can and sometimes it works first time. I am self taught and rely greatly on sites like this to solve those little conundrums Mr Gates throws at us with a sometimes non helpful help system. Keep up the good work and thank you all in advance for all the help I will receive.
--------------------
I am no wizard but I can spell
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/08/09 06:36 AM
Posted by bohemian9485 - Utter Access Addict
Posts: 153 - Loc: Philippines
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Our office uses FE/BE type database developed by our head office for project monitoring. Some reports can't be produced from our FE interface, even though the data are there. I have to use spreadsheet to produce those reports. I am really a "lazy" person, so I decide to learn the ins and outs of Access to help me on my work. That was 7 years ago and I never looked back since. I got hooked you can say^O^
--------------------
Rey T
The most important thing in life is to learn how to keep your body and soul together<img src="/forums/images/ic
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/08/09 09:57 PM
Posted by jurotek - Utter Access VIP
Posts: 1418 - Loc: NV
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
Hi,
Some of the apps I developed in past were for:
DataCollection and SPC (Xbar and R and p charts, histogram)
Tracking Hardware, Software and IP Addresses
Incoming Calls Management
Flower Shop
Bakery
Used Car Dealership
Inventory
Time Card and Payroll
Warranty Tracking
Investment Club
Little League Softball
Calibration of Measuring Devices
Kennel Club
Currently working on ISO,AS and TQM DB for manufacturing co.
Used Access as FE to MySQL, SQL Server and SyBase to create custom apps.
--------------------
"Perplexity is the beginning of knowledge". Kahlil Gibran
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 07/13/09 03:39 PM
Posted by nkstrou - Utter Access Addict
Posts: 112 - Loc: Land of Enchantment, USA
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I am working on 2 DBs at present, one for tracking software tests and their results, and the other one for tracking/categorizing various people associated with a non-profit charity.
I have seen Access used for tracking guest visits (at a reception station) and also for tracking some kind of manufacturing tests.
nkstrou
--------------------
An imprecisely defined problem has an infinite number of solutions. Unfortunately, only one solution will typically satisfy the person asking that the problem be fixed!
|
|
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 09/17/09 12:45 PM
Posted by mdSheley - Utter Access Member
Posts: 11 - Loc: Currently Ft. Knox, KY
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I've been developing in Access since it was born.
Anyway I have one application written in VB 6 with Access as the backend. this is used by ship chandlers to run their business. Once client has over 45 simultaineous users and the database itself is close to 1GB. Operates just fine. I would like to see a bit more speed on local area network side but works fast on a Terminal Services connection. This application has hundreds of talbles, queries and reports.
Next I write software for the US Army using Access. The reason for this is because every Army computer has Access and if I were to write it in VB6 or VB.NET I would have to have Army wide approval (a process that takes months, if not years). Anyway this databse automates may functions from a Bde on down such as Alert Rosters, Soldier information, aviation including flight hours, tracks work time and flight time, etc, etc.
I've never had many problems with Access and found I can pretty much automate anything. I don't use Access relationship builders at all. I use queries and code to manage all table relationships.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 12/16/09 09:36 PM
Posted by roncoscia - Utter Access Member
Posts: 11 - Loc: San Francisco Bay Area (CA Delta)
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I have built a client-tracking, statistical reporting & invoicing system which I use to run my data conversion/enhancement consulting business. Unfortunately, I've never had (taken) the time to learn the system properly (I'm self-taught) so I constantly struggle with what I'm sure are relatively easy tasks, whenever I add functionality. I'm still using Access 2000.
I also run a small rural water company and use Access for member records and billing.
At home I use Access to maintain my Christmas mailing list/labels.
--------------------
Ron Coscia
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 12/24/09 10:47 AM
Posted by candym - Utter Access Member
Posts: 17 - Loc: Buffalo, NY
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
|
In my previous job, I developed programs for communications requirements, military training tasks, IT help desk (prior to using Remedy), IT custodian training and several other small ones. Currently, at my new job, my fellow financial co-workers can create a table, a query, and maybe a report or two. Most use only wizard. They all have their own copies of the same data. Alslo, being finance, there are "millions" of Excel spreadsheets containing the same data over and over again. I am creating a reference database with all the definition tables that are used across the departments and building processes to enter data into Access and then export (or connect) to Excel to get the needed cross-tabs or charts.
|
 |
● Re: What do you use Microsoft Access for? [Re: ghubbell]
Posted on 01/07/10 02:08 PM
Posted by vspssdheat - New Member
Posts: 4 - Loc: Virginia
Forum: UtterAccess.com News
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
I have taken the MS Event Management template back about 2003 and adapted it for law enforcement training here at the VA State Police Auto Theft and HEAT program. I have created many new features, including school student registration, printing school name tags, lunch tickets, student contact lists and registration confirmation letters.
Also use Access to track Auto Theft Hotline calls and other monthly reports on agents' activities.
|
|
|
 |
| Navigate |
|
|
|
