Microsoft Access

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.

New Promotion:

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.

Previous Promotions:

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.

Kemahiran: Microsoft Access

Lihat lagi: microsoft business, microsoft access for business, Excel to Access, access microsoft, access multiple text, microsoft excel template, microsoft template access, batch batch excel file, create access template, menu item color, batch file name, changes data access, checklist excel, excel color cell, promo text, batch open excel file, access create report, create drop menu excel, access sample program, access excel template, drop menu excel, microsoft access sample program, create tab excel, create multiple access files, simple access sheet

Tentang Majikan:
( 17 ulasan ) Sydney, Australia

ID Projek: #4078103

Dianugerahkan kepada:


I would like to do this job for you. Please check PM for details.

$40 AUD dalam 5 hari
(1 Ulasan)

3 pekerja bebas membida secara purata $43 untuk pekerjaan ini


Dear Sir, I'm Expert on access. Best Regards, NourElDeen

$40 AUD dalam 5 hari
(18 Ulasan)

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

$50 AUD dalam 5 hari
(5 Ulasan)