how to make database from the scratch in micro 5 3700

[chatter1022]

hi i'm new in micros if someone can help me how to make database from the scratch..., creating item, menu panel, discount, printer, user/access

 

[kknoy]

Chatter there is a how to micros supplies for creating a database from scratch. The big things we found was separate your menu items into groups and leave plenty of room (10 to 100 thousand of room per type of item. Same with employee jobs groups. It makes reporting much more pleasant to look at. Making Screens is completely different based off the functionality of the business. As for User/access I recommend having at least two property experts but not everyone being that level. They typically have global control.
I hope this helps.

 

[hosehead78]

Agreed with kknoy. I would suggest writing it out first. Create an excel spreadsheet of the different types/styles and such that you are going to have. Give yourself enough space between these numbers for new items.

Example:
Beverages (Major Group)
|---Non-Alcoholic (Family Group)
|---Soda (Menu Item)
|---Water (Menu Item)
|---Milk (Menu Item)
|---Tea (Menu Item)
|---Coffee (Menu Item)

|---Beer (Family Group)
|---Bottle (Menu Item)
|---Draft (Menu Item)

|---Champagne/Wine (Family Group)
|---Champagne (Menu Item)
|---Red Wine (Menu Item)
|---White Wine (Menu Item)

|---Cocktails (Family Group)
|---Screwdriver (Menu Item)
|---Bloody Mary (Menu Item)

Food (Major Group)
|---Breakfast (Family Group)
|---Eggs (Menu Item)
|---Sandwiches (Family Group)
|---BLT (Menu Item)

and so on.

Then setup each menu item in a range. Making each range of numbers for each section of Family Groups.

Example:
Family Group: Non-Alcoholic
Number Range: 100-999 (Can be a smaller range if necessary)

Family Group: Beer
Number Range: 1000-1999

Family Group: Breakfast
Number Range: 6000-6999

Giving yourself a good amount of space between each group allows for future additions, so that like menu items aren't all over the board.