Note: If the yellow Message Bar appears when you open a file, you must click on "Enable Content" button.
The ready database access «The account by the TV company of cost of the passed in air of advertising»
Description of the subject area.
You are the head of the commercial service of the television company. Your task is to track the calculations associated with the passage of advertising on TV. The work is structured as follows: customers are asked to place their ads on a specific program on a certain day. Each advertisement has a certain duration. For each client organization, the bank details, telephone number and contact person for negotiation are known. The programs have a certain rating. The cost per minute of advertising in each particular transmission is known (determined by the commercial service, based on the rating of the transfer and other considerations).
Transmissions (Transmission Code, Title, Rating, Cost per minute).
Advertising (Advertising code, Transmission code, Customer code, Date, Duration in minutes).
Customers (Customer code, Name, Bank details, Telephone, Contact person).
Development of the formulation of the problem. As a result of the operation of the database, it became clear that it was also necessary to store information about agents who had concluded advertising contracts. The salary of advertising agents is a certain percentage of the total cost of advertising that took place on air. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.
Task for creating a database in a Microsoft Access environment
The order of the work:
• Selection of the subject area in accordance with the student´s serial number in the journal;
• Analysis of the textual description of the subject area;
• Selection of table structures and their creation;
• Filling in the data in the tables;
• Development of user interface. Creating forms;
• Creation of calculated queries;
• Creating output reports.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at firstname.lastname@example.org the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)