Logo

My Access Tips for Custom Microsoft Access

Application Development

by Matthew V Carmichael


Need Help?

My Tips


Links

Resources
A listing of just some of the projects I have completed.
Client: AllState Appraisal Service
Project: Pottery Tax Assessments (disrupted runtime application)

Technology used: Microsoft Access 97

Description:
Used Access 97 to import and compile property assessment data provided by New York State into a useable format. CDís were burned for each New York State County containing all residential and commercial properties in the area. An Access 97 front end was developed to read the data on the CDís, allowing users to easily search the property listings. The application and CDís contained valuable property information (assessments, sale prices of properties, number of rooms and floors, school district, water and sewer types, etc.) that AllState Appraisal Service resells to individuals and business in the Real Estate/property assessment business.
Client: Aquatic Development Group, Inc
Project: Reporting Application

Technology used: Microsoft Access 97

Description:
Developed an Access 97 database to track customers, contacts, and order information. The database allows users to produce mailing lists and custom reports.
Client: Brockway-Smith Company & NCB Properties, Inc.
Project: Assess Training

Technology used: Microsoft Access 95

Description:
Conducted on-site training in Microsoft Access 2.0 and Access 95 for beginning users.
Client: Capitol Payment Plan
Project: New York Automobile Insurance Plan (NYAIP) Rating Solutions

Technology used: Microsoft Access 2000 (Runtime)

http://www.nyaip.net/
Description:
Create a distributed packaged application that rates and quotes Automobile Insurance based on the rates published by the NYS Automobile Insurance Plan. The application allows brokers to create quotes, finance agreements, and applications. Once completed, the applications can be uploaded directly to the nypass web-site. The application is a Microsoft Access XP database that runs in Microsoft runtime environment. The application can be run as a standalone application or a network application.
Client: CAPTAIN
Project: Network Integration

Technology used: Windows 2003 Server, Windows Terminal Server, SQL Server 2000, Wireless 802.11/g, VPN Services

Description:
Support and manage Windows 2003 LAN/WAN network. Manage a mix of 50+ clients PCs consisting of Windows 95, 98, ME, 2000, and XP. Manage Windows 2003 Domain servers which included Antivirus, Mail, Print, Terminal, SQL Server, Internet services. Management duties include new user creation, PC/Server configuration, router configuration, software/hardware installations, Switch/Hub/PC/Server maintenance. Provide Help Desk support services to 50+ users from 3 separate locations. Maintain LAN backbone equipment and provide IT planning services on procurement and systems migration/implementation. Help desk services. Provide remote support to 50+ users utilizing Dual Desk, a remote support software solution. Help Desks tickets are logged, managed, and monitor via a web based help desk solution called Autotask (www.autotask.com). Service technicians are dispatched for warranty work and break/fix services. Technical support and general troubleshooting service are provided remotely. A 24/7 answering service is in place to page technicians during weekends, holidays, and after hours.
Client: City of Watervliet
Project: Employee Database

Technology used: Microsoft Access 97

Description:
Design an Access database to track employee information such as: administration, training, security & discipline.
Client: DinoSaw
Project: Work Order / Invoicing Application

Technology used: Microsoft Access 97

Description:
Create an Estimating Database For sales force. Enhances current structure to allow entry of new values and the recording of costs. Develop a custom Work Order database which enables the company to track service orders. Functions include custom pricing pre customer, Invoice printing and Upload feature to Traverse Accounting system.
Client: Empire State College
Project: Training Sessions Application

Technology used: Microsoft Access 2000

Description:
Design a Database in Access 2000 to track Training Sessions.
Client: Enhanced Business Systems
Project: MTX Municipal Accounting custom reports

Technology used: Microsoft Access 97

Description:
Designed custom reports for MTX Municipal Accounting for Office, accounting software used by towns, villages, and cities in the state of New York. The application was designed for distribution (runtime version of Access), for which an Attached Table Manager had to be designed to attach tables from three different Access databases.
Client: Evergreen Slate Company, LLC
Project: Network Integration

