System I designed in order to produce a promotion package for her newly formed company selling music CDs Essays

System I designed in order to produce a promotion package for her newly formed company selling music CDs Essays System I designed in order to produce a promotion package for her newly formed company selling music CDs Essay System I designed in order to produce a promotion package for her newly formed company selling music CDs Essay My friend was impressed with the system I designed in order to produce a promotion package for her newly formed company selling music CDs. The business has expanded rapidly with the large number of music CD titles in stock and has many regular customers. She would also like to develop a mail order service within the business. All the information at the moment is kept on paper based records and she is finding it difficult to locate information due to the increasing volume of sales in the business. My friend has been advised to convert her records onto a computer-based system and was given a floppy disk to containing sample data on current music titles available on CD to start her off. She has no idea how to access this information and has commissioned me to evaluate this data and devise a system that will allow her to keep her records of music CDs in stock, and customers for the mail order section of the company. My system will include: * Data capture sheets for CD data and customer details * Collection and input of data * Evidence that I have chosen a data-handling package and constructed a database. * * Presentation of the results in the form of printouts demonstrating the information which can be obtained from searching * A comprehensive User Guide so that my friend and her employees can use the system * An explanation of what has been done at every stage of my work, giving details of the software used and how it enabled me to create and develop my work. My work will be presented in five labelled sections as shown below: * Analysis * Design * Implementation * Testing * Evaluation My work will be secured in a plastic folder with a front sheet, which includes the following details: * A bold large heading; * A sub heading; * A graphic; * My name; * My centre number * My candidate number My work will also include a contents page so it is easier to examine my work and all pages will be numbered. Candidate No.- 6071 Centre No.- 20860 Action Plan The following is a list of jobs I need to do in order of priority: 28/9/00 Look at databases: identify weaknesses 30/9/00 Read through booklet carefully so I understand the task set 3/10/00 Write a statement giving details of the task 5/10/00 Arrange task criteria 7/10/00 Gather information about the task (How do other mail order companies and retail businesses store and process their data.) 9/10/00 Find out, and analyse the views of, potential users of mail order services and CD shops 11/10/00 Use an analysis of my completed questionnaires etc justify my design specification. This should include statements about structure, ease of use, quality of user documentation, types of output and presentation 13/10/00 Make a statement giving reasons which hardware and software is required for my system to run effectively 14/10/00 Check through Analysis section 15/10/00 Start Design section and examine and evaluate alternative methods of creating my system and explain what changes will be required based on my research evidence 17/10/00 Produce two or three database structures and explain strengths and weaknesses 19/10/00 Choose design that is most suitable and explain the decision 21/10/00 Explain how the hardware and software available influenced the design 23/10/00 Obtain views of potential users of my system using feedback to improve my system 25/10/00 Prepare data collection sheets and enter a suitable sample by hand 27/10/00 Produce database as detailed in design specification 29/10/00 Produce user guide for client 1/11/00 1st Submission date. Research completed and data files created with evidence of testing 3/11/00 Explain why I used the specific software and produce user guide for users explaining what the system can do 4/11/00 Check through Implementation section 5/11/00 Start Testing. Investigate verification and validation techniques and produce a testing plan 7/11/00 Check results of data entry correcting any errors and show any improvements made prior to this. 9/11/00 Create table to show how different parts of the system were tested, with evidence 11/11/00 Produce a series of simple and complex searches to demonstrate what the system can do. 13/11/00 Describe changes made as a result of testing, with evidence 14/11/00 Check through Testing section 15/11/00 Start Evaluation section. Explain reasons for software use giving clear features 17/11/00 Analyse the results of my searches and compare with the original stated requirements of the files 19/11/00 Include comments from third party about the viability of my new system and explain the changes made as a result of those comments 21/11/00 Compare design I have produced with original design specification. 22/11/00 Double check through entire coursework to make sure nothing is missing 24/11/00 Final Submission date. Hand in coursework Design I used Microsoft Access to create my database design structures. I followed the wizard and created four database design structures. I also explained and criticised each one. I then chose the best database design structure that I thought was most suitable to the task. Finally I printed all the structures on a Lexmark Z31 color jetprinter. Contents 1. Analysis Page 3 2. Design Page 18 3. Implementation Page 31 4. Testing Page 61 5. Evaluation Page 68 Questionnaire Analysis I recently visited the Virgin Megastore and MVC in Walsall with a couple of friends and interviewed both managers. We got them to fill the client questionnaires in that we designed together. We did this because we knew that both managers would be very busy so we designed it together to speed the process up and to have ideas on alternative methods of creating the system and database design structures. We found out that both companies are potential users of mail order and both agree that it is very reliable to store and process their data by using the system and agree that the system is not completely perfect as some errors do occur once in a while. The cost of mail order depends on how many products are purchased. Both use database and word-processing to store and process their data respectively. The mail order service is for any age group and both companies have a wide variety of music CDs available for the users of the system. Virgin Megastore uses the Internet mainly for their systems but both head offices decide the hardware and software that the companies use for their systems to run effectively. Their opinions on mail order are that it is very easy to use and that it is reliable enough, as they have been using the system for years. We were told that you get what you want out of mail order and we were given Virgins website to find out more information on mail order: [emailprotected] We got both managers to sign our questionnaires as evidence that we visited the companies. I also did a customer questionnaire to find out the views of the public and customers. I got many people to fill my customer questionnaire in and left a copy inside my folder to show an example of what it looked like after a member of the public filled it in. I found that Pop music was the most popular with people and classical the least popular. Most people would pay between à ¯Ã‚ ¿Ã‚ ½10-15 for a music CD. This is because the best CDs are highly priced therefore most customers are prepared to take that risk and spend over the limit just to get the latest music. Very few people order their music of the Internet because not all people are connected to the Internet and the people who are think that the system is unreliable. Virgin Megastore is the most popular music store as it has many customers and WH Smith has the least amount of customers who buy music from the shop. Most people I did a survey upon were between the 10-20-age category. Now that I have analysed my questionnaire, I will justify my design specification. Design Specification The following shows details about the design structures, ease of use, quality of user documentation, types of output and presentation. I will show this by doing the following: * Do printouts to show an exploration of data in a computer database to obtain specific information. * Do printouts that I have thoroughly checked and edited the databases. (I.e., correct errors, add and delete records, fields). * Show my data collection methods suitable for the printouts and other output that I may require. * Do printouts showing simple and complex searches for specific information. * Show evidence that I have chosen a data handling package and constructed a database. * Write an explanation of what has been done at every stage of my work, giving details of the software used and how it has enabled me to create and develop my work. Candidate No.- 6071 Centre No.- 20860 Data File I obtained my data using my data collection sheets and entered by hand a suitable sample. I received feedback from my family, friends and relatives. I later typed the data up in Microsoft Access. The table is shown below: Customer ID Last Name First Name Gender Birthdate Place of Birth 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Data File Below is the data that I typed up in Microsoft Access: Customer ID Last Name First Name Gender Birthdate Place of birth 1 BASRA SUKHPINDER M 10/05/85 WALSALL 2 SANOBAR MANSOOR M 27/12/84 WALSALL 3 HUSSAIN AKHTAR M 06/03/85 WALSALL 4 GANI BODRUL M 14/01/85 WALSALL 5 BHANGAL HARPREET M 04/12/84 WALSALL 6 AHMED NABEEL M 16/11/84 KASHMIR 7 UDDIN AZIR M 24/10/84 WALSALL 8 BOULTON KERRY F 29/11/84 WALSALL 9 BEGUM SHAHEENA F 25/02/85 WALSALL 10 AZIZ ARZOO F 18/01/85 WALSALL 11 QAMAR NAFISA F 19/07/85 WALSALL 12 MANN HARBAJAN M 11/04/65 GLASGOW 13 GINOLA DAVID M 03/05/68 TOTTENHAM 14 DEL PIERO ALESSANDRO M 10/11/75 ROME 15 BATISTUTA GABRIEL M 02/04/69 ROME 16 KLINSMANN JURGEN M 25/12/67 MUNICH 17 REBROV SERGEI M 12/12/75 WALSALL 18 ARMSTRONG CHRIS M 03/04/71 TOTTENHAM 19 CAMPBELL SOL M 04/12/74 TOTTENHAM 20 ANDERTON DARREN M 26/10/71 TOTTENHAM 21 VIERI CHRISTIAN M 04/03/74 MILAN 22 CARR STEVEN M 27/05/77 TOTTENHAM 23 LES FERDINAND M 03/01/67 TOTTENHAM 24 GAREWAL MANDEEP M 17/08/84 WALSALL 25 AFZAL IRFAN M 12/09/84 WALSALL 26 MICHAELS SHAWN M 21/07/67 NEW YORK 27 AUSTIN STEVE M 07/06/85 TEXAS 28 NAGVI ASADULLAH F 10/06/85 WALSALL 29 SINGH PIARA F 01/01/39 SLOUGH 30 CUBRA ROGER M 04/07/59 HALIFAX Data File 1 The data file below is very useful because the customer names are in ascending order by their first name, which makes it easier for the user to find a specific person. Customer ID Last Name First Name Gender Birthdate Place of birth 3 HUSSAIN AKHTAR M 06/03/85 WALSALL 14 DEL PIERO ALESSANDRO M 10/11/75 ROME 10 AZIZ ARZOO F 18/01/85 WALSALL 28 NAGVI ASADULLAH F 10/06/85 WALSALL 7 UDDIN AZIR M 24/10/84 WALSALL 4 GANI BODRUL M 14/01/85 WALSALL 18 ARMSTRONG CHRIS M 03/04/71 TOTTENHAM 21 VIERI CHRISTIAN M 04/03/74 MILAN 20 ANDERTON DARREN M 26/10/71 TOTTENHAM 13 GINOLA DAVID M 03/05/68 TOTTENHAM 23 LES FERDINAND M 03/01/67 TOTTENHAM 15 BATISTUTA GABRIEL M 02/04/69 ROME 12 MANN HARBAJAN M 11/04/65 GLASGOW 5 BHANGAL HARPREET M 04/12/84 WALSALL 25 AFZAL IRFAN M 12/09/84 WALSALL 16 KLINSMANN JURGEN M 25/12/67 MUNICH 8 BOULTON KERRY F 29/11/84 WALSALL 24 GAREWAL MANDEEP M 17/08/84 WALSALL 2 SANOBAR MANSOOR M 27/12/84 WALSALL 6 AHMED NABEEL M 16/11/84 KASHMIR 11 QAMAR NAFISA F 19/07/85 WALSALL 29 SINGH PIARA F 01/01/39 SLOUGH 30 CUBRA ROGER M 04/07/59 HALIFAX 17 REBROV SERGEI M 12/12/75 WALSALL 9 BEGUM SHAHEENA F 25/02/85 WALSALL 26 MICHAELS SHAWN M 21/07/67 NEW YORK 19 CAMPBELL SOL M 04/12/74 TOTTENHAM 27 AUSTIN STEVE M 07/06/85 TEXAS 22 CARR STEVEN M 27/05/77 TOTTENHAM 1 BASRA SUKHPINDER M 10/05/85 WALSALL Data File 2 The data file below is in ascending order by the place of birth. It is not very useful because many customers are from the same birthplace so it would be difficult for the user to search a customers record. Customer ID Last Name First Name Gender Birthdate Place of birth 12 MANN HARBAJAN M 11/04/65 GLASGOW 30 CUBRA ROGER M 04/07/59 HALIFAX 6 AHMED NABEEL M 16/11/84 KASHMIR 21 VIERI CHRISTIAN M 04/03/74 MILAN 16 KLINSMANN JURGEN M 25/12/67 MUNICH 26 MICHAELS SHAWN M 21/07/67 NEW YORK 15 BATISTUTA GABRIEL M 02/04/69 ROME 14 DEL PIERO ALESSANDRO M 10/11/75 ROME 29 SINGH PIARA F 01/01/39 SLOUGH 27 AUSTIN STEVE M 07/06/85 TEXAS 13 GINOLA DAVID M 03/05/68 TOTTENHAM 22 CARR STEVEN M 27/05/77 TOTTENHAM 20 ANDERTON DARREN M 26/10/71 TOTTENHAM 19 CAMPBELL SOL M 04/12/74 TOTTENHAM 18 ARMSTRONG CHRIS M 03/04/71 TOTTENHAM 23 LES FERDINAND M 03/01/67 TOTTENHAM 2 SANOBAR MANSOOR M 27/12/84 WALSALL 3 HUSSAIN AKHTAR M 06/03/85 WALSALL 4 GANI BODRUL M 14/01/85 WALSALL 5 BHANGAL HARPREET M 04/12/84 WALSALL 7 UDDIN AZIR M 24/10/84 WALSALL 8 BOULTON KERRY F 29/11/84 WALSALL 9 BEGUM SHAHEENA F 25/02/85 WALSALL 10 AZIZ ARZOO F 18/01/85 WALSALL 28 NAGVI ASADULLAH F 10/06/85 WALSALL 1 BASRA SUKHPINDER M 10/05/85 WALSALL 25 AFZAL IRFAN M 12/09/84 WALSALL 17 REBROV SERGEI M 12/12/75 WALSALL 24 GAREWAL MANDEEP M 17/08/84 WALSALL 11 QAMAR NAFISA F 19/07/85 WALSALL Data File 3 The data file is in ascending order by the customers date of birth. As you can see it is very useful because it shows the date of birth from the oldest to the youngest person in order, the way the customer pays and their address which makes it relatively easy for the user of the system. All the user has to do is to type in a birthdate using the search to find the customers age. Customer ID Last Name First Name Gender Birthdate Place of birth Address Pay by 1 BASRA SUKHPINDER M 10/05/85 WALSALL 27 Willoherb Close Cash 2 SANOBAR MANSOOR M 27/12/84 WALSALL 24 Lord Street Cash 3 HUSSAIN AKHTAR M 06/03/85 WALSALL 12 Maple Drive Cash 4 GANI BODRUL M 14/01/85 WALSALL 123 Broadway West Cash 5 BHANGAL HARPREET M 04/12/84 WALSALL 2 Poppy Drive Cash 6 AHMED NABEEL M 16/11/84 KASHMIR 15 Tarsemir Close Cash 7 UDDIN AZIR M 24/10/84 WALSALL 5 Milton Street Cash 8 BOULTON KERRY F 29/11/84 WALSALL 17 Bell Lane Cash 9 BEGUM SHAHEENA F 25/02/85 WALSALL 69 Milton Street Cash 10 AZIZ ARZOO F 18/01/85 WALSALL 33 Caldmore Road Cash 11 QAMAR NAFISA F 19/07/85 WALSALL 44 Milton Street Cash 12 MANN HARBAJAN M 11/04/65 GLASGOW 27 Rosehip Close Cheque 13 GINOLA DAVID M 03/05/68 TOTTENHAM 77 Park Lane Cheque 14 DEL PIERO ALESSANDRO M 10/11/75 ROME 17 Honeysuckle Drive Visa 15 BATISTUTA GABRIEL M 02/04/69 ROME 19 Santi Bernabeau Cheque 16 KLINSMANN JURGEN M 25/12/67 MUNICH 64 Stadio Olimpico Visa 17 REBROV SERGEI M 12/12/75 WALSALL 24 White Hart Lane Cheque 18 ARMSTRONG CHRIS M 03/04/71 TOTTENHAM 9 Bow Street Cash 19 CAMPBELL SOL M 04/12/74 TOTTENHAM 67 White Hart Lane Cash 20 ANDERTON DARREN M 26/10/71 TOTTENHAM 34 Trafalgar Square Cheque 21 VIERI CHRISTIAN M 04/03/74 MILAN 21 Las Palmas Visa 22 CARR STEVEN M 27/05/77 TOTTENHAM 7 Oxford Street Visa 23 LES FERDINAND M 03/01/67 TOTTENHAM 137 Broadway West Visa 24 GAREWAL MANDEEP M 17/08/84 WALSALL 56 West Bromwich Road Cash 25 AFZAL IRFAN M 12/09/84 WALSALL 121 Newman Street Cash 26 MICHAELS SHAWN M 21/07/67 NEW YORK 97 HBK Merchandise Cheque 27 AUSTIN STEVE M 07/06/85 TEXAS 44 Rattlesnake Willows Cheque 28 NAGVI ASADULLAH F 10/06/85 WALSALL 27 West Bromwich Road Cash 29 SINGH PIARA F 01/01/39 SLOUGH 4 Poppy Drive Cheque 30 CUBRA ROGER M 04/07/59 HALIFAX 23 Lord Street Visa Best Data File I think my third data file was the best because it is the easiest and quickest way for the user to locate a customer. All the user has to do is type in a birth date and it will give a list of birthdates. This depends if the user uses AND, OR, LIKE or NOT in their search. They can also do this to find the customer address or the way in which the customer wants to pay. I rejected my second data file because if the user used AND, OR or LIKE I their search, there would be a big list say if the user chose to search by Walsall or Tottenham so it would take longer for the user to access a specific customers data. I rejected my first data file because if say the user of the system typed in Chris in their search then Christian would also come up too because Chris is the first part of Christian. This suggests that the data file is not very reliable to the user. Changes to the system After examining and evaluating alternative methods of creating my system I have made a few changes to my databases. I looked at the original data given to me and wrote down the things that I needed to change. Here are some of the things I need to do/change to the database: * Create a data structure that holds record information * Create a database structure that holds customer information * Add a few extra fields * Change the layout of the page slightly * Update the information to the modern day. CD Sample This is a bad database. It has only four fields and does not tell you any details of the potential user or how many CDs are in stock. The data is placed in any order so it is difficult for the user to find the Title of the CD or CDs they want to order. Also the prices are not in ascending order so the user has to look carefully whether the CD is in their price range or not. Older users of the system tend to like older music and the Year of release is not in ascending order so it is hard for the older user to locate the era in which the CD was produced. How the Hardware and Software I used influenced me to my design The hardware I used influenced me very much. I used a printer, which printed all my database design structures and data collection sheets very quickly. I printed all the structures on a Lexmark Z31 color jetprinter. I also used a photocopier to copy my data collection sheets and for my questionnaires. Record Information Design Structure Design View Datasheet View Artist Title Year Price Quantity A1 Take me on 2000 à ¯Ã‚ ¿Ã‚ ½10.00 3 Architechs Body Groove 2000 à ¯Ã‚ ¿Ã‚ ½7.00 8 Bon Jovi Crush 2000 à ¯Ã‚ ¿Ã‚ ½5.00 5 Bon Jovi Its my life 2000 à ¯Ã‚ ¿Ã‚ ½5.00 16 Britney Spears Oops I did it again! 2000 à ¯Ã‚ ¿Ã‚ ½8.00 2 Craig David 7 Days 2000 à ¯Ã‚ ¿Ã‚ ½10.00 7 Craig David Fill me in 2000 à ¯Ã‚ ¿Ã‚ ½5.00 9 Eminem The Marshall Mathers 2000 à ¯Ã‚ ¿Ã‚ ½5.00 10 Eminem The way I am 2000 à ¯Ã‚ ¿Ã‚ ½10.00 15 Five Invincible 2000 à ¯Ã‚ ¿Ã‚ ½5.00 5 Madonna Music 2000 à ¯Ã‚ ¿Ã‚ ½15.00 8 Mel C I turn to you 2000 à ¯Ã‚ ¿Ã‚ ½7.00 4 Richard Blackwood 1234 Get with the wicked 2000 à ¯Ã‚ ¿Ã‚ ½8.00 4 Robbie Williams Rock DJ 2000 à ¯Ã‚ ¿Ã‚ ½11.00 13 Ronan Keating Ronan 2000 à ¯Ã‚ ¿Ã‚ ½6.00 9 S Club 7 Reach 2000 à ¯Ã‚ ¿Ã‚ ½5.00 3 SNOOP D.D. FEAT. DR DRE ITS A G THING 2000 à ¯Ã‚ ¿Ã‚ ½9.00 1 Spice Girls Holler 2000 à ¯Ã‚ ¿Ã‚ ½5.00 11 Various Artists Gatecrasher: global sound system 2000 à ¯Ã‚ ¿Ã‚ ½15.00 6 Various Artists Fresh Hits 2000 à ¯Ã‚ ¿Ã‚ ½12.00 3 Various Artists Now thats what I call music! 46 2000 à ¯Ã‚ ¿Ã‚ ½12.00 8 Whitney Houston Greatest Hits 1999 à ¯Ã‚ ¿Ã‚ ½12.00 2 Wyclef Jean It doesnt matter 2000 à ¯Ã‚ ¿Ã‚ ½10.00 7 Design Structure 2 Design View Datasheet View Design Structure 3 Design View Datasheet View Record Information Design Structure 1 This is a better database design structure because it includes the quantity of CDs left in stock and the Title is in ascending order, which is easier for the user to find the CD that they are specifically looking for. Design Structure 2 This is a good database design structure because it has two extra fields. These are the customer ID number and the highest entry of the CD. This is therefore a lot easier for the user to access the database. Design Structure 3 This is the best database design structure for the record information out of the lot because the price is in ascending order so it will satisfy all users, especially the users that only buy CDs at a certain price. Customer Information Structure 1 Design View Datasheet View Structure 2 Design View Datasheet View Structure 3 Design View Datasheet View Customer Information Structure 1 This is not the best database design structure because it doesnt tell you all the information about the potential user. It doesnt include things like the telephone number in case the company needs to get in touch with the user of the system. Structure 2 This database design structure is slightly better because it gives you a bit more information about the potential user. It gives the system users telephone number in case the company needs to get in touch in the case of a problem. Structure 3 This is by far the best design structure as it tells you a lot of details about the potential user. It gives their ID number, name, address, age, gender, telephone number and what way they would like to pay; either by Visa, cheque or case. Influences of Hardware and Software available The software I chose did not help as much as I expected it too much. Microsoft Word is mainly to do with typing text and cant produce a table like the ones in Microsoft Access. However, Microsoft Access and the Internet were very useful to me. Access helped me quite a lot because the program has wizards, which helped me create the structures. It was also easy to do datasheets because the software is very good at guiding you through the processes. I used the Internet to find relevant information, including data structures and layouts of them. The hardware I used helped me very much. I used a printer to print my structures off and a photocopier to scan my questionnaires. These influenced me very much because they were easy to use. The records above are a database for the number of music CDs in stock. I had taken into account the views of potential users of my system and decided to leave the database how it is, keeping the price of the CDs in ascending order (from cheapest to most expensive) as it easy for the user to find a specific search price. Access 2000 System Requirements Here are the system requirements to run Microsoft Access 2000: * PC with a Pentium 75 megahertz (MHz) or higher processor * Microsoft Windows(r) 95 or later operating system, or Microsoft Windows NT(r) Workstation operating system version 4.0 Service Pack 3 or later * For Windows 95 or Windows 98: 16 megabytes (MB) of RAM for the operating system, plus an additional 8 MB of RAM for Access * For Windows NT Workstation: 32 MB of RAM for the operating system, plus an additional 8 MB of RAM for Access * 161 MB of available hard-disk space (Number indicates typical installation; your hard-disk usage will vary depending on configuration. Choices made during custom installation may require more or less hard-disk space.) * CD-ROM drive * VGA or higher-resolution monitor; Super VGA recommended * Microsoft Mouse, Microsoft Intellimouse, or compatible pointing device Additional items or services required to use certain features: * 9600 baud modem; 14,400 or higher-baud modem recommended * Multimedia computer required to access sound and other multimedia effects * Microsoft Outlook 2000 or Microsoft Outlook Express 5.0 or later required to run Office E-mail * 8 MB of additional memory required to run Office E-mail * Some Internet functionality may require Internet access and payment of a separate fee to a service provider Troubleshooting guide for Microsoft Access A database will not compact for any of the following reasons: à ¯Ã‚ ¿Ã‚ ½ You dont have enough storage space on your disk for both the original and compacted versions of the database. Delete any unneeded files and try again. à ¯Ã‚ ¿Ã‚ ½ You dont have Modify Design or Administer permission for all tables in the database. If you dont own this database, contact its owner to find out whether you can be given either of these permissions on all tables. If you own this database, you need to update your permissions for all tables. For more information on assigning permissions, click. à ¯Ã‚ ¿Ã‚ ½ If an object in a version 1.x database includes the backquote character (`) in its name, you wont be able to compact the database. Use Microsoft Access version 1.x to rename the object, and then change any references to it in your queries, forms, reports, macros, and code. Assign or remove permissions for a database and existing database objects 1 Open the database that contains the objects you want to secure. The workgroup information file in use when you log on must contain the user or group accounts you want to assign permissions for at this time; however, you can assign permissions to groups and add users to those groups later. 2 On the Tools menu, point to Security, and then click User and Group Permissions. 3 On the Permissions tab, click Users or Groups, and then click the user or group whose permissions you want to assign in the User/Group Name box. 4 Click the type of object in the Object Type box, and then click the name of the object to assign permissions for in the Object Name box. Tip You can select multiple objects in the Object Name box by dragging through the objects you want to select or by holding down CTRL and clicking the objects you want. 5 Under Permissions select the permissions you want to assign, or clear the permissions you want to remove for the group or user, and then click Apply. Repeat steps 4 and 5 to assign or remove permissions for additional objects for the current user or group. 6 Repeat steps 3 through 5 for any additional users or groups, and then click OK when you have finished. Important If you assign or remove permissions for Visual Basic code (forms, reports, or modules), those permissions will not take effect until the database is closed and reopened. Troubleshoot editing data in a field There are several kinds of fields in forms or datasheets that you cant edit. The following fields display values just as regular fields do, but if you try to enter data into them, nothing happens: à ¯Ã‚ ¿Ã‚ ½ AutoNumber fields. If a field has an AutoNumber data type, Microsoft Access automatically assigns the next consecutive number or unique random number to this field for each record you add. This type of field is often used as a record ID number or primary key. When you start adding a new record, Microsoft Access automatically fills in the fields value for you and you cant edit it. à ¯Ã‚ ¿Ã‚ ½ Calculated fields. A Calculated field displays values that Microsoft Access calculates. They are usually based on other fields in your tables, but calculated fields are not stored in tables. You cant edit calculated fields. à ¯Ã‚ ¿Ã‚ ½ Locked or disabled fields. If a control on a form has the Locked property set to Yes or the Enabled property set to No, you cant edit the data in the field. à ¯Ã‚ ¿Ã‚ ½ Fields in a locked record. If you use Microsoft Access in a multi-user environment and another user locks a record, you cant edit the data in the record. When you move to a locked record, the locked record indicator is displayed in the record selector. à ¯Ã‚ ¿Ã‚ ½ Fields in snapshots. While most queries return recordsets that you can edit, some queries return snapshots, which cant be edited. à ¯Ã‚ ¿Ã‚ ½ Field in a read-only form or a locked database. If the form youre using has the AllowEdits property set to No or if the underlying data is read-only or locked by another person, you cant edit data in the form. Why did the size of my database increase significantly more than the size of the object I added? The amount of information used to represent an object is often greater than the size of the object itself. One way to work around this is to display an icon representing the object instead of the object itself in the form or report. When you display an icon, the OLE server (the application used to create the object) sends only the information needed to display the icon. When you double-click the icon, the OLE server is launched with the data that the icon represents. My picture becomes distorted when I size it. To keep a pictures proportions when you size it, use the Picture Size Mode property (for background pictures) or the Size Mode property (for bound object frames, unbound object frames, and image controls). If the picture is a bitmap, its best to use the Zoom setting rather than the Stretch setting. You should also consider using a metafile rather than a bitmap since you can size metafiles without causing distortions. For more guidance on any queries, click on help on the menu and click- on either Microsoft Access Help, Contents and index or Microsoft on the Web where you will receive expert on-line guidance. Troubleshooting guide for Microsoft Word I changed the fill, border, shadow, or 3-D effect, but when I create a drawing object, I get the old settings. The default style is being applied to the new drawing object. à ¯Ã‚ ¿Ã‚ ½ To change the default settings for new drawing objects, select an object that has the attributes you want. On the Drawing toolbar, click Draw, and then click Set AutoShape Defaults. Prevent a table row from breaking across pages 1 Click the table. 2 On the Table menu, click Cell Height and Width, and then click the Row tab. 3 Clear the Allow row to break across pages. Word isnt automatically inserting my text or graphics. à ¯Ã‚ ¿Ã‚ ½ To turn on AutoCorrect, click AutoCorrect on the Tools menu, and then make sure the Replace text as you type check box is selected. à ¯Ã‚ ¿Ã‚ ½ When you type an AutoCorrect name, make sure to precede it with a space and follow it with another space or a punctuation mark. How can I get data from another program into Word without starting the source program? By default, when you insert database information or attach it as a mail merge data source, Word uses DDE to read the data file. DDE automatically starts the source program (such as Microsoft Excel) and then opens the data file. If you dont want to start the source program, you can use ODBC or file converters instead of DDE to read the data file directly. To do this, insert the database information, or attach it as a mail merge data source as usual. In the Open Data Source dialog box, select the Select method check box before you click Open. Then, each time you insert database information or attach it as a mail merge data source, Word opens the Confirm Data Source dialog box so that you can click the ODBC driver or file converter you want. Text that I print looks different from text on the screen. à ¯Ã‚ ¿Ã‚ ½ Word might be displaying text as draft fonts. On the Tools menu, click Options, and then click the View tab. Clear the Draft font check box. This option will be available only if you are in normal view. à ¯Ã‚ ¿Ã‚ ½ Word might be printing a draft of your text. On the Tools menu, click Options, and then click the Print tab. Clear the Draft output check box. à ¯Ã‚ ¿Ã‚ ½ The font in your document might not be available on the printer youre using. Change the font in your document to a TrueType font, or change the font to one that is available on your printer. à ¯Ã‚ ¿Ã‚ ½ Animated text effects dont print. If text in your document is animated, it will print with the underlying text formatting 3/4 such as bold or italic 3/4 but the animated effects will not print. à ¯Ã‚ ¿Ã‚ ½ The font in your document might be one that is available on your printer but that doesnt have a matching screen font. Windows substitutes a TrueType font to display the text on the screen. Try changing the font in your document to a TrueType font. When I try to save changes to a document, I get a message saying the document is read-only. You cant make changes to a read-only document. To save changes, you need to save the document with a new name. You can use the same name if you save the document in a new or different folder. My e-mail is very slow or not working correctly. à ¯Ã‚ ¿Ã‚ ½ To use WordMail as your e-mail editor, you should have at least 12 megabytes of memory available. à ¯Ã‚ ¿Ã‚ ½ Before using WordMail, close any Word dialog boxes that are open. à ¯Ã‚ ¿Ã‚ ½ Programs that work in the background, such as virus-scanning programs, may slow down WordMail and Word in general. Use System Monitor 3/4 an optional Windows 95 accessory program 3/4 to see if you are running programs that slow down your computers performance and to see which program is using the highest percentage of processor time. Graphics dont appear when I print. à ¯Ã‚ ¿Ã‚ ½ Make sure that youre not using the draft output option, which doesnt print graphics. On the Tools menu, click Options, and then click the Print tab. The Draft output check box should be cleared. à ¯Ã‚ ¿Ã‚ ½ Make sure that youre not printing field codes for graphics youve linked from files created in other programs. On the Tools menu, click Options, and then click the Print tab. The Field codes check box should be cleared. Freehand drawing is hard to control. à ¯Ã‚ ¿Ã‚ ½ Try increasing the magnification in the Zoom Control box. Its easier to draw details at 200 percent. à ¯Ã‚ ¿Ã‚ ½ Use the Freeform button instead of the Scribble button. à ¯Ã‚ ¿Ã‚ ½ Try setting your mouse to the slowest tracking speed available in Windows Control Panel. You have greater control when you draw at a slow speed. à ¯Ã‚ ¿Ã‚ ½ You can adjust the shape of freeform to make them look smoother. For more guidance on any queries, click on help on the menu and click- on either Microsoft Word Help, Contents and index or Microsoft on the Web where you will receive expert on-line advice. Troubleshooting guide for the Internet Finding the information you want You can find information on the Web in a variety of ways. * Click the Search button on the toolbar to gain access to a number of search providers. Type a word or phrase in the Search box. * Type go, find, or ? Followed by a word or phrase in the Address bar. Internet Explorer starts a search using its predetermined search provider. * After you go to a Web page, you can search for specific text on that page by clicking the Edit menu and then clicking Find. Note * If a Web address doesnt work, Internet Explorer asks if you want to search for similar Web addresses. You can change this setting so that Internet Explorer searches automatically without prompting. For more information, see Related Topics below. Protecting your identity over the Internet You can use a personal certificate to protect your identity over the Internet. A certificate is a statement guaranteeing the identity of a person or the security of a Web site. You can control the use of your own identity by having the private key that only you know on your own system. When used with mail programs, security certificates with private keys are also known as digital IDs. Internet Explorer uses two different types of certificates: * A personal certificate is a kind of guarantee that you are who you say you is. This information is used when you send personal information over the Internet to a Web site that requires a certificate verifying your identity. * A Web site certificate states that a specific Web site is secure and genuine. It ensures that no other Web site can assume the identity of the original secure site. Using accessibility features in Internet Explorer In addition to Microsoft Windows accessibility products and services, the following features make Internet Explorer more accessible for people with disabilities. Keyboard access All features in Internet Explorer are accessible to you by using the keyboard or the mouse. With Internet Explorer, you can explore the Web by using the keyboard. Just press TAB and SHIFT+TAB to move forward and backward between screen elements such as: * Links that are text or images * Hotspots on image maps * The Address bar * The menu bar * The Links bar * Frames For more information about keyboard access, see Internet Explorer shortcuts. Highlighting box As you move to or click a link or image, a thin border appears around it so you can see what is selected. Customise the font size, formatting, and colours You can specify the font sizes, styles and colours, and foreground and background colours of Web pages displayed on your computer screen, even if the author of the Web page has already specified these. You can also specify the colour used to indicate links in Web pages, or a special colour for links that is used only when the mouse passes over the link. This is useful if you have low vision, need larger fonts, or need high-contrast colours. You can set Internet Explorer to use the colours and fonts you specify, your default Windows colours and fonts, or the settings you specify in your own style sheet. For more information, see Changing fonts and background colours. Customise the toolbar You can customise the toolbar by adding or removing buttons, using small or large icons, and showing or hiding the text on the labels. Just right-click the toolbar and then click Customise. If you have low vision, you may want to add the Size button for quick access to the relative font size. If you are using a screen reader, you may want to select Small Icons in the Icon Options list and No text labels in the Text Options list to maximise the amount of screen space available for Web content. Advanced options that make Internet Explorer more accessible You can select or clear several options that may make Internet Explorer more accessible. To display these options, click the Tools menu, click Internet Options, and then click the advanced tab. * Use smooth scrolling and Enable page transitions If you use a screen magnification or screen reader program, you may want to clear these check boxes. If you use a voice recognition program, and you experience recognition errors during smooth scrolling and transitions, you may also want to clear these check boxes. * Show pictures If you have low vision, you may want to clear these check boxes to improve performance. If you are sensitive to screen flashing, you may also want to clear these check boxes. * Print background colours and images If you have low vision, you may want to clear this check box to improve print legibility. Advantages and Limitations of Software The software I used was Microsoft Word, Microsoft Access and the Internet. I used Word to criticise my three databases. Microsoft Access and the Internet were the most useful to me. I used Microsoft Access to create my tables using the Wizard for my databases. I used the Internet to find out information about the latest singles to download relevant information about prices of the CDs, the Artists and the structure of databases used in mail order companies. Advantages Microsoft Word * You can type up your data in this software using different formats of text * Copy and paste from other files * Checks any spelling errors * Gives a clear troubleshooting guide for new users Microsoft Access * Wizard for guidance of structuring techniques * Easy to do datasheets * Gives you the option of creating your database in design view or on the datasheet itself * Checks any spelling errors * Automatically stores created documents * East to change and update data Internet * Download relevant information of the web such as page layouts, data structures and modern day music * You can open a new window to see another search result with a click of a button * You can get feedback from companies via the web using the e-mail service. Limitations Microsoft Word * Cant create tables like Microsoft Access Microsoft Access * Cant type data up using different formats of text * Easy for data to be accidentally altered Internet * Downloading files can take time * Many spelling mistakes in downloaded work Verification and Validation Techniques The first stage is the database itself. This is where all the information (records) in the system are stored. It is important that a good understanding of the exact needs of the system is calculated, so that the database can be structured properly. I have used Microsoft Access to create the database for this system, because my system is based towards a small business environment. It is also widely available and widely used and is pretty simple to setup and manage. Microsoft Access is a relational database. This means that its structure is made up of tables, or entities. Each of these tables holds rows and columns of data. Each row is called a record or tuple, and each column is called an attribute. All the records in the table are in some way related to each other. The database required for the system contains two main categories: (1) A category that holds the record information (2) A category that holds a customer information. Both databases need fields that have to be unique, such as customer ID numbers. I set the database to handle this by auto generating the customer id number. This creates a new number all the time, in access the AutoNumber option is used for that field. Also in cases like phone numbers, this is selected so that you have to enter the number in the correct format. These are some of the verification and validation techniques that I used. Example the customer ID field is indexed, and does not allow any duplicates! How the system could have been improved or created in a more better way The system could have been created and have been linked directly to the Internet. So all the access to all the data by all users including customers could have been done on the Internet. This could be setup in a way where a programming language like Java is used to connect the Access database to the Internet. These kinds of internet/web databases follow the client server model. A database engine sits on some central computer somewhere and serves data to multiple clients, which are in the form of an Internet browser. Within this process, we also have a web server. This handles requests from the web browsers and then forwards them to the database. The web server then waits for the database to respond and then pass on that response to the waiting clients. In this way normal users of the database, such as the people that enter and process the orders and record information, would login using an ID and password, and they would be given access to the operations that they require. Whereas customers would log on to the Internet site, enter all the find and order the CDs they need, this would be then checked and verified, and the database would be updated, so that the order can be processed. Diagram of system model: Searches I will now produce a series of simple and complex searches to demonstrate what the system can do, with clear explanations. The complex searches will include two examples each of AND, OR and NOT. Searches with AND 1. If you wish to find out the number of males that live in Walsall, the user would do the following search: m AND walsall As a result of the search the following data will be shown: 1 BASRA SUKHPINDER M 10/05/85 WALSALL 27 Willoherb Close Cash 2 SANOBAR MANSOOR M 27/12/84 WALSALL 24 Lord Street Cash 3 HUSSAIN AKHTAR M 06/03/85 WALSALL 12 Maple Drive Cash 4 GANI BODRUL M 14/01/85 WALSALL 123 Broadway West Cash 5 BHANGAL HARPREET M 04/12/84 WALSALL 2 Poppy Drive Cash 6 AHMED NABEEL M 16/11/84 KASHMIR 15 Tarsemir Close Cash 7 UDDIN AZIR M 24/10/84 WALSALL 5 Milton Street Cash 17 REBROV SERGEI M 12/12/75 WALSALL 24 White Hart Lane Cheque 24 GAREWAL MANDEEP M 17/08/84 WALSALL 56 West Bromwich Road Cash 25 AFZAL IRFAN M 12/09/84 WALSALL 121 Newman Street Cash 2. If you wish to find out the number of females that live in Walsall, the user would do the following search: f AND walsall As a result of the search the following data will be shown: 8 BOULTON KERRY F 29/11/84 WALSALL 17 Bell Lane Cash 9 BEGUM SHAHEENA F 25/02/85 WALSALL 69 Milton Street Cash 10 AZIZ ARZOO F 18/01/85 WALSALL 33 Caldmore Road Cash 11 QAMAR NAFISA F 19/07/85 WALSALL 44 Milton Street Cash 28 NAGVI ASADULLAH F 10/06/85 WALSALL 27 West Bromwich Road Cash Searches with OR 1. If you wish to search for people living on Newman Street and Milton Street, the user of my system will do the following search: newman OR milton As a result of the search the following data will be shown: 7 UDDIN AZIR M 24/10/84 WALSALL 5 Milton Street Cash 9 BEGUM SHAHEENA F 25/02/85 WALSALL 69 Milton Street Cash 11 QAMAR NAFISA F 19/07/85 WALSALL 44 Milton Street Cash 25 AFZAL IRFAN M 12/09/84 WALSALL 121 Newman Street Cash Notice that I never included street, as there are other roads that ended in street in my best data file (data file 3). 2. If the user wishes to find out information on the people born in Tottenham and Rome, they will do the following search: tot OR rom As a result of the search the following data will be shown: 13 GINOLA DAVID M 03/05/68 TOTTENHAM 77 Park Lane Cheque 14 DEL PIERO ALESSANDRO M 10/11/75 ROME 17 Honeysuckle Drive Visa 15 BATISTUTA GABRIEL M 02/04/69 ROME 19 Santi Bernabeau Cheque 18 ARMSTRONG CHRIS M 03/04/71 TOTTENHAM 9 Bow Street Cash 19 CAMPBELL SOL M 04/12/74 TOTTENHAM 67 White Hart Lane Cash 20 ANDERTON DARREN M 26/10/71 TOTTENHAM 34 Trafalgar Square Cheque 22 CARR STEVEN M 27/05/77 TOTTENHAM 7 Oxford Street Visa 23 LES FERDINAND M 03/01/67 TOTTENHAM 137 Broadway West Visa Notice that I have used fewer characters in my search, as their no other fields except the address field that begins with tot or rom. This also saves some of the users time. Searches with NOT 1. If the user wants to find out about females only that were born in the year 1985, they will do the following search: f 85 NOT m As a result of the search the following data will be shown: 9 BEGUM SHAHEENA F 25/02/85 WALSALL 69 Milton Street Cash 10 AZIZ ARZOO F 18/01/85 WALSALL 33 Caldmore Road Cash 11 QAMAR NAFISA F 19/07/85 WALSALL 44 Milton Street Cash 28 NAGVI ASADULLAH F 10/06/85 WALSALL 27 West Bromwich Road Cash The system would first search for females and then look for the number 85. The search would now be complete, as the list above suggests. 2. If the user wants to search for the people who pay by cheque to buy music, they do the following search: cheque NOT visa NOT cash As a result of the search the following data will be shown: 12 MANN HARBAJAN M 11/04/65 GLASGOW 27 Rosehip Close Cheque 13 GINOLA DAVID M 03/05/68 TOTTENHAM 77 Park Lane Cheque 15 BATISTUTA GABRIEL M 02/04/69 ROME 19 Santi Bernabeau Cheque 17 REBROV SERGEI M 12/12/75 WALSALL 24 White Hart Lane Cheque 20 ANDERTON DARREN M 26/10/71 TOTTENHAM 34 Trafalgar Square Cheque 26 MICHAELS SHAWN M 21/07/67 NEW YORK 97 HBK Merchandise Cheque 27 AUSTIN STEVE M 07/06/85 TEXAS 44 Rattlesnake Willows Cheque 29 SINGH PIARA F 01/01/39 SLOUGH 4 Poppy Drive Cheque The system browses for the word cheque and provides the answer to the search, for the user of the system. Results of my searches I have analysed the results of my searches and compared them with the original stated requirements. I found that my searches were successful with AND, OR and NOT, therefore the user can use my system properly. The results show that the user only needs to type in a few characters to get what they want out of the searches. Comments from third party Below are the comments made by my friend about the viability of my new system: Daljits work is very thorough and he has very worked hard to create the new system. He has tested it in different ways to see that it functions correctly and has expanded it from the previous system that he created. To show how the system can be improved he has demonstrated ways of linking it to the world-wide web, just as the leading music companies have done, therefore music can be ordered on-line. His system works accurately as his searches proved and any user that uses the system can use it efficiently and effectively. The following are the changes that I made as a result of the comment above: * I produced annotated hard copy evidence at each stage of my work to show my improvement. * I asked the views of more than one person about the viability of my system and found that the comments were similar to my friend. * I included extra fields in my design.