DMS Facets

Relating several topics, including IT, Microsoft Access, sports administration, and micro-ISV business.

Limbering up

A Dose of Insight When you work on your own, it is sometimes easy for your focus to get a bit narrowed down and stale.  Well that’s what I find anyway. Every now and then you need to get a shot of steam from somewhere, and in my experience, books or online content do not […]

1

Bugs and Creepy Crawlies

Testing Custom Software There is a huge amount written about the testing phase of the software development cycle.  There is the traditional concept of Inception – Analysis – Design – Implementation – Testing – Deployment.  Wikipedia articles expand on this in all directions. These theories focus almost entirely on large-scale team development of commercial software.  […]

0

Community Community

Microsoft MVP Summit 2007 The stimulus to get back to this blog after a few months break, has been provided by my attendance last week at the MVP Summit, held in Seattle and Redmond, Washington, USA. I am honoured to be part of Microsoft’s MVP (Most Valuable Professional) program, which recognises participation in technical communities.  […]

2

Real World Access (20)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Armen Stein’s fulfillment We started this Access application for Fluke Corporation in 1999.  They needed a way to manage literature fulfillment requests from customers, which are collected by Oracle and Onyx order entry systems.  Over the years the […]

1

Real World Access (19)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Jeff Boyce’s games A few years back, the Washington State Senior (50+) Games (WSSG) Association, a volunteer-based group, was managing an annual state-wide games/competition with a paper and pencil registration process.  Needless to say, only about 100-150 participants […]

0

Real World Access (18)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. John Nurick’s contacts The database I developed for the small management consultancy where I work tracks contacts (persons and the organisations they belong to and move between), sales and jobs (and several other things). It’s used mostly as […]

2

Real World Access (17)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. John Viescas’s projects Some of my more interesting projects: 1) Golf tournament scheduling database for the Guadalmina Golf Club, Malaga, Spain – includes automatic calculation for each type of tournament based on dynamic input parameters and course slope. […]

0

Real World Access (16)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. John Vinson’s animals I’ve been working for some years now with the Los Angeles Society for the Prevention of Cruelty to Animals (LA-SPCA). They run a very large operation including field agents who respond to calls (handled by […]

0

Real World Access (15)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Arvin Meyer’s houses Construction Database: Database creates, tracks, and awards bids for production homebuilding. It then tracks vendors and costs, loads the data into individual lots (at about 700 homes per year) and issues purchase orders, automatically emailing […]

1

Real World Access (14)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Steve Schapel’s auctions Dunbar Sloane Ltd is New Zealand’s leading auctioneer of art, antiques, artefacts, toys & dolls, wine and colonial collectables.  I have developed an Access application, right at the hub of their operations, to manage their […]

0

Real World Access (13)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Pat Hartman’s hair care Clairol, manufacturers of hair care products, converted their existing applications to SAP but SAP didn’t provide all the functionality they needed so I developed an Access application that worked with SAP to produce workorders […]

0

Real World Access (12)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Ken Snell’s retailers Point-Of-Sale Database for retail stores. Handles parts inventory (including parts that have unique serial numbers associated with each item, e.g., electronic equipment, cameras), customer orders, work orders, quotes for business opportunities, purchase orders, automatic backordering […]

0

Real World Access (11)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Alex Dybenko’s ships There is a biggest shipping company in a world, Maersk Sealand, which once asked me to build a small Access application for one department.  People liked it, and it started to grow and grow, once […]

2

Real World Access (10)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Tom Wickerath’s aircraft In development right now, a database for the AOG (Airplane on the Ground) tool room organization of The Boeing Company.  It will be used to help pack kits of tools for transport anywhere in the […]

0

Real World Access (9)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Duane Hookom’s nutritional products Our factory makes products like infant formula and other nutritional products. It is very important to track which ingredients are used in which products. Each “recipe” is stored in its own Excel file and […]

0

Real World Access (8)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Karl Donaubauer’s sleep research I’ve created several Access applicationss for the sleep research team at the department of neurology of the University of Vienna. They use a device called Actigraph (you wear it like a wrist watch) to […]

0

Real World Access (7)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Jeff Conrad’s restaurant network I created a small Access application for each of our remote restaurant locations to enter their daily numbers. Each evening the restaurants had to fax their daily numbers to the main office where someone […]

1

Real World Access (6)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Tony Toews’s welding shop Hows about my big kahuna, the ERP app for welding shops with several hundred welders?   Handles drawing status, material receving, inventory scheduling, fabrication, very complex quality control (15 different types of tests), shipping and […]

0

Real World Access (5)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Joan Wild’s tree breeding It started as a database to track the breeding activities (tree breeding, that is) of a tree improvement cooperative.  Selection of parent trees, collection / extraction / storage / testing of pollen, breeding plans/activities, […]

0

Real World Access (4)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche. Peter Doering’s shoes I wrote a sales force automation tool for the apparel/footwear industry, i.e. with style/color/size handling. Currently it is running in about 30 countries and 5 languages on all continents. It’s used by sales reps for […]

1