Coursework.Info - Inspiration in an Instant

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

Database Techniques and Applications Report User Needs My database will be designed for a major florist company called 'FuNkY FlOwErS', the company has requested for me to design a database, which will enable all records of customers, the flower package they've chosen, and the sales, to be recorded in one document. The database will enable the staff operating the database to store and retrieve information, which is relevant to the sales. In order for the information in my database to remain secure, reliable and private. Information to be processed I have included three tables in my database and their names are as follows: * Tbl Employees * Tbl Flowers * Tbl Suppliers Customers Field Name Data type Field size Customer ID Auto Number Surname Text 20 Characters Forename Text 20 Characters Gender M/F 1 Character D.O.B Date/Time Medium date House number Number 5 Characters Post Code Text 10 Characters Tel. 1 Number 20 Characters Tel. 2 Number 20 Characters Mobile number Number 20 Characters Email address Text 20 Characters Member Yes/No 3 Characters Date Joined Date/Time Medium Date Above I have shown the contents of the first table I created in Microsoft Access, this was the first step of creating...

Get instant access

• Instant, unlimited access to our documents in full
• Swap your work for free access, or pay £4.99
• To see the full version of this document and 150,112 others