• 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

  1. Technical Documentation.

    - This formula works out the final total because it adds on the sub-total the VAT, and it also adds on any postage and packaging costs that may need to be included. Validation Rules Telephone Number - I put a validation rule in place on the cell where the

  2. Setting up a database in microsoft access.

    data I was going to type into my database was valid and it reduced the chance of me making a mistake. This test plan had column headings of: Field Validation Rule(s) Actual Check Expected Result Actual Result Action I had to complete the last two columns with evidence of my results.

  1. A new IT system in a Dubai Marauders Rugby Football Club

    The letter must be on one side of A4. By actually doing the mail merge for the Barbarians side I am testing if the mail merge system works. So by seeing if only the people who do not play for a team get through it is proving whether the systems works or not.

  2. Database design for a games shop.

    Thank you for your help and look forward to hearing from you soon. You're sincerely Mr. Walcott Final designs On the following pages are my final designs after taking into account Mr. Walcott's comments I have made the required changes.

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

    Hussaini and themselves, so all contact details will be mentioned in the menu. 5. I am going to add a map to guide the customers to the restaurant 6. Make a logo for the shop. 7. I am going to use colorful graphics and bold and italics texts in order to attract the customers.

  2. Description of a database and it's features!

    I think that my database is very helpful for those people who are interested in football. This is because they can easily type a search into the database and find only the necessary information that they require off my database.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    did this by clicking the arrows next to them and selecting the text which I required. Once I was happy and checked the condition, I pressed "Ok." In addition to this, you can also format cells using a formula. I created a formula for the "Grade Achieved", "Grade Met?"

  2. bookings database

    Data to be protected from changes- I have prevented changes in this form by entering 'No' into the properties of the form for 'Allow edits', 'Allow deletions' and 'Allow additions'. This is effective for the user as in a busy atmosphere, mistakes can occur and the user might delete then guest's details.

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