|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
... C. ... E
I.C.T
COURSEWORK
Video Rentals
CONTENTS PAGE
Title Pg No. ... It be able to print out prices and customer details
ANALYSIS
I found out that there are approximately 1200 members at the Video rental store. ...
To make a database I must ask the customer their personal details:
Name
Address
Age
Phone Number
To gather then these points I will ask them to fill out a customer details form asking them for their personal details as above (Customer Data Capture Form). ...
I plan to use Microsoft Excel to make a table of each customer and their details. Then I can use that as a base unit to produce an Access Database. ...
Data Flow
When he first started his video rentals shop, Mr Rajah will enter the details of all the customers that have paid their membership. ... Rajah had the following comments and suggestions:
I have looked at your designs carefully and they appear to fit my needs. I do perhaps think that one or two aspects could be changed
1. I would like to have a search field so that a customer or a film can be found by just typing its name in. ... I would also like it if you could add a function so that if the film were lost or already rented out it would show on the system. This would make it easier for me as it would save time every time I go and search for it in the stock room. ... The details will be entered in manually with restrictions to the to the field length
Final Design for Customer Form
The report design and menu design do not change therefore I have no need to revise them.
I realised that there was no need for such a big space in my
Breakdown of Solutions into Subtasks
The implementation of the final design needs to be broken down into more manageable sub-tasks:
1. ... field Enter invalid data Will not accept
6 Test that a valid record can be added Click Create for extreme data file Accepted
7 Test the close form button Click Close form button Closes the window
8 Test the Actor/Actress button on the menu Add invalid data Rejects it
9 Test invalid data to see any restrictions Put text in a number field Rejected
10 Test reports See whether correct stock list comes up Correct
11 Print Reports Press print on report Printer activated
Implementation
The hardware that I am choosing to use is:
Input devices
Keyboard to enter words and figures
Mouse to select icons to run programs or select items from a menu
Output devices
Thermal printer It is commonly used in Supermarket till checkouts. ...
Visual Display Unit (VDU) good for quality colour and moving picture display
Storage devices
Hard disk it will come with the computer and can be used to store the data
Floppy disk to keep a backup of the files in the system
The most important hardware I need is a computer as its is essential for an efficient system.
The software that I am choosing to use is:
Word processors allow us to enter, amend and save texts or names and addresses of
Customers
Mail merge to send letters to customers who have failed to meet the deadline
Microsoft Access to make a database of the customers and to update their record
Every time they visit
Desktop Publishing to design the output receipt to give out to the customers
After the data has been given in to the data capture form the system will automatically update its record. ...
I used it in the insertion of telephone number where only a certain number of numbers can be inserted.
Approximate Word count = 3056
Approximate Pages = 12.2
(250 words per page double spaced)
|
|
|
|
|
|