• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  47. 47
  48. 48
  49. 49
  50. 50
  51. 51
  52. 52
  53. 53
  54. 54
  55. 55
  56. 56
  57. 57
  58. 58

Beanie Project.

Extracts from this document...


Contents: TIME PLAN: 1 IDENTIFY: 1 ANALYSIS: 1 DESIGN: 2 EVALUATION: 2 IDENTIFY: 4 PROBLEM OUTLINE: 4 SOFTWARE CONSTRAINTS: 4 Microsoft Word: 5 Microsoft Excel: 6 Microsoft PowerPoint: 7 Microsoft Publisher & Microsoft Works: 8 Microsoft Access: 9 Overview: 11 HARDWARE CONSTRAINTS: 11 Minimum Requirements: 11 Optimum Requirements: 12 END USER REQUIREMENTS: 12 Who will use this database? 13 ANALYSIS: 14 PROBLEM SOLVING: 14 COLLECTING INFORMATION: 14 DATA REQUIREMENTS: TABLES 14 DATA REQUIREMENTS: SOURCE 15 DATA INPUT: 16 QUERIES: 16 FORMS: 16 REPORTS: 17 MACROS: 17 DATA FLOW DIAGRAM: 19 DESIGN: 20 STARTING THE DATABASE: 20 TABLES & TABLE STRUCTURE: 20 QUERIES & QUERY STRUCTURE: 25 Relationships: 26 FORMS: 28 REPORTS: 30 MACROS: 32 TEST PLAN 33 Tables: 33 Queries: 34 Forms: 34 Macros: 34 Reports: 34 IMPLEMENTATION: 36 TABLES: 36 QUERIES: 38 FORMS: 40 Main Forms: 40 Switchboard: 41 Switchboard Options: 43 MACROS: 44 REPORTS: 45 TEST PLAN RESULTS: 47 Tables: 47 Queries: 48 Forms: 48 Macros: 49 Reports: 49 EVALUATION: 50 SYSTEM EVALUATION/REQUIREMENTS EVALUATION: 50 Hardware: 50 Software/Database: 50 END USER COMMENTS: 51 POSSIBLE IMPROVEMENTS: 51 Time Plan: Identify: Inputs Week Problem Outline 1 Software Requirements and Details 1 Hardware Requirements and Details 1 System Requirements 1 The problem will be outlined and identified showing what needs to be done and why the company has its requirements. The possible software will then be outlined and explained showing what is good and bad about each software tool, and this will be followed up by a more detailed explanation of the software. Then, the hardware will be identified with a brief description of what is needed to use and implement the requirements. After this, the system requirements will be outlined and explained. Analysis: Inputs Week Data Requirements Part 1 - Tables 2 Data Requirements Part 2 - Source 2 Data Input Explained 2 Queries Explained 3 Forms Explained 3 Reports Explained 3 Macros Explained 3 Dataflow Diagram 4 Here the problem is analysed in more detail showing each part of the analysis, starting with the tables and source. ...read more.


This will look as follows (in design view): Field Name Data Type Description Date Date This shows the date of the transaction. Time Number The shows the time of the transaction. Product Text This shows the name of the product purchased. Price Currency This shows the price of the product purchased. Reference Number Text This is the reference number of the transaction. With the following set of field properties: SALES: Date Format: Short Date Required: Yes Indexed: Yes (Duplicates OK) Duplicates are allowed in this field because there may be more than one purchase on a given date. Time: Format: Medium Time Required: Yes Indexed: No Product: Field Size: 50 Required: Yes Allow Zero-Length: No Indexed: No Price Format: Currency Decimal Places: Auto Default Value: 0 Required: No Indexed: No Reference Number: Field Size: 50 Required: Yes Allow Zero-Length: No Indexed: Yes (No Duplicates) Unicode Compression: Yes Like in the sales customers table, the indexing of the reference number stops duplicate reference numbers from appearing, thus reducing client error when entering a reference number, especially being that some may be very alike. Queries & Query Structure: Queries are somewhat different in their set-up as opposed to tables, because they generally rely on a table or query to have been created beforehand. As we need to create a query in design view, as with most of the database elements, design view asks for what table/query to be used in reference immediately when opened (if by some chance design view does not ask which tables to show at the beginning, click 'query' and select 'show table'). For this query, which will be a full query, both sales and customers tables need to be involved, linked, and organised to create a full query of all records in the database. So to start with, customers and sales need to be brought up on the screen. This is done by selecting the customer, and sales table and clicking add. ...read more.


