Database Whiz Consulting – Microsoft Access Programming, SQL Server Admin, Web Programming, & Web Design

Land Air Sea Worldwide

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA
COM Libraries:	DAO
Integrations:	None
Application Status:	Production
Approx. # of Users:	5
Category:	Invoicing Software
Client Location(s):	Las Vegas, NV
Description:
System allows Land Air Sea Worldwide to track the movement of goods and materials for their clients. Mostly servicing clients moving to and from conventions, the system allows LASW to track all aspects of the move, including the client, the ship from location, ship to location, the exhibitor, and the convention itself. System allows generation of invoice and Bill of Lading document. System provides sales reports by sales rep and by customer.

Screenshots
Reports

Advanced Travel Systems

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	SQL Server 2005 Express
Business Logic:	VBA
COM Libraries:	DAO
Integrations:	None
Application Status:	Defunct
Approx. # of Users:	3
Category:	Invoicing Software
Client Location(s):	Las Vegas, NV
Description:
System was designed rapidly for generating invoices for 3rd party clients of Advanced Travel Systems. System was mainly designed for reporting purposes and contains a number of reports based on the customer invoices. Application was pulled out of production when its core functionality was redeveloped into web application that includes a booking engine utilizing SOAP and Web Services.

Screenshots
Reports

Reports Coming Soon

DK Landscaping

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA
COM Libraries:	Word
Integrations:	Export IIF for Quickbooks
Application Status:	Production
Approx. # of Users:	3
Category:	Invoicing Software
Client Location(s):	Las Vegas, NV
Description:
D & K Landscape previously had a somewhat complicated spreadsheet system for generating new estimates. This system allows D & K Landscape to save estimate templates, track revisions, load included/unincluded features, track change orders, and print a variety of sales reports.

Screenshots
Reports

Reports Coming Soon

Specialty Tile

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA
COM Libraries:	DAO
Integrations:	Export IIF For Quickbooks
Application Status:	Company Closed
Approx. # of Users:	8
Category:	Invoicing Software
Client Location(s):	Las Vegas, NV
Description:
This system allows Specialty Tile generate quotes/invoices quickly for their clients. System allowed for tracking of materials and labor for any given job, and also allows for the tracking of change orders, and printing a variety of sales reports. System also allows Specialty Tile to run reports for items on Order from vendors so they can easily tell when materials are set to arrive, when they have arrived, whether or not the quantities received were what was ordered, etc.

Screenshots
Reports

Spectrum

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA
COM Libraries:	DAO
Integrations:	None
Application Status:	Production
Approx. # of Users:	3
Category:	Invoicing Software
Client Location(s):	Las Vegas, NV & Minneapolis, MN
Description:
Spectrum Production Services is a company based out of Minneapolis that supplies staging and lighting for events, concerts, and anything else that requires a little spectacle. A lot like the D & K Landscape application, the Spectrum system allows the main user to quickly build quotes based on grouped products called Assemblies. Instantly identifiable are items not in stock, not on hand, or that have to be sub-rented from a 3rd party vendor. Reports allow Spectrum to know what pieces of equipment are out, which items are overdue, and what items are available for other productions. Scheduling of equipment all prevents Spectrum from attempting to provide equipment on a particular gig when it is already assigned to another. Quote templates allow Spectrum to save sizeable quotes as templates so that they can be easily generated when a similar event occurs. The app is only used in the Las Vegas office as the Minnesota office is equipped only with Macs and the boss hasn�t yet allowed us to turn it into a web application that can be used by both offices.

Screenshots
Reports

Reports Coming Soon

Titan Oil & Gas Services, Inc.

