Samples of Projects Utilizing Access
SAMPLE # 1
All samples shown on this page are samples of projects that I completed for dj Orthopedics.
The first sample below you will see a database that I created and designed. The main purpose of this database was for internal use by approximately 30 dj Ortho employees.
The database stored Insurance Contract Information consisting of approximately 300 Nationwide contracts. I also designed the database to specifically meet the needs of customer service representatives. As you can see, I created a Main Switchboard with several options.
The bottom portion will show you the report that appeared if the first button (option) was clicked on the Main Switchboard. It is basically a report that shows ALL Insurance Contracts listed alphabetically.
Some of the steps required to complete this project consisted of the following:
First, I linked the tables required to run the reports from a different Access database that was completely controlled by me, the main user
The second step was to store it in a folder in the company's S:/ (share drive) to ensure everyone had accessibility
Next, I created the Switchboard page big enough to occupy the whole computer screen, this made it easy for the users to quickly choose an option
The next step was to test the Swithboard options to ensure the commands worked properly
Finally, I created a shortcut on every users desktop for quick and easy access to the database
Time required to complete database: 4-6 hours (includes testing time)
SAMPLE # 2
The following samples will demonstrate 2 forms that I created to assist a user, track compiled information from Sales Representatives. The user was a Contract Coordinator and his job consisted of collecting information, getting approval from Management, and finally sending contracts to Sales Representatives.
The Form at the top (in gray) kept track of information sent in from Sales Representatives prior to getting approval from Management to send out a contract. As you can see, I created something similar to a checklist and areas to keep notes for status history.
The Second form below (in blue), kept status of dates that contracts were sent out, received, signed, and returned to customers. It also listed account #'s, and Comments. This also allowed me to create status reports that identified what contracts had not been returned and what contracts were completed.
SAMPLE # 3
The sample below is simply a report I created that shows all Active Accounts per Region in Alphabetical Order. The company divided the United States in 4 regions to include North East, South East, North West, and South West. As you can see, this specific example shows accounts in the South East (SE) Region.
LINK TO THE HOME PAGE
RETURN TO TOP OF PAGE