Technology used: Windows 2000 Server, SQL Server 2000

Description:
converted their existing IPX/SPX Novell based network environment to a TCP/IP Windows 2000 server based environment. Installed and configured print servers, high speed cable internet access, POP email accounts, and web-site hosting. Provide the client with a complete redesign of their website using Dreamweaver 4.0. Effectively migrated 3 servers into 1 easily manageable HP Server. Also designed an Access database to store Job History information.
Client: GE Plastics
Project: ColorXpress customer service / management reports

Technology used: Microsoft Access 97

Description:
Revamped an Access 7.0 (95) database used in the color matching process. The database interfaces with several other Access databases to produce custom views and reports. The application was used to log phone calls from customers, schedule projects within the business unit, and produce customer approval letters for mailing. The application also records start/end times of specific processes in the manufacturing process via bar code scanning and entries made in external databases.
Client: GE Plastics
Project: Year 2000 Conversions

Technology used: Microsoft Access 2.0, Microsoft Access 95

Description:
Tested 31 Access 95 and Access 2.0 databases for Year 2000 compliance. Converted 12 Access 2.0 applications to Access 95. Installed and configured Windows NT Server 4.0.
Client: GE Plastics
Project: MRP Database

Technology used: Microsoft Access 97

Description:
An Access database extracts information from an Oracle based system and organizes the data into a report format to be used for forecasting purposes. The procedures for extracting the information are correct and information is accurate. Problems arise in the performance and operation of the application. The processing time for updating the information is several minutes long and ties up most of the resources on the PC performing the process. Updating the information often causes the application, and sometimes the operating system, to hang. GEP wishes to eliminate the errors that cause the application to hang and increase the performance of the application.
Client: GE Plastics
Project: Raw Materials

Technology used: Microsoft Access 97

Description:
Track Inventory of Raw Materials via Bar Code Scanners. Users scanners for Items received, obtain usage from ID Batch.
Client: GE Plastics
Project: Stable Operation Reports

Technology used: Microsoft Access 97

Description:
Created Access Database which pulls an Extract from Oracle tables to an Access Back-end.
Client: GE Power Systems
Project: Assess Management

Technology used: Microsoft Access 97

Description:
Developed an Access 7.0 database for GE Power Systems to inventory computer hardware, software and paraphernalia for sites in Asia.
Client: GE Power Systems
Project: GE Power Applications

Technology used: Microsoft Access 95

Description:
Designed an asset management application in Microsoft Access to track computer assets for GE Power Systems. Application was developed for multiple users with a separate front end for each department. The application tracks lease data, asset information, hardware and software information, user and location. The application possesses links to the Human Resource database and the IMS LAN/email account database.
Client: Institute of Health and Human Services
Project: Foster Care Solution

Technology used: Microsoft Access 97

Description:
Created a multi-user application in Access 97 to track billing information. The application assists IHHS in reconciling bulling records for Omedia County Foster Care Program. The database produces a variety of reports required by the county and New York State Education Department. The application also produces an export file of billing records which is electronically imported into the KIDS system (a DOS based application belonging to NYS Education Department). The application contains custom functions that ensure data entry and automates reconciliation. A setup program was created to install the application, shortcuts, and Active X controls on the Userís PC
Client: Institute of Health and Human Services
Project: OCDOH Database

Technology used: Microsoft Access 97

Description:
Foster Care Data Reporting Application designed in Access 97 which create a variety of reports used to reconcile transactions between NYS Education Department and the Onedia County. The application encompasses data from 10 diffeent years and contains over 30 exception reports.
Client: Internet Commerce Association
Project: ICA

Technology used: Website

Description:
Developed and designed a Web Site for the Internet Commerce Association (ICA). FrontPage and Visual InterDev were used as development tools. The site includes Active Server Pages (ASP), ActiveX controls, VB Script, and ODBC calls to Access Databases. Current enhancements consist of a Chat room, upsizing the Access databases to SQL Server 6.5, and implementing E-Cash (Internet credit card acceptance software).
Client: KeyCorp Leasing Ltd.
Project: Sales Tax Applications