Primary Interface:	Microsoft Access
Secondary Interface:	Web (Active Server Pages)
Database Engine:	Microsoft Access & SQL Server 2000 (MSDE)
Business Logic:	VBA
COM Libraries:	DAO, Custom Hot Spot Control
Integrations:	Export IIF for Quickbooks
Application Status:	Production
Approx. # of Users:	3
Category:	Invoicing Software
Client Location(s):	Billings, MT
Description:
Titan Oil & Gas rents equipment and sells products to the oil well maintenance industry. Like many other apps, Titan needed a way in which to easily invoice and bill their clients while having the ability to produce reports and documents specific to their industry. Because TOG typically had folks in the field�and because the app is more than a couple of year old�there was a need for TOG to be able to enter invoices while in the field in remote locations where they would have no access to internet. Once the user returned to the office, the user would be able to synchronize the local changes with a master database. One learns a lot when attempting to manually write a synchronization routine. Under ideal circumstances, the sync routine works great but no so much under non-ideal circumstances. So, that feature isn�t utilized, but TOG has implemented a number of other tracking items (Safety Meetings, Sundry Notices, On Site Personnel, Job Risk Analysis, and Employee Time Tracking to the system.

Screenshots
Reports

Reports Coming Soon

Western Stage Props

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access
Business Logic:	VBA
COM Libraries:	DAO, ADO
Integrations:	None
Application Status:	Demo
Approx. # of Users:	3
Category:	Invoicing Software
Client Location(s):	Las Vegas, NV
Description:
We�ve all had that one client that no matter what you do or how well you do it, the project is doomed. This is the case with this app, which is perfectly designed for anyone taking and logging retail orders. System allows the tracking of invoices, products, customers, vendors, and of course includes a number of sales reports. WSP originally had an outdated FoxPro application that was no longer able to run on their new computers. Thus a new app was needed. We keep this app as a demo app because it does work very well and is cosmetically attractive.

Screenshots
Reports

National Hispanic Professional Organization

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access
Business Logic:	VBA
COM Libraries:	DAO, Outlook
Integrations:	None
Application Status:	Production
Approx. # of Users:	1
Category:	Contact Management Software
Client Location(s):	Las Vegas & Reno, NV
Description:
The NHPO (Vegas & Reno) needed the ability to keep in contact with their members more efficiently than they were doing with Outlook and pieces of paper. System is simple and allows NHPO to log all of the clients, keep certain statuses on their membership. It allows NHPO to schedule events and see quickly which members are attending & have paid for the events. Also allows them to see what events members have attended in the past. Nothing fancy, but just what the client needed.

Screenshots
Reports

Reports Coming Soon

Henderson Speech Hearing and Language Center

Henderson Speech Hearing & Language Center

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access
Business Logic:	VBA
COM Libraries:	DAO
Integrations:	None
Application Status:	Demo
Approx. # of Users:	1
Category:	Invoicing Software
Client Location(s):	Las Vegas NV
Description:
This application was intended to replace an older scheduling system that did not have all the capabilities that the company needed. Development on this app never really got that far and now instead serves as a demo app. The app allowed HSLC to track patients and their sessions with their speech therapists. Invoicing can be done from the system and reports can be run, but scheduling was never implemented.

Screenshots
Reports

Wolf Lending Group

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access
Business Logic:	VBA
COM Libraries:	DAO, Outlook
Integrations:	None
Application Status:	Production
Approx. # of Users:	1
Category:	Contact Management Software
Client Location(s):	Las Vegas, NV
Description:
Wolf Lending Group needed the ability to keep in contact with their clients more efficiently than they were doing with Outlook and pieces of paper. System is simple and allows WLG to log all of the clients, keep certain statuses on them…which of course color codes the records…allows them to take notes and schedule tasks or call back dates. It allows them to see what clients are due, over due or pending. Fairly simple. Very effective.

Screenshots
Reports

Reports Coming Soon

Green Flag

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access
Business Logic:	VBA
COM Libraries:	DAO, Outlook
Integrations:	None
Application Status:	Production
Approx. # of Users:	1
Category:	Contact Management Software
Client Location(s):	Las Vegas NV
Description:
Green Flag needed the ability to keep in contact with their clients more efficiently than they were doing with Outlook and pieces of paper. System is simple and allows Green Flag to log all of the clients, keep certain statuses on them…which of course color codes the records…allows them to take notes and schedule tasks or call back dates. It allows them to see what clients are due, over due or pending. Fairly simple. Very effective.

Screenshots
Reports

Reports Coming Soon

Absolute Collection Services

Primary Interface:	Microsoft Access
Secondary Interface:	Web (Active Server Pages)
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA, Batch Files, Windows API
COM Libraries:	Word, ASPPDF
Integrations:	Optimal Outsource
Application Status:	Production
Approx. # of Users:	3
Category:	HOA / Collection & Foreclosure Software
Client Location(s):	Las Vegas, NV
Description:
Application allows Absolute Collection Services to track delinquent HOA accounts for their clients. Delinquent accounts need to be sent Demand Letters, Notice of Defaults, Lien Letters and Lien Notices, Notices of Trustees Sales, simple payment plans and other documents that are either sent to the home owner and/or get recorded with the Clark County Recorders office. Application also allows ACS to cut checks directly from the system to themselves, the HOA, the Management Company or a miscellaneous company when necessary. System also contains a number of built-in reports that allow the users to get tallied information at the push of a button. The ACS application also has a web interface so that clients with access can login to the system and get status reports on their accounts and so that HOA’s can sign up for service directly through the absolute-collection.com website.

Screenshots
Reports

Cooper Castle Law Firm

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA, Batch Files, Windows API
COM Libraries:	Word
Integrations:	WALZ
Application Status:	Development
Approx. # of Users:	30
Category:	HOA / Collection & Foreclosure Software
Client Location(s):	Las Vegas, Utah, Colorado
Description:
Application is currently in development, but will be designed to allow Cooper Castle Law Firm to manage foreclosures, bankruptcies and evictions.

Screenshots
Reports

Reports Coming Soon

Curtis Management Consulting

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access (.mdb)
Business Logic:	VBA, Batch Files, Windows API
COM Libraries:	Word
Integrations:	None
Application Status:	Demo
Approx. # of Users:	1
Category:	HOA / Collection & Foreclosure Software
Client Location(s):	Scottsdale, AZ
Description:
This demo was put together (but never delivered) for Curtis Management Consulting. It is setup as a stand-alone, single user version of the Collection & Foreclosure software. Application allows a user to track delinquent HOA accounts for their clients. Delinquent accounts need to be sent Demand Letters, Notice of Defaults, Lien Letters and Lien Notices, Notices of Trustees Sales, simple payment plans and other documents that are either sent to the home owner and/or get recorded with the county recorder’s office. Each jurisdiction is a bit different, so the recorded documents would need to be adjusted for your state and county. System also contains a number of built-in reports that allow the users to get tallied information at the push of a button. System is just a demo, so it can be expanded to a SQL Server backend and setup for multiple users.

Screenshots
Reports

Reports Coming Soon

Nevada Association Services, Inc.

Primary Interface:	Microsoft Access
Secondary Interface:	Web (Active Server Pages, PHP, SOAP)
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA, Batch Files, Windows API, R&OS PDF, htmldoc.exe
COM Libraries:	Word, ASPPDF
Integrations:	WALZ, First American Title
Application Status:	Production
Approx. # of Users:	20
Category:	HOA / Collection & Foreclosure Software
Client Location(s):	Las Vegas, NV
Description:
Application allows Nevada Association Services to track delinquent HOA accounts for their clients. Delinquent accounts need to be sent Demand Letters, Notice of Defaults, Lien Letters and Lien Notices, Notices of Trustees Sales, simple payment plans and other documents that are either sent to the home owner and/or get recorded with the Clark County Recorders office. The NAS application has a web interface so that clients with access can login to the system and get status reports on their accounts and so that HOA’s can sign up for service directly through the absolute-collection.com website. NAS application also utilizes SOAP and Web Services to transmit and receive information and documents for title orders and 10-Day mailing NODs. System also allows NAS to easily transmit documents to WALZ for certified and first class mail processing.

Screenshots
Reports

Reports Coming Soon

Southern NV Eviction Services

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access (.mdb)
Business Logic:	VBA
COM Libraries:	Word
Integrations:	None
Application Status:	Production
Approx. # of Users:	5
Category:	HOA / Collection & Foreclosure Software
Client Location(s):	Las Vegas, NV
Description:
Southern Nevada Eviction Services serves the eviction process for their many clients all around the Las Vegas valley. With different rules and regulations for each jurisdiction in the valley (Las Vegas, North Las Vegas, & Henderson), SNES needs to process a number of different documents for any given situation. System is designed to allow SNES to input and process evictions as quickly as possible. System also allows SNES to easily generate monthly statements for their clients, or to print individual invoices when necessary. There is no file server to house the database engine, so the app runs off of a separate data .mdb file.

Screenshots
Reports

New West Property Management Inc.

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access (.mdb)
Business Logic:	VBA
COM Libraries:	Word
Integrations:	None
Application Status:	Production
Approx. # of Users:	5
Category:	HOA / Collection & Foreclosure Software
Client Location(s):	Las Vegas, NV
Description:
New West Property Management appears in this category because it closely resembles the HOA/Collection apps in its functionality. NWPM is actually an inherited app that we put a new face on and updated its limited functionality. System now allows users to mail merge documents directly from the database, generate Work Orders, and run a number of different reports.

Screenshots
Reports

Beazer Homes

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access
Business Logic:	VBA, T-SQL
COM Libraries:	DAO, Word
Integrations:	None
Application Status:	Production
Approx. # of Users:	4
Category:	Construction Contracting
Client Location(s):	Las Vegas NV &Phoenix, AZ
Description:
If the Blue Heron/Dax Application is on one end of the spectrum, the Beazer app would be on the other end of the spectrum for Construction Contracting. This application merely allows Beazer Homes to keep track of the contracts that have been awarded to subcontractors. Since its deployment in Las Vegas, it has subsequently been deployed to the Phoenix division of Beazer Homes.

Screenshots
Reports

Reports Coming Soon

Blue Heron

Primary Interface:	Microsoft Access
Secondary Interface:	Web (Active Server Pages)
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA, T-SQL
COM Libraries:	DAO, ADO, Word, ASPPDF
Integrations:	None
Application Status:	Production
Approx. # of Users:	6
Category:	Construction Contracting
Client Location(s):	Las Vegas NV
Description:
This application may be the most comprehensive application ever developed by Database Whiz Consulting. Managing all aspects of home building projects, from inviting and collecting bids from the subcontractors, to configuring all lots and models on the project, managing purchase orders and invoices, to cataloging all of the home buyer options. With interfaces for Dax Construction administrators, and web interfaces for both subcontractors and buyers, it stands as a testament to what is possible if the need is present.

Screenshots
Reports

Reports Coming Soon

Cheep Cheep Movers

Primary Interface:	Microsoft Access
Secondary Interface:	Web (PHP, SOAP)
Database Engine:	Microsoft Access
Business Logic:	VBA
COM Libraries:	DAO
Integrations:	Teletrak
Application Status:	Production
Approx. # of Users:	4
Category:	Scheduling Software
Client Location(s):	Las Vegas NV
Description:
Cheep Cheep has a need to keep track of all of their upcoming and past moves. Move calendars allow the users to see at a glace everything on the schedule for the given day or for the month. Daily schedule is color-coded so that Tentative, Confirmed, and Cancelled moves appear in different colors. Cheep Cheep has a number of trucks on the road at any given time. Using Teletrak's software to know where their trucks are at any given time, the Cheep Cheep system utilizes the Teletrak web service to send address information to trucks on the road. Initially had attempted to use Microsoft's Office SOAP Toolkit to accomplish that, but that didn't work so well. Flipped functionality to PHP and all is good.

Screenshots
Reports

Reports Coming Soon

HDMC

Primary Interface:	Microsoft Access
Secondary Interface:	Web (Active Server Pages)
Database Engine:	SQL Server 2005 Standard
Business Logic:	VBA
COM Libraries:	DAO, ADO, Word
Integrations:	None
Application Status:	Production
Approx. # of Users:	25-30
Category:	Hotel Booking/Invoicing Software
Client Location(s):	Las Vegas NV
Description:
HDMC does group bookings for their clients coming into Las Vegas or any other city in the U.S. With thousands of leads and a bullpen full of sales reps, the HDMC application is the life-line of the company, allowing them to easily manage leads in a meaningful way. System allows sales reps and managers the ability to track the bookings process from start to finish.

Screenshots
Reports

Reports Coming Soon

Hit A Few Golf

Primary Interface:	Microsoft Access
Secondary Interface:	Web (Active Server Pages)
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA
COM Libraries:	DAO
Integrations:	None
Application Status:	Company Closed
Approx. # of Users:	2
Category:	Scheduling Software
Client Location(s):	Las Vegas NV
Description:
System allowed Hit A Few Golf to schedule, monitor, and report on the time customers spent utilizing their golf simulators. Web interface allowed clients to login to the website to schedule simulators without having to call the shop.

Screenshots
Reports

Reports Coming Soon

Ink Drop Groups of Nevada

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	SQL Server 2000 (MSDE)
Business Logic:	VBA
COM Libraries:	DAO, ADO
Integrations:	None
Application Status:	Production
Approx. # of Users:	2
Category:	Misc. Software
Client Location(s):	Las Vegas NV
Description:
Ink Drop Groups has the task of keeping track of monies in various accounts for beverage companies operating within the casino industry. Application allows for depositing of checks, dividing and distributing checks over specified accounts, payment of checks and dividing and distributing payments over default or specified accounts. With a transaction trail for everything that appears in the database, the system allows for multiple reports allowing IDGN to see (and report to their clients) what is where at all times and how it got there.

Screenshots
Reports

Reports Coming Soon

Sportco

Primary Interface:	Microsoft Access
Secondary Interface:	None
Database Engine:	Microsoft Access
Business Logic:	VBA
COM Libraries:	DAO, Excel
Integrations:	eBay, DOS-based Inventory System
Application Status:	Production
Approx. # of Users:	2
Category:	Misc. Software
Client Location(s):	Las Vegas NV
Description:
Sportco has a large inventory of sporting goods. They also have an eBay store. The task for this app was to allow Sportco to export its inventory�or parts of its inventory�at any given time so that it can be imported into eBay. Anybody who's ever done this knows that it is not as straight forward as it sounds. In order to help keep track of inventory, system must also download spreadsheets from eBay and load those into a local database. All this while the inventory isn�t in Access at all, its in a DOS-based inventory system I don't even know the name for.

Screenshots
Reports

Reports Coming Soon