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

Opening the database

Extracts from this document...


OPENING THE DATABASE To open the database Microsoft Access will need to be opened. The program needs to be opened first in order to access the actual database file. Microsoft Access will either have an icon or will be found under start and then programs. In order to open the database, opening an existing database needs to be selected. If the database is not on the list of existing database then "more files" needs to be clicked on, followed by ok. Once the file has been selected from the relevant folder or user space the database can be opened. In the case of this database, the file was found under my user space and in my IT GCSE coursework folder. When the database has been opened a main menu will be found. This allows the user to easily navigate around the database. The Peterson's main menu shows the separate headings, which make it easier for the user to understand. ...read more.


The images above show some of the examples of drop down windows in the form. The arrow button can be clicked on and the required data can be chosen from the list or it can be typed in. However, the data will only be entered if the data being typed in matches one of the words in the list. * In some cases the data may not be in the list or a length check may be programmed to be too short. Therefore this will need to be edited. To do this the form can be closed by selecting "close form." The correct table needs to be opened and the design view button needs to be selected. To add another choice to the drop down menu, the correct field needs to be selected, for example "Title." If the option Master was not in there, it could be added by typing "Master" in the box labelled row source. * The user can then type information in the empty boxes. ...read more.


By clicking right clicking on the grey space next to the record not only brings up a menu with a list of commands, but also high lights the record in question. Then to delete the record the "delete record" button needs to be selected. * Microsoft Access then asks if you are sure that you want to delete this record, because it will be unable to undo the operation performed. This is to prevent records from accidentally being deleted. * In order to delete more than one record without having to do the above process several times, the following steps can be taken. The datasheet view should be selected, by right clicking on the form. The appropriate records that need to be deleted can be selected by clicking on the grey bar for the record and then holding the shift key. Then click the last record that needs to be deleted. This will then highlight all the records that need to be deleted. Still holding the shift key down, the information can be right clicked on and then delete records can be selected. ...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. AQA GCSE ICT Specification B

    Open each output viewing page Print button will be present 7. 7. Each page must display the company's logo Open every page Logo will be displayed 8. 8. The 'Sales Summary' page must display an 'Enter Two Dates' box before opening Press the 'show sales list' button The 'Enter Two Dates' box shows before opening 9.

  2. Evaluating a relational database solution

    Cut, copy and paste > The cut facility allowed me to choose a part of the text and 'cut it out'. 'Cut' text was either thrown away or 'pasted' back onto the in another place. The cut, copy and paste facilities allowed me to work with graphics in the same way as with text.

  1. Setting up a database in microsoft access.

    It then asked if I wanted any grouping levels and I said no, and it then asked what sort order I wanted but I just clicked 'next' as this did not apply to my record. I could then choose the layout that I wanted my report to be in.

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

  1. What is a database?

    Personally I would go for 20 characters for surname, ones that are longer could be shortened to fit. Fields at GCSE level will fall into 3 major categories: * Text (alphanumeric) - letters and numbers * Numeric - just numbers * Date - well dates funnily enough For those smart

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

    Simple Query Wizard The Query you create produces a new table which you can print out by producing a Report The easiest way of producing a report on the Access database is by using the Report Wizard Evaluation of my own database!

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

    To do this, I followed the steps high-lighted in "Step 8," only inserting a different formula. I wanted the formula to say, if it had said "inform parents" in the writing table, I wanted it to write "writing" in the new column, if it had said "inform parents" in the

  2. bookings database

    changed to required as if these details were not filled in, it would be difficult to either find/modify guest details or to contact a guest. 5. Easy to save the data-there is the command button that is called 'Save record'.

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