Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ News _ What do you use Microsoft Access for?

Posted by: ghubbell Jan 29 2004, 10:51 AM
If you have a moment please.
Gord thumbup.gif

Posted by: Dogswell Jan 29 2004, 12:25 PM

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.
THere is a list:
ecipe Book
Log Book
Telephone Book
Parts Ordering
Purchase Ordering
Budget Tracking

Posted by: peterbj Jan 29 2004, 04:51 PM

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.

Posted by: Ernesto Jan 30 2004, 02:36 AM

I started with Access 2000 during 2000. Now I'm using 2002 version.
HAs 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?
Oput 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.

Posted by: Jan 30 2004, 05:17 PM

Im from the UK Bristol, and i build Access2000/2 DB's for the following:
mployee Skills DB : holds current employee skills and expiery dates, team details, training req, and more. built as one backend DB linked to by 7 client systems hosting the front end.
Contact management DB : holds phone books, with e-mails and addrress, meeting times and planner, auto mailing for address book contents and Message sending to any attending frontend DB from any frontend DB and Hand Over notes that auto display on luanching DB.
Generally i just love to code in VBA and see what i can achieve or ..not achieve some times..
Now attempting to learn Visual Basic .NET with the intension of using it to build front ends that pack that extra punch!
I have the same problems as many of us on here with Securing the backend DB against other users just importing your tables so i might try and code a table data incryptor that scrambles data before saving to tables and reverses the process only when the data needs to be displayed. If its a known
'no go!' please stop me now! otherwise thats gana be my next access project.

Posted by: cs51 Jan 31 2004, 05:09 AM

Hi friends thank U for your kind help in solving the problems of many.
Access is great because of the power of crosstab queries.
Ousually 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

Posted by: Boxhead Jan 31 2004, 10:17 PM

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.
ruth 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.

Posted by: jeffers Feb 2 2004, 07:00 AM

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.
It home I use Access to keep a track of my fishing exploits, and photgraphs.

Posted by: Feb 2 2004, 07:19 AM

I have only started using Microsoft access in the last couple of weeks, it is the program suitable for my data basing coursework within my AVCE.

Posted by: Rodders Feb 2 2004, 11:14 AM

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.
It 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?)

Posted by: ghubbell Feb 2 2004, 02:45 PM

Well, I'll copy the 'original' post here:
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

Posted by: tfman716 Feb 3 2004, 11:15 AM

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.
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.

Posted by: GroverParkGeorge Feb 3 2004, 03:00 PM

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.

Posted by: anseris Feb 4 2004, 07:58 AM

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).
It 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.

Posted by: janineo Feb 4 2004, 11:44 AM

I use Access in business.
Oinherited 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.

Posted by: WER Feb 4 2004, 02:54 PM

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").
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. thumbup.gif uarulez2.gif

Posted by: Diehammer1 Feb 4 2004, 09:57 PM

I only started using Access in December and have already created:
oftware 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.

Posted by: kfield7 Feb 5 2004, 03:24 PM

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.

Posted by: TerryGM Feb 5 2004, 04:48 PM

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.
ext 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 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?

Posted by: rjbudke13 Feb 6 2004, 02:12 PM

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.

Posted by: aryder Feb 7 2004, 08:40 PM

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.
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.

Posted by: Lemonstar Feb 11 2004, 11:42 AM

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
-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!!!

Posted by: Bucephalus Feb 11 2004, 02:58 PM

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!

Posted by: chemist Feb 13 2004, 11:54 AM

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. smirk.gif

Posted by: houseofharman Feb 13 2004, 01:02 PM

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.

Posted by: LakeGator Feb 13 2004, 01:34 PM

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!!

