please modify the DB [login to view URL] Access 2000
this DB is about **auto sales and rentals ,it will be used as a back end. ****
please try use the same names .
**1-the DB has no relation, create a **relation** set all **primary** keys and **foreign** [login to view URL] together as needed
2-Avoide **duplicates** in the attributes DB make it consistant .
3-write **queries** instead of using too many tables
4-modify the existing reports make customized reports.
5-create **customized forms** for the DB for all
6-Create a **switchboard **for all reports forms query add a clip art car shape.
7-be able to view and print forms reports tables queries from switchboard
8-be able to calculate payment plus tax for sales and rentals from the switchboard or forms.
9-must be able to view everything from the switchboard.
10-create a macro and run.
***11-Create good documentation and ER model about project
***
I am trying to do most of the sales and rentals from access and have another option of doing it from the VB program.
------------------------------------------
please do not worry about the VB program now.
this DB have a VB 6.0 program to it but for now I only need to modify the DB to be consistant then I will modify the program based on the consistant DB.
when I run the VB program I am able to do the following.
create sale
create rental
updates inventory
payments
log in
view all sales and rentals
add employees
plse see tables I was able to do all that.
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
2)must have all requirments to accept
## Platform
XP ,mel