I drive a concrete truck and need a db to save all my loads and the amounts of money I get paid for those loads each day, week, fortnight, month, quarter and FY. Hopefully this can be done by submitting each load quantity and distance travelled on a set day by accessing a spreadsheet that has all the load quantities and distances travelled on it (I will manually change these every 3 months as they are updated every 3 months). Then the data input will be saved in the weekly, fortnightly, monthly, quarterly and FY spreadsheets.
I need a database that:
1 - I can double click on an icon of my choice (the picture can be changed later if need be);
2 - The db will then greet me with a window asking me "Please input your Docket Number, Date, Load Quantity and Distance Travelled for every load today to be calculated;
3 - Then the data will be saved in a Daily, Weekly, Fortnightly, Monthly, Quarterly and FY spreadsheet;
4 - Then the db will also calculate the BAS (BAS is and acronynm for Business Activity Statement and is for a type of tax. The BAS amount which is 1/11 or one eleventh of each total load amount;
5 - The db will also calculate the total m3 (metres cubed) carried on a Daily, Weekly, Fortnightly, Monthly, Quarterly and FY basis which is at the bottom of the relevant spreadsheets; and
6 - Lastly I would like to be able to run reports either represented in the spreadsheets I have created but if it can't be which I suspect it can't then that's OK, an Access report format is great. I will be buying a new PC and running either Windows 7 or Windows 8.1 with Office Pro 2010.
I can provide the xls when needed.
Databases expert for over a decade. Master in Information Systems.
I have delivered similar projects in the past. Please check
my portfolio for:
[login to view URL] Lollipop (video demonstration)
[login to view URL]
and feedback at
https://www.freelancer.gr/u/paris2785.html
I can start right away. For any questions, please let me know.
Paris
$130 AUD σε 5 ημέρες
4,9 (12 αξιολογήσεις)
4,0
4,0
6 freelancers δίνουν μια μέση προσφορά $155 AUD για αυτή τη δουλειά
Hi: I have few questions that I want to clarify: Do you a need a standalone program that installs on your system or do you need a MS Excel spread sheet with a user Interface (In MS Excel, user interface can be designed)? Have you decided on the design of user interface you want? (placements of input field etc.) ? You said that "you would like to be able to run reports ", did you mean that you would like to filter the data based on some criteria? Please connect with me to discuss more.
Can create you a program that will do this.
Please give sample xls files, Thanks.
VB Programmer here. Got 7 years Experience in Web Programming, Software Programming and Database Design.
Regards,
mleo
Hi,
I can start this application development right now.
Will be able to deliver you initial functionality (without excel reports) by Monday . With this version you will be able to:
1. Enter your daily activity details.
2. View Logs based on daily, weekly , monthly, yearly or between given dates.
3. View BAS reports for daily, weekly , monthly, yearly or between given dates.
4. View M3 (Meter cube reports) daily , weekly , monthly or between given dates.
Once you used all these and you are ok I will proceed to reports generation, reports will be generated in excel format in your required format.
Looking forward to discuss with you more on this.
Regards.