Sample Solutions
Click here to view sample Microsoft Access forms and reports
Here are some examples of web sites built by MicrosoftAccessConsulting.com. They range from sites designed for recording employee data on Blackberries and iPhones to non-profit web sites.
A company needed a way to track their customers, but also wanted a way for their customers to update their own information and purchase additional services. This screenshot shows some of the information available to staff, with collapsible panels used to maximize screen space. Because this application contains sensitive customer data requiring a secure login, only a screenshot is avaialable.
Knight Janitorial uses a MicrosoftAccessConsulting.com application to record site inspections. Employees use their Blackberries or iPhones to enter the data at customer locations. The data is stored in an MS Access database for offline processing. Employees can also record their hours online, and later view their last four weeks of approved or rejected hours. Because this application contains sensitive customer data requiring a secure login, only a screenshot is available.
The US Hydrofoil Association needed a way for riders to score their competitive trick runs to prepare for competitions or just gauge personal progress. The USHA Scoring Application allows users to select each trick, based on their division. The application then scores the best 10 tricks and displays the results in a grid. Completed trick runs can be saved to html for emailing, or xml for use in a spreadsheet.
Money4YourSchool.com, and its sister sites, Money4YourChurch.com and Money4YourNonprofit.com, aid organizations in their fundraising efforts by selling newspaper subscriptions in a convenient, simple to use format. The web sites use a common database that contains both the unique information about each organization, and the order information from each sale. A separate Microsoft Access application exports the orders to encrypted Excel spreadsheets to be delivered to each newspaper vendor via email or ftp.
The book Guide to Natural Food Restaurants in the US and Canada contains information on over 2,000 restaurants. Brad developed a Microsoft Access application to maintain the information in a Microsoft SQL Server database. The data can then be exported to both a Microsoft Word document used for printing the book, and an online database where users can search for restaurants by State and City. Online users have the option of clicking a link to view a map with the location of the restaurant. Go to http://www.vrg.org/restaurant/index.htm to view the application.
You can buy what you need for your day on the water at YourGearStore.com. This is a Zen Cart based ecommerce site, with a customized MySql database and custom PHP programming to meet the customer's needs. The online MySql database is updated via a custom Microsoft Access application, adding significant convenience and additional features to the standard online Zen Cart database interface.