Posted by: ChristineInDC Feb 13 2004, 05:35 PM

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 ( 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.
It 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.

Posted by: MrJaven Feb 14 2004, 10:11 PM

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
oto: if your IT staff works hard somthing is not working well

Posted by: faragher Feb 16 2004, 11:54 AM

Uses so far:
ommission 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

Posted by: EAllen Feb 24 2004, 05:02 PM

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.

Posted by: kukui Mar 20 2004, 02:59 PM

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.
It 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.

Posted by: jujutsumaster Mar 29 2004, 09:58 AM

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.
But 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.

Posted by: JVanKirk Apr 15 2004, 09:14 PM

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).

Posted by: MJohnson Apr 21 2004, 11:27 AM

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!

Posted by: Apr 22 2004, 01:03 PM

I started to learn ACCESS one year ago to track contact data for data calls. The Region directorate never wants the same data in the same manner twice.
Olearned everything the hard way. Now I am struggling to develop data collection system for the other 30 staff members in the center. I feel like a retard when I can't get the data to do what I want.
Otherwise it has really freeded me from getting harrassed over monthly or quarterly reports.
How if I can just figure out how...

Posted by: sstaccess Apr 22 2004, 01:43 PM

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.
It 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.

Posted by: popsdrown Apr 22 2004, 08:59 PM

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.
ove Access!

Posted by: treeless Apr 30 2004, 10:06 PM

I started way back in Access 95. Developed a database for the wife's greeting card company.
When 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.

Posted by: stan1941 May 4 2004, 01:13 PM

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.

Posted by: leduncan May 5 2004, 04:24 PM

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.
urrently 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). crazy.gif I think that UA is great! Keep up the good work!

Posted by: river6 May 7 2004, 03:20 PM

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.

Posted by: LenaWood May 16 2004, 08:31 PM

At work I use Access 97 and have Access 2000 at home.
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 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.

Posted by: murdo_2002 May 18 2004, 09:39 AM

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 compute.gif
Oalso 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.

Posted by: CopyKat May 29 2004, 03:46 PM

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.
Ostarted 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...
ove the web site. It's the only fourm that I use.... Thanks to All !

Posted by: Budlong Jun 20 2004, 02:47 PM

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.

Posted by: Jul 8 2004, 05:09 AM

I have developed Risk Management Database, which also conducts both internal and independent audits; it keeps a risk register of all risks, which have been identified. These include Occupational Health & Safety, financial, IT, suppliers, Human Resources etc…

Posted by: lindav310 Aug 5 2004, 02:40 PM

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.
ext 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.

Posted by: drelliotg Aug 19 2004, 04:55 PM

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........................................ compute.gif

Posted by: Marty Oct 28 2004, 11:30 PM

I use it at work to track various inspections of scales and gas pumps. And issue invoices and such

Posted by: Nov 4 2004, 05:24 PM

At work I use Access to run a (now kinda old) database that tracks the status of any job that we are doing. I use access with a MySQL backend to track the status of our bad debtors, this DB used from 5 remote sites.
pcoming project is to migrate the job tracking DB to a MySQL backend so that it can also have remote office's using it.
At home I use access as a front-end for data entry to my personal website (once again running on MySQL as a backend).
Omore or less us access97 or fairly exclusively the features in A97. As far as my webserver is concerned it could care less that I am using access to manipulate the data.

Posted by: dharvest Nov 18 2004, 02:02 PM

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.

Posted by: beyondnerd Nov 23 2004, 11:06 AM

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.

Posted by: Dec 4 2004, 11:20 PM

small business applications

Posted by: geilsc Dec 6 2004, 08:05 AM

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.

Posted by: twigleaf Jan 6 2005, 09:45 AM

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.)
M ade 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

Posted by: Beilby Feb 14 2005, 03:52 AM

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.
There 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 frown.gif

Posted by: bingowens Feb 15 2005, 02:14 PM

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.

Posted by: fish360 Feb 24 2005, 04:28 PM

Managing a camp waterfront. Keeps track of the swimming classes the campers have passed as well as what swimming tag color they have.