Technology used: Microsoft Access 2.0, Microsoft Access 95

Description:
Developed a series of Microsoft Access databases for the Sales/Property Tax Department. A master database was created to house all the data and contain queries and macros for administration purposes. The second database tracks sales tax returns, payments, prints reimbursement reports, creates check requests, automates sales tax reports, and features an Accounts Payable upload to Quicken. A similar database exists for the property tax side, tracking returns, assessment dates, and features an AP upload and Accounts Receivable export to the McCue Leasepak system. Conceptualized and produced a combined system of tracking and storing property tax bills, utilizing a scanner and linking to current property tax management system. The application is an Access database that uses ODBC drivers that link to a FoxPro 2.6 database. Primary person responsible for administering PTMS (Property Tax Management System) software used for property tax reporting. Duties included extracting lease information off the McCue system using Round Trip and Microsoft Access, reformatting, and importing into PTMS. Also completed the initial set up and updating of depreciation tables. Initiated the use of AP/AR export functions by developing applications to interact with PTMS exports. Responsible for the configuration, setup, and administration of CORPSales, software used to process sales tax returns. Duties included mapping state returns for three leasing companies, assigning user rights and privileges, and importing monthly sales tax reports. Created an Access 2.0 database that cleaned up files from three different systems and merged them into one file. This file was then imported into PTMS for property tax filing purposes.
Client: Lot Tracking Database
Project: Lot Tracking Database

Technology used: Microsoft Access 97

Description:
Create an Access 97 application which import data from two different systems and relates the information together. Let users edit the information in that is imported. Create various tracking reports.
Client: Manfred Real Estate Learning Center
Project: Network Integration

Technology used: Windows 2000 Server SBE

Description:
Installed Windows 2000 Domain Server with Microsoft Exchange, Internet Information Services (IIS), and Terminal Server. Wired the building with Category 5 cabling, installed patch panel, racks, switches, routers, and UPS. Configured LAN router and wireless access point. Implement network security via routers, Microsoft Windows 2000 Server, and business procedures. Installed Kyosera printer, copier, fax and scanner used for printing and scanning. Installed and configured several HP Laser printers. Provide on going services though help desk support and equipment maintenance. Provide network maintenance via backup services, patch installations, and network monitoring. Maintained computer asset records and was responsible for the procurement of additional computer/network hardware and software.
Client: Manfred Real Estate Learning Center
Project: Course Management / Order Entry System

Technology used: Microsoft Access 2002, Windows 2000 Server, SQL Server 2000

Description:
Built their custom Course Management System in MS Access XP and SQL Server 2000. The application tracks students, courses, and registrations. The business critical application produces a variety of reports and contains many functions such as: invoices, course completion certificates, Department of State reports, enrollment/registration forms, and income reports. The application also contains web upload that allows users to search available courses and register online. Other services for Manfred included Cat 5 wiring of facility, network integration of a Windows 2000 server w/ Exchange and Terminal Services, VPN and wireless setup.
Client: MBH Educational Products, Inc.
Project: Online Course Management System

Technology used: Microsoft Access 2003, Macromedia Dreamweaver, Macromedia Fireworks

Description:
This online application is written in HTML & ASP (VB Script). The application delivers online real estate continuing education courses to students. The application included a shopping cart, SSL Security, Access Database back-end, ASP front end. Responsible for the entire project - from conception to the final product. This online course delivery system is utilized by 6 NYS Approved Real Estate Schools. As of December 2005, more than 1,100 students have enrolled in over 1,500 classes.
Client: Mechanical Management, Inc
Project: Network Integration

Technology used: Windows 2000 Server

Description:
Implemented a LAN/WAN solution between 2 sites in Rotterdam Junction, NY. Installed and configures a Windows 2000 server, 10 Windows 2000 Professional Client PCs, and 8 Windows 98 Client PCs. The sites contain a T1 Point-to Point connection that utilizes Cisco 1700 Routers. Configured POP email accounts, high speed cable internet access, tape back-up, NAV Corporate edition, and Symantec PCAnywhere 10.5.
Client: MM Hayes
Project: Contact Database Replication