* They found the layout and design was simple and readable, but professional enough to show that the database was customised for their purposes. * They found that the user need not save the database before quitting, although will remind all users to do so anyway, but this limits users from losing data from the database. * It matches the requirements of Snowshock Beanies. Possible Improvements: There were a few things found at the end-user stages of the design which could easily be changed, but were not sufficient enough to adjust the database in a way which would ruin the ease of use for the user. These were as follows: * The switchboard, for ease, would be better if it could be loaded upon start-up of the database. This was done in a simple and effective way, as follows: 'Tools' was selected, then 'Startup...', next a new dialogue came up as follows: The 'Display Form/Page' was then set to 'Switchboard'. The database was then closed and re-opened, where the switchboard opened immediately. This made it even easier for the less computer-literate user to use. And finally for security of the database, a password would make the database secure if it was stolen over the internet or e-mail. This is set-up in the following way: Firstly, the database needs to be closed, and opened ('File', 'Open'), but as it is being selected (from the 'Open File..' dialogue) it is selected and next to the open button, there is a small down arrow, selecting 'Open Exclusive' the database can be opened. Then select 'Tools', and then 'Security..' and then 'Set Database Password...'. The database password can now be set and once the database has been closed and re-opened, before the database can even be viewed, the password has to be entered, as seen below: Tim Durden 10W GCSE IT: Beanie Project Mr Wife - i - ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Management & Manipulation of Information essays

  1. Marked by a teacher

    The Internet is an important part of our everyday lives however it is not ...

    4 star(s)

    (Appleyard: 2008) This can be directly related to the concept of the 'Attention Economy.' Attention is scarce. A problem of society today is that one doesn't have enough attention to meet the demands of society and business. In this Attention Economy, human attention is in short supply.

  2. Marked by a teacher

    Information Retrieval tools. I have used a database to carry out my searches. ...

    3 star(s)

    It basically focuses on information as a resource. Information management and knowledge management is being applied around the world due to the amount of information that is available around us. Search Engines A search engine is a program that searches documents for specified keywords and returns a list of the documents where the keywords were found.

  1. Datbase Project newsagent shop

    I might also back it by saving it in a removable disk using USB cause this will be safer than a floppy and it is portable. It is also harder to destroy. In this database, the data that I will input and process will be real not fictitious but it

  2. Standard Operating Procedures (Sop) recruitment policies and procedures.

    the "Type of Certification" by DETAILING in the field and selecting the proper code. � TAB down to the "Position Tile" and type in the position number from the class code or DETAIL in the field and TAB over to the "Short Title" field and enter in the position tile and REPRIEVE.

  1. A Relational Database system to assist the stock control operation of Rai's Newsagents.

    The database system will also be user tested, this will be done so that any weaknesses if any can be identified and then corrected and improved.

  2. Evaluate the tools and techniques used to create finished animations

    Also you are able to create images and edit them because fireworks is a graphics program so you can make different images to put on the animation. You can also open up allot of different files in fireworks so if you created an image in a different program and saved

  1. Home Office LTD company. Database

    can keep a record of all the customers that have purchased products from the firm. It holds all their relevant contact details such as names, address, contact number, email and the amount paid by the client and date on which the products were bought.

  2. Designing a booking system for an Estate Agent.

    To find out the client requirements and to provide the best solution to the problem I will be an interviewing Raj Tevari who is my main contact asking several questions on how the system works within their organisation. For this I will need to construct questions that will show clear results to help me make a judgement.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work