Posted by: Jason_Pend Mar 11 2005, 08:30 AM

i only use microsoft access for college projects at the moment!!

Posted by: likajoho Mar 11 2005, 12:53 PM

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
Oalso 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.

Posted by: Zeev Mar 19 2005, 05:42 AM

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.
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.

Posted by: biggie277 Mar 26 2005, 10:37 AM

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.
Yk 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.
YOur 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.

Posted by: doctor9 Mar 31 2005, 03:09 PM

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.
rankly, 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.

Posted by: Apr 3 2005, 08:56 PM

Well I am a volunteer Fireman and we need to have a data base for our calls. I am hoping to build something that can help us...

Posted by: soma1958 Apr 4 2005, 03:05 AM

If you want to know what microsoft access is used for then
ts 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.

Posted by: tergarone Apr 6 2005, 04:04 PM

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.

Posted by: ozysolutions Apr 7 2005, 07:47 PM

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.

Posted by: mrspruitt Apr 22 2005, 12:25 PM

I am designing an auditing application for a cusomters' software quality department.

Posted by: Simon123 May 22 2005, 04:28 AM

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.

Posted by: tjs May 23 2005, 10:45 AM

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:
ustomers & contacts
Suppliers & contacts
Sales lead tracking
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.

Posted by: irobbie May 29 2005, 03:29 AM

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.

Posted by: baldy_man Jun 21 2005, 07:23 PM

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.

Posted by: Jun 22 2005, 05:49 AM

Several databases at work. One helps track spending and forecasting in a way the corporate accounting system does not (especially the forecasting module). One helps create a special report that uses Powerpoint. Was taking hours by hand. Access is used for data entry import from Excel files that were already being used, and then modifies a Powerpoint template based on the data.

Posted by: StewartTanner Jun 25 2005, 10:45 PM

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.

Posted by: strike22 Jun 27 2005, 12:12 PM

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.

Posted by: mrado Jul 12 2005, 06:39 PM

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.

Posted by: gadgetgalky Jul 13 2005, 02:08 PM

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.

Posted by: balboa Jul 18 2005, 01:06 AM

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.

Posted by: The_Catlady Jul 20 2005, 11:37 PM

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.
eople 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.

Posted by: Linsky Aug 5 2005, 06:47 AM

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 I at the right place here?

Posted by: magicmusic Aug 8 2005, 11:49 PM

what I've learned has been by reading books.
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 frown.gif

Posted by: kissinger Aug 19 2005, 08:56 AM

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...
also use access for administration of the club I am president of (ACVA), mailing lists etc..

Posted by: MrSiezen Sep 13 2005, 08:34 AM

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 frown.gif

Posted by: China_Rider Oct 26 2005, 12:02 PM

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.

Posted by: dhassen Jan 12 2006, 07:15 AM

a massively complicated school database for reports, acheivements, classes marks etc.
se VBA modules fairly exstensively
never used data access pages ever!

Posted by: StevieSue Apr 4 2006, 12:55 PM

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

Posted by: alancossey Apr 5 2006, 10:21 AM

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

Posted by: Brooklin Apr 16 2006, 04:38 PM

I designed a database I call LIST of EVENTS to enter information about individuals I find while researching our family tree.
My 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.

Posted by: FrixTheron Apr 18 2006, 09:16 AM

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....
ater 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....

Posted by: GreenThumb Apr 18 2006, 10:01 AM

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.
ext 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 notworthy.gif notworthy.gif
I just recently found UA and to think that development could have been so much easier if I would have found you sooner. uarulez2.gif thanks.gif
You have me hooked!!!!

Posted by: andy8009 Apr 28 2006, 10:31 AM

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.

Posted by: ASMITH5RGV Apr 28 2006, 03:40 PM

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.

Posted by: cableguy Jul 21 2006, 10:16 AM

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 sad.gif

