New Menu Item Checklist (Business Requirements)
Required a simple template created in Microsoft Access to allow maintain a checklist. Currently this checklist is done in pen and paper. And having it done in Access will make the checklist easily accessible and user friendly.
Please provide a batch file for the template to launch. The template will be kept on a network drive and all access files created by the template will be saved on the same location. Please allow option (advise where i need to make the changes to allocate the path)to specify a network location for the batch to run from and all new access data to be saved to.
I have provided a sample template in Excel to illustrate the situation.
The main purpose of the template in access is to allow multiple users to use the template simultaneously. User will run the batch file from their local machine to open the template. The template will allow users to create a new promotion, open an existing promotion or make modification to an existing promotion. It also will have a report section.
When the template is run from the batch it will open up the program with the title bar and first three tab in row 2(please see the excel template). It will allow the user to create a new promotion, open and existing one or go to the reports section of the template.
Once the New promo button is selected the template will provide/create row 3-7(please see the excel template) for the data/information to be filled in. Once the data is filled, click on “Create Promotion” on row 8 for the template to be created. It should save the promotion with the same name as Promotion Name, on row 3. An Access DB file will be the file name and should be available on the network location.
Once the Promo is created, the template will provide row 10-30. Row 10 will be a static row. Cell A1-C30 is text field and allow user to insert data. Row D11-D30 is static and Row E11-Q30 will have drop down button with (‘Yes’, ‘No’, and ‘N/A’).
(+) on row A31 will create blank copy of the row 11-30 to row 31 to 50. (+) will appear on row 51 to add another blank menu item set.
(-) on row R11 will collapse the first menu item set. (+) will expand the set if collapsed. Reset will wipe all the data from the Menu item set (E11-Q30). Each Menu Item set should have these three options.
“Ok” will save the changes under the new promotion. “Cancel” will ignore all changes.
Details have been added on Previous Promotions sheet on excel.
Details have been added on Reports sheet on excel.
Please Note: Make the template as simple as possible and user friendly. You can play with the color and template.
3 freelancere byder i gennemsnit $43 på dette job
Hi.. Expert database developer here. Assure you accurate database according to your requirements. My bid is for exact database. Ready to start. Have a look at PM. Regards