• 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. Standard Operating Procedures (Sop) recruitment policies and procedures.

    � Type in the Eligibility ID# and RETRIEVE. � PRINT then submits for signature. 5. Send out Notices of Ratings � To send out the Notice of Ratings go back and "Review the List." � At the side of the list of names DETAIL in the box beside the names to print out the ratings.

  1. Database Design

    Supplier: (supplier ID, supplier name, supplier address, city, postcode, phone number) Entity Relationship Diagram There are 3 types of relationships between two entities. They are: * One-to-one * One-to-many * Many-to-many Each entity will have attributes associated with it. An attribute is a characteristic, for example the Customer entity will

  2. The purpose of this document is to provide a design for an electronic payment ...

    It will also incorporate various HCI aspects from a design written by SEG4 2 for the GUI. There will be only one new software component developed for the system. This will be a Payment component which will add functionality to the system, allowing users to pay securely online for any images they wish to purchase.

  1. I have been asked by a General Sports shop using a manual system to ...

    For the set up of the database for the Sports shop they will have to buy a computer and software for the problem. The software that the club could use would be pointless if they haven't got a computer so a PC will have to be bought within a budget.

  2. An analytical report to discuss the HEG Infoway project, its implementation and the reasons ...

    BIL is a SEI-CMM (appendix 1) level 4 compliant company. 3.0 Project Details 3.1 Scope of the project: The details of the scope of the project are provided in appendix 1. It can be broadly divided in seven main parts.

  1. Evalution of my database

    that the tables were appropriate for the data that will be entered in it. I made queries that helped to organise my data into certain category which I can also extract information from. Such as what type of bikes are being brought the most or who are buying a certain

  2. Using the Internet to research UFOs.

    Like I said, I began my research with the believers. John Mack, a psychiatrist from Harvard University, along with other believers, attempts to explain the validity of the these alien abductions at hand ("NOVA Online/Kidnapped By UFO's"). One of the most profound things that was uncovered was the similarity of the stories of abductees.

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