Posted by: AQM_UK Jul 26 2006, 10:19 AM

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.
HAs 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.
PS Gord, the new search and disply stuff is very cool.

Posted by: fairyvicki717 Sep 21 2006, 03:16 PM

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! crazy.gif thanks.gif

Posted by: Dinghus Oct 2 2006, 03:49 PM

I use it to beat cockroaches to death. wink.gif
rimarily 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.

Posted by: cbteng101 Oct 19 2006, 01:14 PM

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.
ecent 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.

Posted by: jltaylor Dec 4 2006, 03:41 PM

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?

Posted by: datAdrenaline Dec 5 2006, 12:06 AM

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!!! ...

Posted by: MikeJ Jan 2 2007, 10:36 AM

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.

Posted by: bobed Jan 4 2007, 09:45 PM

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.
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.
HAs 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.

Posted by: The_Catlady Feb 20 2007, 11:04 AM

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!

Posted by: mbhknight Mar 27 2007, 10:25 AM

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.
Oalso 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 laugh.gif

Posted by: LReichel Jun 29 2007, 07:02 AM

We use ADPs connecting to MS SQL only (both SQL 2000 and 2005 is supported).
He 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.

Posted by: RicardoSR Jul 2 2007, 11:58 AM

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
Mxico City

Posted by: chickdj Aug 8 2007, 10:34 AM

Ostarted 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!)
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

Posted by: gruverdk Oct 1 2007, 11:45 AM

I use Access as a front end to manage and manipulate data which is stored in SQL databases on a SQL server.

Posted by: lasgsd Oct 4 2007, 10:47 AM

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).
Ohelp 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.

Posted by: cassidym Nov 22 2007, 05:41 PM

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.

Posted by: Hottie7579 Jan 10 2008, 02:33 PM

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!

Posted by: CVFoote Jan 13 2008, 10:29 AM

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.
Ocreated 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


Posted by: edgeare Jan 16 2008, 10:32 PM

Why I use Access Database? I use this database for my organizations to store what frequencies assigned to them.... only simple database...

Posted by: jamesfred Feb 18 2008, 01:45 PM

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.
nother 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.
Oappreciate the forum and wish I had discovered it sooner.

Posted by: Scarpo80 Mar 4 2008, 12:35 PM

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.
He 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.

Posted by: OldBirdman Mar 20 2008, 05:43 PM

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.

Posted by: car313 Mar 28 2008, 12:48 AM

My situation is very similar to Ernesto's. Especially about the piracy and about difficulty in getting data entry done.
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.

Posted by: jamesfred May 23 2008, 08:41 AM

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.
nother 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.

Posted by: Coulsdon Jun 11 2008, 09:55 AM

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

Posted by: johnharveyk Jul 9 2008, 01:25 PM

Started with '97 in 1998.
He 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.
HAs 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.

Posted by: JimBud Jul 23 2008, 12:16 PM

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.

Posted by: doris7264 Jan 27 2009, 07:09 PM

Essentially, I build Access databases when data volume or complexity outgrows Excel spreadsheets.
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. cryhard.gif
Ooriginally 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!

Posted by: ClintC Feb 9 2009, 11:07 PM

here is a of some of my favorite quotes and a tag cloud of the key words from this thread. I really enjoyed reading this thread.

Posted by: ClintC Feb 10 2009, 01:07 AM

BTW - the above tag cloud was generated using Handy little tool...

Posted by: paulsh Feb 10 2009, 04:38 AM

I am a self-taught Access developer.
Orun 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 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.

Posted by: graffy76 Feb 25 2009, 09:00 AM

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:
On 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...

Posted by: Willem Feb 25 2009, 02:38 PM

...small typo.. it's
ice word-scramble though!

Posted by: Omega3817 May 12 2009, 11:50 PM

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.

Posted by: the_captain_slog Jul 1 2009, 03:29 AM

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.

Posted by: bohemian9485 Jul 8 2009, 05:36 AM

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^