Technology used: Microsoft Access 97

Description:
Restructure current Access Database to allow for replication. Set up database replication on network.
Client: NCBA
Project: HelpNet Application

Technology used: Microsoft Access 97

Description:
Constructed Microsoft Access 97 application to track clients for long term care programs, HelpNet and discount cards process. The application automatically exports and emais a fixed width file to an Afilate in Florida.
Client: New York State Education Department
Project: PAP Database

Technology used: Microsoft Access 97

Description:
Create Access 97 application which tracks case and client information. Information from a vendor system is automatically uploaded to the PAP database app,ication.
Client: New York State Education Department
Project: State Ed Regents Testing

Technology used: Microsoft Access 97

Description:
Developed an Access 97 application used in the Regents Testing program. The application assigns schools to regents tests, provides packing slips, contains school participation request forms, prints mailing labels, and has a variety of summary reports. The application allows users to easily track the testing process, allows for easy customization of reports, and contains an import function.
Client: New York State Office of the State Comptroller
Project: VendRep

Technology used: Microsoft Access 2003, Oracle 9i

Description:
Created an Access XP application (VR Beta System) for the VendRep unit of NYS OSCís Bureau of Contracts. The Application is critical to the VendRep Operational Team. It utilizes MS Access Security and is used by 10+ simultaneous users. The application interfaces with BOCís Contract Management System (CMS) via an Oracle ODBC connection. Information is downloaded from CMS into the VR Beta System. Contracts are assigned to VR Auditors for Vendor Review. The application tracks the review process as it moves from Auditor to Approver, to Workflow Coordinator. The application has a variety of reports which generate from both the VR Beta System and the CMS System. Utilized both Crystal Reports and InfoMaker to create SQL for a variety of Processing Time Reports.
Client: Novus Engineering
Project: Novus Engineering

Technology used: Microsoft Access 97

Description:
Provide consulting services to Novus Engineering on the development of an in-house accounting system.
Client: NYSDOT
Project: Custom Training

Technology used: Microsoft Access 97

Description:
Customize Access Training Program in Access Security.
Client: Parmelee's Enterprises, Inc.
Project: Invoicing / Accounts Receivable Application

Technology used: Microsoft Access 97

Description:
Modified Existing Database to allow users to print out statements for customers. If possible have data uploaded to the Peachtree Accounting system.
Client: Parmelee's Enterprises, Inc.
Project: Expense Reporting

Technology used: Microsoft Access 95

Description:
Create an Access 95 application to record Expense Information
Client: Perrone Leather
Project: Order Entry, Accounts Receivable System

Technology used: Microsoft Access 97

Description:
Created an Access application that allows users to track inveroty, customers & oreders.
Client: Power Technologies, Inc
Project: Software Procurement Application

Technology used: Microsoft Access 97

Description:
Developed several custom applications for Power Technologies Inc., an international utilities consulting firm, headquartered in Schenectady, New York. Features of the application includes: automation of monthly financial reports (Income statement, balance sheet, and cash flow report); tracking of employee hours and interdepartmental transfers; and projecting project forecasts. The applications require extracting data from an Oracle database. Later enhancements to application included upsizing to SQL server and placing data on the Internet.
Client: Power Technologies, Inc
Project: Accounting Reports

Technology used: Microsoft Access 97, SQL Server 7.0, IIS 4.0

Description:
Developed Company wide databases to track clients, site locations and contacts. Application was developed on SQL Server 6.5. A Microsoft Access 7.0 application was created to front end the SQL Server for data entry. Microsoft Front Page and InterDev were used to create Web pages used by company employees to the SQL Server.
Client: Power Technologies, Inc
Project: Software and Education Departments

Technology used: Microsoft Access 97, SQL Server 7.0, IIS 4.0

Description:
Developed Company wide databases to track clients, site locations and contacts. Application was developed on SQL Server 6.5. A Microsoft Access 7.0 application was created to front end the SQL Server for data entry. Microsoft Front Page and InterDev were used to create Web pages used by company employees to the SQL Server.
Client: Power Technologies, Inc
Project: Reliability Services Department

