Develop a database in Access:
On the main window should be placed 4 buttons:
? Sales Offices
? Plan clearance sales offices
? Media Plan
The main window
1. When you press the "mass media" that have opened the window, which will be a list of the media (print, television and
etc.). Details: Title media (eg newspaper "Chance"), address, phone number, website (if they have), as that would be
it was possible to assign to each media price list format (* .pdf or * .doc, does not matter) It is also necessary to add the button:
add, edit, delete the attachment, printing (report as a phone book fields: media name, location,
2. "sales offices" is similar. Data: the name of the office (for example, a sales office in the Soviet area), location,
phone number, just need to be able to fix the photo report of the office (similarly as the price list for media) Options:
add, edit, attachment (to fix photos), printing (report in the form of a phone book: the name of the office space
location, phone number)
3. "media plan".
Required fields: budget, region, product, quarter, month, type of media, the name of the media, Circulation volume publication format
edition, the theme plan (amount). The user must fill the fields themselves.
Fields, who should be a function of choice:
? The name of the media (choose from paragraph 1, "the media")
? Kvartl (1,2,3,4)
? Month (January, February, March, April, May, June, July, August, September, October, November, December)
The end result should be reduced to a table with a cap (Figure 1) and should be able to be viewed in Excel or Word.
4. "plan sales offices" like the "media plan" with the same features. The fields for entering information: the name of office
sales, design elements and characteristics, commissioning date, the appointment item, the contractor, the amount of
units of production (manufacturing cost per unit. rubles, the planned production period), 1 rental units. (Value
month, rub .; number of months), the total cost, the total number of fixed offices, the total number of SCPs and CEC ruling, the total
the number of sales outlets in total, we plan to issue (not in the couple journeys and discoveries).
The fields with the function selection:
? The number of months (1,2,3,4,5,6,7,8,9,10,11,12)
? design element (a typical tablet, illuminated signs, lamp replacement, frame by imedzhevye documents, signs, repairs
? Purpose element (routing, exterior design, interior design, mobile sales offices)
The end result should be reduced to a table with a cap (Figure 2) and should be able to be viewed in Excel or Word.