Posted by: jurotek Jul 8 2009, 08:57 PM

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
Used Car Dealership
Time Card and Payroll
Warranty Tracking
Investment Club
Little League Softball
Calibration of Measuring Devices
Kennel Club
urrently working on ISO,AS and TQM DB for manufacturing co.
Used Access as FE to MySQL, SQL Server and SyBase to create custom apps.

Posted by: nkstrou Jul 13 2009, 02:39 PM

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.

Posted by: mdSheley Sep 17 2009, 11:45 AM

I've been developing in Access since it was born.
nyway 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.

Posted by: roncoscia Dec 16 2009, 09:36 PM

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.
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.

Posted by: candym Dec 24 2009, 10:47 AM

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.

Posted by: vspssdheat Jan 7 2010, 02:08 PM

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.
lso use Access to track Auto Theft Hotline calls and other monthly reports on agents' activities.

Posted by: PRM056 Feb 16 2010, 01:04 AM

I started with Access 1.0 on floppy and with it, built an importing alcohol database & accounting system. I have evolved [sic] missing many of the upgrades. A library system, for the over 70's was a winner' as was the property management software for a guy doing lawns/hedges & property management but the best system is an accounting/quoting system (now in Access 7) for tradesman - linking to an online component database for 'real' up to date quotes. It has been running for 10 years now and it is 'magic'. It handles both cash & accrual accounting requirements and has plenty of flexibility for 'real' tradesmen (those that do cash jobs). It sells for $NZ4000 and it is a steal!! I've tried to use the latest features - emailing pdf invoices and have become really skeptical of the Utter MVP's - they aren't real world (well they aren't in my world - we HAVE to solve probs not muse about them!). My systems may be available for free - so if you've a library to run or a real world tradesmsan wanting just to do his job ... send me an email.

Posted by: djreid Mar 16 2010, 10:01 AM

I'm new to access as maxed out excel, why I didn't switch over before now I don't know!
work for a private bank and use access to bring client data and asset info from 4 seperate business entities & one external regulator to analyse sales, money flow etc and assign out by our sales force.
The structure I currently employ is to use create tables for each query and then append querys to the final file for presentation. Probably a few hundred queries in all as there are overrides etc to apply but by using macros I can import all the txt files and get to the final result in seconds

Posted by: BillR Apr 18 2010, 07:28 PM

I managed to get a promotion to Service Manager, and was surprised to learn that my predecessor didn't have the tools in place to track the basic activities of the department. Since then I have developed numerous databases in order to track these kinds of things - average time on job sites, parts usage, kinds of problems found - basic service trends. I have found it to be quite useful and am hoping to improve my knowledge and get beyond the 'basics'!

Posted by: Jeff B. Apr 30 2010, 10:33 AM

Since Access 1.0 came out ...
urrent application integrate Access, Word, Excel, SQL-Server, DB2 ...
* Document tracking (not document routing).
* Senior Games management
* Homeowners Association event tracking
* Certification process
* Alumni fund-raiser
* CRM system for auto dealership
* CRM system for state agency, including group membership
* Contract management
* Records retention
* Document/track accounting system modifications
... but my major focus is on solving business needs, for which Access (& other apps) happen to be good tools.

Posted by: Mark Haywood May 13 2010, 12:53 PM

We love and have used Access for many years in a non-profit charitible organization to help coordinate free air transportation to patients in need of transportation to medical treatments. At first, we were very excited to see Access moving towards the web. It's where we want to go with our database application. We spent a lot of time trying to evaluate Access 2010. However, we ran into the following 2 major problems.
The cost of Sharpoint hosting with Access Services was far to great for a small non-profit organization like our with less than 5 users. And if we wanted a portion of our web site accessible by our 200 pilot members, the hosting cost and per/user licensing cost would have been enormous.
The second problem we ran into was web reports. The nature of our data structure requires that we use reports that contain subreports. Mission flights can contain multiple passengers, or multiple crew members, etc. We later discovered that subreports are not supported by Access web databases. We learned that forms can have subforms and so we tried to use web forms with subforms but could not figure out how to make the web forms printable on the web or emailable as though it was a report.
Bottom line, we really want to move towards the web with our database application but the above problems with cost and subreports have left us very discouraged.
If anyone knows of solutions to these issues, we'd very much appreciate hearing from you.
Mark Haywood
Angel Flight

