Bd Video rental .mdb

Affiliates: 1,73 $ — how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 4
Refunds: 0

Uploaded: 15.09.2016
Content: Видеопрокат 2003.rar (173,02 kB)

Description

Bd Video rental .mdb Bd Video rental .mdb

Bd Video rental .mdb

Download the report on the database screen forms for free http://access.avorut.ru/1/videoprokat/263_otchjot_bd_videoprokat.doc

Note: If the yellow Message Bar appears when you open a file, you must click on "Enable Content" button.

Additional information

Task for the database access "Video Rental".

Option 27
Topic: video rental information system
Description of the information system:
The information system of video distribution is designed to automate the storage of information about films in the salon. The video rental information system should contain the following information:
- about available cassettes (code, name, category, etc.), customers (passport data);
- information about which cassettes are taken by whom, the dependence of the rental price on the category (cartoons, thrillers, detectives, etc.).
The output documents of the video rental information system are:
- a report on the number of cassettes for a particular client on a certain date;
- Information on the rental of a given video cassette;
- total revenue estimates for the reporting period;
- statement on payment for each client for the reporting period.

1. Create tables by defining properties for each field in the table.
2. Establish links between tables.
3. Create delete requests, add and update rows
4. Create two forms: simple (based on one table) and complex-subordinate (based on two tables, united by a one-to-many relationship). Place in the forms various control elements: fields with drop-down lists, buttons for launching queries and forms, and so on.

Option 7
Create a database "Video Rental".
The database should contain the following information: about available cassettes (code, name, category, etc.), customers (passport data), information about which cassettes are taken by whom, the dependence of the rental price on the category (cartoons, thrillers , detectives, etc.).
How many tapes do a particular client have on hand? Who has this cassette? Total costs per customer.


The task "Designing a relational database and its implementation in an Access DBMS
General requirements
1. Design a database using any design method. Determine the number, structure, and relationships between tables.
2. Create tables by defining properties for each field in the table. Ensure data consistency (foreign key requirement) by creating fields with substitution.
3. Establish links between the tables.
4. Create multiple queries:
1) Three sampling requests with complex selection criteria;
2) Three queries using group operations and statistical SQL functions;
3) Parametric query;
4) Cross-Request.
5. Create two forms: simple (based on one table) and complex-subordinate (based on two tables, united by a one-to-many relationship). Place in the forms various control elements: fields with drop-down lists, buttons for launching queries and forms, and so on.

Option 24
Create a database "Video Rental". The database should contain the following information: information about available cassettes (code, name, category, etc.), customers, information about which cassettes are taken by whom, the dependence of the rental price on the category. How many tapes do a particular client have on hand? Who has this cassette? Total costs per customer.

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market 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.)