• 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. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Once I had inserted them, I arranged them so that they formed a border at the top of the worksheet, to make it look professional and eye-catching. Although, the teacher will know what the name of the school is, I have included it to show that it does belong to


    The disadvantages would be that it doesn't let you put your own documents in such as HTML or Word documents, and some might say it's too basic. First Page version 3 final CPU = 75 MHz Pentium processors HDD Space = 50 Mb Graphic Card = GeForce 8800 ultra Monitor

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

    * Frame layout * Embedded graphics * Templates * Style sheets * Scaleable fonts * Page setup * Typing text * Placing text * Placing graphics * Sizing and cropping graphics * Bold, italics and underline text * Bullet * Clip art * Clip board Here is the software that

  2. Project 1b; Film Database

    I will have to deal with them: * I want to buy a movie but I have forgotten its name. I am only able to recall some features. Can you tell me a movie that has not the letter 'x' in its title, but the letter 'e', and came out between the years 1999 and 2006 with the genre action?

  1. implementation report

    writing as the main page so that the system would look professional; I also added the same pictures as the main page to make it look even more professional Now that the layout of the form had been created I had to add command buttons to do specific jobs to

  2. 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.

  1. User Documentation

    1, You need to open up the database, type in the password, open the main menu, and click on 'Registered Childminding Contract.' 2, This screen will then appear: 3, On this form, you have to enter all your details in.

  2. 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

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