Posted by: hokie1 Jul 15 2010, 02:56 PM

I work for a government agency. Have worked with ACCESS here for over 10 years. Other places, added to that elapsed time.
My applications here are:
HAs a front-end tool to access PeopleSoft data for highly customized reporting.
To serve as a conduit between my agency and FEMA during the Application-to-FEMA process for disaster recovery funds after Hurricane IKE.
To be the back-end data base data collector for several FrontPage-based web sites.
There are others but these are the most interesting ones.

Posted by: skonchady Aug 8 2010, 07:46 AM

HAZOP database management and reports for process plants
I use Microsoft Access for HAZOP reviews of process plants. It has been very useful in identifying safety and operator issues which need to be addressed.
CAn actionable points report can be generated to facilitate action as well as make updates as actions are completed.
Sadananda Konchady

Posted by: Cwittmaack Nov 23 2010, 03:58 PM

I started out using Dbase III and have started using Access 2003 to build some databases for my work
I have a database that keeps track of accounts, customers, which in turn calcluates daily, monthly, quarterly and yearly reports as well as keeping track of YTD on each report for each customer.
2nd database is used to preform the calculationd for out sale's department for each quarter.
3rd database that tracks all the movement of our accounts.
I am now just starting to look and play with access 2010, which is i think is access 2007 still i have been told. I hope to learn as musch as possable about it.

Posted by: likajoho Jan 15 2011, 10:23 AM