Technology used: Microsoft Access 97

Description:
Converted and enhanced an Access 2.0 database to an Access 8.0 (97) application. Enhancements include custom help files and run-time ability. The application is used by Utility and Power companies to track and analyze power outages and disturbances. This application provides statistical data and reports to help power companies and World Countries improve their electrical power system.
Client: Rensselaer Polytechnic Institute
Project: 2002 Annual Budget-Access

Technology used: Microsoft Access 2003, Citrix

Description:
Developed an Access database that resides on a Citrix Server, which allowed the budgeting department to create their 2002 Annual Budget. The application contains it own security module and automatic update functionality. The Budget Database splits a Master database file up into about 20 separate databases, 1 for each department. Each department updates their perspective database, and then the data is merged back into the Maser File so it can be imported into the schools primary accounting system.
Client: Richmor
Project: Richmor Invoice Application

Technology used: Microsoft Access 97

Description:
Create Custom Invoices from Accounting System
Client: SAANYS
Project: Expense Tracking Appleton

Technology used: Microsoft Access 97

Description:
Converted a PFS database program to Access 97. The database tracks teacher contract information, legal expenses and yearly survey information. Information from the PFS system was exported as text files, then imported into Access where the information was cleaned up before finally be uploaded into the new Access database.
Client: Saint Gobain Performance Plastics
Project: Vacation/Sick Time Tracking

Technology used: Microsoft Access 97

Description:
Created a Sick/Vacation time tracking application in Access 97. The application calculates and tracks employeesí available sick and vacation hours throughout the year. A variety of reports were designed including an Attendance report, vacation schedules, weekly overtime and current pay rate listing. Addition functionality included a vacation scheduling module, seniority calculation feature, sick time carry over procedure and a general wage increase module. Data from a dBase database was normalized and imported into the Access application.
Client: Saint Gobain Performance Plastics
Project: OSHA Incident Reporting Application

Technology used: Microsoft Access 97

Description:
Creates an Access 97 appellation which records Job Related Incidents (Injuries/Illnesses). A stand-alone appellation allows individual sites to record their information and automatically email the information to headquarters. A management module resides at corporate HQ, which complies all the individual site data for reporting purposes. The application calculates OSHA Incident rates and has a variety of graphs and reports. The application uses contains Active-X controls, Graphs, and an Auto-Export feature.
Client: Saint Gobain Performance Plastics
Project: HP 3000 Reporting

Technology used: Microsoft Access 97

Description:
Pull Data via ODBC from HP server and create Order Trend Charts. Client currently manually inputs the data from daily reports into an Excel spreadsheet. The charts are monthly order for exports, domestics, affiliates and grand totals. The information should be stored in Access tables, a form needs to allow users to build custom queries.
Client: Saint Gobain Performance Plastics
Project: Maintenance Project

Technology used: Microsoft Access 97

Description:
Converted a dBase II cataloging sytem to Access 97. The application tracks equipment parts/vendors and produces a catalog for the machine operators. A dynamic searc engine allows users to easily query the infromation in the database.
Client: Saratoga Search
Project: Appraisal Abstracting/ Accounts Receivables Application

Technology used: Microsoft Access 97

Description:
Developed an Access 97 database to track title searches preformed by the company. This information is entered into the Access application then faxed to clients in custom report format. The application has increased the number of searches processed by an employee per day by 100%.
Client: Schenectady County Community College
Project: Access Training

Technology used: Microsoft Access 97

Description:
Taught Microsoft Access classes to various companies and government agencies through a program offered by Schenectady County Community College.
Client: Schenectady International, Inc
Project: Six Sigma Project Tracking

Technology used: Microsoft Access 97, Oracle 8i, IIS 5.0

