• 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

    STELLA Science Simulation Software.

    From the picture 3, we have the graphs. Graph 1 is the oscillation at the normal condition (mass=1kg, initial length=0.1m and length of string=1.0m), graph 2 with the length of string is half than the length of string at normal condition (mass=1kg, initial length=0.1m and length of string=0.5m)

  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. Designing a booking system for an Estate Agent.

    Microsoft Word is the most commonly used one as we use this to type letters to clients. We also use Microsoft access but to only store contact details in our database. 3. Is there one specific person who is responsible for booking?

  2. Database Design

    have attributes like; Customer ID, Customer Name, Customer Address, Customer Phone Number etc. Also each entity in a database must have at least one attribute called a Primary Key which individually identifies it. For example Customer ID would be the Primary Key of the Customer entity.

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

    1.2 Scope As many of the key elements of this system have already been developed by S3G 1 this design will place a strong emphasis on software reuse. This design document reuses aspects of the existing electronic photographic system, which is coded predominantly in PHP and uses a MySQL database.

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

    Some of examples are: Under �500 Dell Dimension L433c = �499 Under �1000 Mesh Elite Business Plus = �992.88 Under �1500 AJP 3300C = �1499 The PC will have to have extra hardware for the tasks that it needs to perform.

  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.

    Unfortunately, my efforts were shot down. Though I did find many places on the Internet that allowed for chats related to UFO?s and alien abductions, I had absolutely no luck joining any of them. I found that I needed to have Java to be able to participate in a few of these online discussions.

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