This keeps popping up under "My Discussions" even though I've never "discussed" it. So I thought I would answer it, even though it's an old discussion.
I am constantly thinking of things to use a database for, even though I don't always follow through for lack of time. Actually, just about any time I make a worksheet of more than a few simple lines and formulas I question whether or not it would be better done in a database. If I had a simpler database like Q&A (created by Symantec and then dropped--which probably none of you ever heard about) I would do more things in a database, as it makes sense to protect the data you enter and be able to view it in multiple ways without reinventing the wheel every time you use it.
THere are databases I am using right now or have recently:
Contact database for my clients
(a database allows me to record mutiple addresses, email, phones, notes, receipts, contacts, correspondence, etc.)
(use for producing invoices, receipts, mailing lists, reports, info request letters, and Ethics reporting)
Work log (tracking hours and work done for each client for billing)
Auto Log (tracking miles driven for work, medical, charity for tax returns)
Contact database for our family
Remember (a list of things I want to remember, such as gift ideas, shopping ideas, little bits of info people tell me that I might want to know later)
Indexing (I use for indexing historical documents or other sources for family research and posting on family research sites)
(I have indexed cemetery records and markers, courthouse records, books, and short works)
Stuff (inventorying and explaining possessions--especially family heirlooms)
Things I have taken a stab at or thought about developing into a database recently, if it weren't so time-consuming, tedious, or downright complicated:
Tax Workbook (currently in Excel with multiple worksheets interlinked)
Citing Helper (currently using Excel to produce Footnotes, shortened footnotes, and Bibliographies for citing family research sources)
Contact list for our church (they currently have it in tables in a text document)
Calendar for a non-profit (to more easily produce lists and different types of calendars showing different groups of events--meetings, classes, workshops, social events--without re-entering by hand)
Gardening (track where and when stuff is planted and results--such as whether or not a plant was what I wanted or would want to plant again in the future)
Finances (I am frustrated with my current software's lack of options and need for a separate contact database as well as disgusted with the cost of upgrading every year or so)
Things I used a database for in the past:
Working Contact/Financial database (used data periodically refreshed from another database that was not flexible enough to do what I wanted to do to create lists and audit data)
Auditing database (linked to a copy of an online database to more easily filter and sort records for auditing in preparation for preparing Ethics reports and reconciling)
Matching Funds Editing Database (linked to a copy of an online database to check for compliant and non-compliant reporting information and to modify as needed)
Matching Funds Correspondence Database
(linked to a copy of an online database for the purpose of producing various letters to address non-compliance issues regarding matching funds for a presidential campaign)
Mailing Lists
Compliance Dates (tracking various dates related to compliance by various regulatory agencies for various types of clients)
(at one time I had 7 clients that were each a different type of committee and each with different reporting requirements)
Termination Database (for analyzing and reporting on specific receipts, disbursements, receivables, and payables and printing on preprinted forms in compliance with FEC termination regulations)
Personnel Database (for tracking, analying and espcially reporting on payment to employees and contractors)
Oalso at times create a temporary database for manipulating data, standardizing data, etc. for another database or list.

Posted by: Teatime May 18 2011, 05:51 PM

Reading all this I really feel like the odd duck in the pond (but I didn't expect otherwise) since I use Access only privately.
It started quite a number of years ago in an attempt to keep track of my growing collections of movies, CDs and comics that I started dabbling with databases. After some babysteps in Works (yeah, let's not talk about that) I moved to Access. And over time building and evolving databases for my hobbies has become kind of a hobby for itself <
Since I'm self-taught (via a few books and a lot of consulting sites like these, or the good old ms newsgroups) my knowledge is all over the place and highly uneven; also since I don't work on databases constantly I tend to forget things and have to relearn them. Not too rare that I stumble upon some piece of code and wonder "what the [censored] have I done here?".
But for an amateur I'm quite proud of some of my work, though I'm quite sure that you professionals would probably just laugh on my crappy coding (or throw you hands up in terror <).
(And I always in awe - also sometimes terrified - reading many of the posts realizing how little I really know and how patchy my knowledge is)
Still, a lot of what little I know I owe to people like you here who offer a lot of advice, help and information to others. For that I thank you!

Posted by: jleach May 19 2011, 04:20 AM

My first use in Access was really just because I needed a programming language and it had an easy form design interface. I had never done any computer programming before that and didn't even know what a database really was. I stumbled across Access and had a revelation: this is cool, I can do lotsa stuff with this!.
The task was to take some machining language (called G-Code, a line by line language that tells machines what to cut and where), read each line from a file, convert the GCodes to a format readable by a different machine, and then post it back out in another file. It was an extremely fun project and a great way to learn VBA. And Access had these things called "tables" that I could use to store the info in while doing the conversion. How handy is that? (to this day, several years later, this remains one of the most effective and cost-saving applications that our company uses!).
I was pretty much hooked on Access at that point, and since then our entire software management system has been replaced and expanded using a custom Access solution. Developing a full blown manufacturing software covers a lot of areas, so over the few years it took me I was able to really stretch my horizons.
Besides the work related stuff, I use Access to track aviation data, including aircraft and airport properties, wieght and balance calculators, flight plan information, gas/time calculators, log book entries, etc. etc. Also related is weather tracking - I use Access to collect and store wx information from certain stations for analyzation.
I've also create a media handling database, but this isn't nearly as robust. Earlier version of Access at least are not really primed for this type of work. Although I was able to efficiently tag and organize various media, viewing and playback was not optimal. I suspect 2010 might provide a much nicer interface for this type of work though.
There's countless other small utilities I've created with Access, some data driven and some just to have a simple vb/forms host with no data.

Posted by: tankerman May 19 2011, 01:55 PM

I have used Access for about 4 years now, I have NO formal training on Access and had to learn everything on the fly. I started useing MS Access help site (before it changed) then went to here and Yahoo group.
The help I've gotten has been remarkable. I have found myself coming here less lately, I guess I'm starting to learn something.
I use Access to track our barge movement, tank movements as well as emp OT and warehouse movements. I did not know how much easier life could with Access but the frustractions of getting it to work.

Posted by: blobbles78 May 31 2011, 06:45 PM

Ha haa, sorry, couldn't resist!
I have used access for:
Client Management
Business readiness
Simple inventory management

Posted by: BillR Aug 26 2011, 04:56 PM

Contact and call management for a medical device manufacturer. I started using Access around 2003 after getting promoted to a service manager position. I was shocked to learn that my predecessor really had no system in place to analyze department metrics. However, I have to say that I use it primarily as a "place holder" for data, with little by way of calculation. Calculations are normally done by exporting the data into Excel. Overall, Access has been very useful to me. In comparison with other "canned" databases I've been forced to use in various companies, I find that I can customize Access to get exactly the data I need to track, without having to beg Management to buy additional packages. I also want to thank the people on this site for their kind help when I'm stuck!

Posted by: Gawayne Dec 28 2011, 12:05 PM

I received training in MS Access several years ago, but haven't used it much. At work, I am a user of several Access "front end" applications that aggregate data for us. I was referred to this site by the co-worker who has written these front ends.
It home, I aspire to develop a database to help my wife do her ordering work for the food co-op she is in. While it's been a long time, I was a programmer for a couple of years before I moved to my current employer.
Oexpect that I'll find plenty of information here.

Posted by: tina t Dec 28 2011, 01:53 PM

i use Access (A97, can you believe it?!) a lot in my job. i'm the dept clerk for a dept that acts as kind of a "clearinghouse" for other depts. a lot of work runs through our dept, in getting from point A to point C. which means that a lot of paper and electronic (mainly paper) data passes through my hands every day. when i was hired, much of the work for my position was performed, and records kept, on paper and in Excel. ye gods, what a mess! i've been slowly moving most of that into various Access databases. in several cases, the best way to get the paper off my desk was to stop it at the source, so i found myself writing Access applications for folks in other depts, usually with a flow through to my dept, and often onward to other depts. and i've implemented a lot of data-sharing applications, where my dept is responsible for data collection/storage, but other depts frequently request information from us. i have a common frontend in place on nearly every PC in the (small) company, with forms to front the linked tables from 20-odd different backends - providing read-only views in most instances, but data entry in some cases. access to various groups of the FE forms is controlled by a machine-driven main menu. sounds strange, probably, but many of the PCs in the company are "public", available to be used by various people who walk up to them - kind of like open kiosks, i guess. so the common fe displays a main menu that provides various options based on what PC the db is opened on, rather than being based on which particular person is opening it. and then there are a few dbs with separate FEs that are password protected, and available on only a few particular users' PCs. and then again, a few separate FEs that are available on public PCs, but can only be used by users that have their own individual passwords.
It home, i don't use Access much for my own purposes, actually. when i do, i use A2003. i wrote a simple checkbook register, so i wouldn't have to keep getting paper ones from the bank - i do a lot more paying with an atm card than with paper checks, and kept using up the paper registers long before i used up my checks! nowadays, of course, i hardly ever write a paper check - i just use bill pay to have my bank write/send it! <g> and, let's see, i wrote a book log to keep track of my books - both purchased and "wish list" - and ditto a "movies" log for my videos and dvds. that's about it.

Posted by: mizutaifux Oct 23 2012, 02:25 PM

I develop in ms-access since version 97 for win 311.
Normally I use MS-ACCESS to medium projects in consultancy work.
I have projects in several versions.
There is more productive tool for database that MS-ACCESS.

Posted by: babikirua Feb 5 2013, 12:59 AM

I use it for registering and tracking correspondence and translation work of our company.