MS access database design

  • Posted:
  • Proposals: 5
  • Remote
  • #658620
  • Awarded
Alex F.
Blessing I.Eldon C.David H.David K. have already sent a proposal.
  • 2

Description

Experience Level: Expert
General information for the business: Customer accounts and invoice creation
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: Tables:

Customer:
Customer ID (Should be automatically formatted as (initials+4 randomly selected numbers, e.g. BH8263))
First name
Last name
Invoice Address 6 lines
Shipping Address 6 lines (if applicable, does not have to exist)
Telephone number 1 and 2
Email address

Vehicle: (Linked to customer table via customer ID)
Vehicle ID (sequential 4 digit number)
Registration (Should be 10 char as we have foreign cars and also personalised registrations)
Make(14 char string)
Model (20 char string)
Mileage (up to 1000000 miles)

Job: (contains customer ID and Vehicle ID)
Job ID (should be automatically generated by Customer ID, Vehicle ID and "current" Date e.g. BH8274-0284-120115)
Job Description
Total Cost

The following forms are required:
Main menu to access functions via big easy to click buttons
New customer form to insert a new customer infomation.
Customer/vehicle/job search screens to locate a customer by way of inputing any customer related information
Results should display on the same page as the search function to enable rapid searching.
Results should include customer information, customer related cars and a list of jobs ordered by date.
Edit customer/vehicle/job functions.
Delete customer/vehicle/job functions
Add/edit/delete must be tested to function regardless of number of vehicles/jobs there are.
It is entirely possible for two customers to own the same vehicle at a different time.
Form to create an invoice for each job with a large print button.
An example invoice company information and format is attached.
A company logo should be included at the top of the invoice.
Company logo is attached.
Extra notes: Only seeking developers who can deliver a FINISHED and fully working product within 3 days.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.