Find Jobs
Hire Freelancers

Access/VisualBasic DB restructuring

$100-500 USD

Closed
Posted about 16 years ago

$100-500 USD

Paid on delivery
This is an Access 2000 database that was created by an employee no longer accessible. It was conceived as a bunch of spreadsheets more than as a strict relational database approach. The big problem: Employees are COLUMNS (fields) in the forms and tables that describe their daily sales. Adding one new employee means changing table structures etc beyond what the in-office clerk can handle. I created an EMPLOYEE table and a New_BillDate table. The first will make it easy enough to add an employee or inactivate one. The second now holds the history in the new layout. What's needed: All forms and reports need to be re-directed to pull information from these new tables instead of the old ones and a sub-routine to exclude inactive employees needs to be added to all pertinent reports and forms. This includes Visual Basic buttons calling functions from the main form. ## Deliverables The resulting MS Access 2000 application must be restructured and VERY EASY TO MAINTAIN by an employee with certain ability with MS Excel but no real concepts about relational databases. Preferably, some standardization of names and procedures would be a plus. The newly created New_BillDate_frm form needs to be embellished and the processes to pull data need to be preserved as much as possible to minimize personnel re-training. There are indications in the MENU form (the main form that pops up automatically when first opening the database that will help to understand both how the addition of employees was originally conceived and how to use that form.
Project ID: 3748656

About the project

3 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $208 USD for this job
User Avatar
See private message.
$425 USD in 14 days
4.7 (52 reviews)
6.4
6.4
User Avatar
See private message.
$114.75 USD in 14 days
5.0 (12 reviews)
3.3
3.3
User Avatar
See private message.
$85 USD in 14 days
4.9 (7 reviews)
2.4
2.4

About the client

Flag of UNITED STATES
United States
4.9
7
Payment method verified
Member since Sep 4, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.