• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

this can be done by starting up Microsoft Access and then selecting the existing database and opening

Extracts from this document...


G2: Using the System Section G - User Documentation To use the system it must first be opened, this can be done by starting up Microsoft Access and then selecting the existing database and opening it. Then you will be presented with this screen. Here you can select to go on a Table, Query, Form, Report etc. The highlighted box is Customer Database, when this is clicked you will get a table like this: G3: Using the System Section G - User Documentation To put new customer information in, you just put the desired data in to the row with auto number at the beginning. You can also do this by using a form. To get on the on the form section you just click on "Forms" under "Objects" in the main menu (shown on page with black arrow) and click on the customer database form. ...read more.


For example you can go the form design view looks like this: G4: Using the System Section G - User Documentation Sometimes you may want to search for a certain customer by just one detail, there are various ways you can do that like filtering. On both tables and forms, you will be displayed with this icon in the form view menu. This is used to filter by selection. When you click on this you should get a blank table with a drop down menu from the field you have selected like this with the table format: Once you click on the arrow pointing down on the field you will be presented with a drop down list of all the customers for that certain field, for example if I select Customer ID: Then you select the particular detail you want of the customer in the example I have selected 7. ...read more.


In the sort row you can select whether you want the results ascending or descending. The show boxes just mean if you wan them to appear on the results. The main section here is the criteria. Here you can type in any detail of a certain customer under the right field name. If you want results for more than one customer you fill in the correct details in the blank boxes. Here I have written Birmingham and London in the query box: Then I select Run Query and I am returned with the results: G6: Using the System Section G - User Documentation The results are of all the people from a "London" or "Birmingham" location. You can fill in more details in the criteria of other fields if you want as well. Throughout the use of the database you will be presented with many icons including: - Used to save the database. - Used to open a database. - Print preview the database. - Print a table, query, form, report etc. - Sort data ascending. - Sort data descending. - Properties. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software 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 GCSE Software essays


    system is using all the minimum system requirements which could cause the computer to be slow and tedious. The top computer meets the requirements and then exceeds them this will make the computer a very fast system but comes at a considerably higher price at �8,395 however having said that

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    A key board 5. A ink jet colour printer 6. A scanner 7. A digital camera 8. And many more Data collection: 1. I sat with the manager to find out how he wants to present his restaurant, example like an Indian or like a fast food restaurant menu.

  1. Project 1b; Film Database

    genre science fiction or comedy that were produced between the years 1998 and 2004. These requests are very specific, and need complex queries. The following screen print shows a query in the design view that is needed to answer the first question.

  2. implementation report

    to add new loans Appendix 21 Appendix 21 shows that the wizard asked me if I wanted to name the command button or I wanted to use a picture for the command button. I decided to use text instead of picture as this would be easier for the user to

  1. Database Section

    * A list of all customers created by a report * A list of all DVDs created by a report * A list (report), which displays customers with DVDs that are overdue, this will be created by a query.

  2. User Documentation

    As before, you can click the macros on the right hand side of the page to either save and go back to the menu, or save and not go back to the menu. 4, If you click on 'Back to Menu', you will appear back at this screen: How to

  1. Database Report

    Name: Data Type: DVD Number Auto Number DVD Title Text Classification Text Genre Text Price Currency I am using all these field names and data types because there are appropriate to use for this database. The video is used to represent a video in numbers so that when ever a

  2. Technical Documentation.

    that is ordered by multiplying the quantity of items ordered by the unit cost of that particular stock item. =SUM(H19:H25) - This formula works out the total price of all the stock items that have been purchased and produces a final price.

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