3 Speak Style Guide
Introduction
The procedures below show how one can design a database management system by using Access whereby the database administrator can easily carry out several forms of manipulation to the data. It also shows how relational databases can be created and how they can be linked. The procedures for creating queries are also included as indicated below.
The Front Desk should be able to enter, modify and delete stock and customers from the system.
In order to modify data, first you need to open the database which you need to modify its dat. Open the database in a table format and on view tab choose the datasheet view. You can change the format for the cells depending on the data that you want to enter.
To delete data, open the database with the data and choose delete from delete tab as shown in the screenshot above.
linking the DVD rental code with customer names
The Front Desk should be able to enter DVD rental code into the search criteria and link with the customer.
Once the database has been created, click on the query tab and in the search criteria choose DVD rental code. The database will extract the information about the customer as every DVD rental code has a corresponding customer name.
When using this method, different tables are interlinked together so as to bring about the relational concept.
Finance should be able to run a daily query listing any customers that have overdue rentals during the previous business week for notification and billing purposes.
On the query tab choose the query design of your choice. In the field name choose customers with overdue rentals. Enter the charges depending on the amount of time a customer has taken with the DVDs.
Rules for overdue DVDs: after 1 day "?? phone customer; after 1 week send letter: system is to track this and associate a charge of $1.00 for every 24 hours the DVD is overdue