Description:
Design a Web Based project tracking system for Six Sigma Projects. The application resides on an Oracle 8.0 server and an IIS 5.0 server. Active server pages (ASP) are used to add, update, and view information stored in the Oracle database. An Access front end was also designed to allow a Database Administrator manages users, data, and design custom reports. The application is used by over 100 users across the US and overseas.
Client: Schenectady International, Inc
Project: EDI Database

Technology used: Microsoft Access 97, Citrix, Oracle 8i

Description:
An Access database retrieves information from JDEdwards and creates Bills of Lading, which are emailed to clients and transferred via FTP to the Union Pacific Railroad for processing.
Client: Schenectady International, Inc
Project: Tank Car Database

Technology used: Microsoft Access 2003, Citrix, Oracle 8i

Description:
An Access Database that manages SIIís railcar fleet for multiple sites at multiple plants. The application pulls open purchase and sales orders from JDEdwards and allows users to assign Rail Cars to the order. The database pulls daily Rail Car scans via FTP from a national rail car reporting agency, so users can track the current location of the rail car. The application is a business critical application and the primary operation tool used by SIIís OPD and Logistic departments. The database resides on a Citrix Server and also incorporates a Bar Code Scanning design using Symbol Technologiesí MCL tools.
Client: Schenectady International, Inc
Project: Pricing Database

Technology used: Microsoft Access 97

Description:
An Access database that calculates the quarterly pricing adjustments to SII chemical divisions products, based on changes in Raw Material prices. The application creates a price change report and custom letters to notify customersí purchasing department of the update price.
Client: Schenectady International, Inc
Project: Finishing Reports

Technology used: Microsoft Access 97

Description:
Design Custom reports for Finishing in Microsoft Access. Information pulled from an Oracle Database System.
Client: Schenectady International, Inc
Project: Varnish Database Conversion

Technology used: Microsoft Access 97

Description:
Convert 4 Varnish databases from Access 2.0 to Access 97. Incorporate into 1 mdb file and burn to a CD.
Client: Schenectady International, Inc
Project: Test Lab Database Conversion to Access 97

Technology used: Microsoft Access 97

Description:
Convert 2.0 Database applications to Access 97 at the Niskayuna Plant in the Test Lab.
Client: TAG
Project: Communications Directory

Technology used: Microsoft Access 97

Description:
An Access applicatons tracks phone extensions and oorisponding information. TAG uses the application where transitioning its client to a new phone system. Users can esily cross refernece old pnone numbers, jacks, lines, etc. with the new ones
Client: The Desmond
Project: Charter Club

Technology used: Microsoft Access 97

Description:
Installed and configured Novell NetWare Client 2.5 on 3 PCís. Developed an Access 97 application which uses ODBC to connect to a Btrieve reservation database (LandMark). The application tracks charter club points, prints monthly score cards for customers, and produces a mailing list (the Charter Club program rewards preferred customers points which can be redeemed for meals, rooms, etc.).
Client: Tocci, Parker & Tocci
Project: Asbestos Database

Technology used: Microsoft Access 97

Description:
Developed an Access 97 application which tracks Asbestos case information. The application captures contact & case information and tracks the process of the Asbestos case process. Financial reports are generated from case settlement information to assist in bookkeeping.
Client: Tocci, Parker & Tocci
Project: TPT Database

Technology used: Microsoft Access 97

Description:
Access 97 Application used by Law Firm to track Clients and Case Information. The application uses the Data Outline Active-X control for its main interface. This multi-user application contains auto case numbering features, label generator and automates entries of contact information.
Client: Town of Webb
Project: Payroll & Budget Reports

Technology used: Microsoft Access 97, MTX Municipal, Accounting

Description:
Created 4 custom reports in Access 97 from the MTX Municipal Accounting for Office. Reports included an Operating Statement Summary, Operating Statement Detail, and 2 payroll summary reports.
Client: Win-Win Transactions, LLC
Project: Investment Property Tracking Application

Technology used: Microsoft Access 97

Description:
Created an Access 97 application, which records property information and tracks the foreclosure process. Application includes a Phone Log module, Letter Mailing and Tracking function and photo storing ability. Advance functionality automates the printing of letters and mailing labels based on a schedule created by the end user.