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

Setting up a database in microsoft access.

Extracts from this document...

Introduction

Implementation Setting up the Structure - To set up the database I went into Microsoft Access and clicked on 'Blank Database' then 'OK'. A window then appeared called 'File New Database.' I typed in the name that I wanted to call my database, which was - 'amandarestellacademy'. I then selected 'Create'. A window then appeared with the name of the database, with many tabs on it. I selected the 'Table' index and then clicked 'New'. I then selected 'Design View' and 'OK'. I then entered in my information (field titles) in the structure table that appeared. I changed the field properties according to my design. I had to change properties such as - field size, format, decimal places. As evidence of this I have done screen prints. I made sure that I saved my work regularly throughout. Data Capture Form - I had to collect all of the information I needed to put in this database with a sensible method. For this I created a data capture form. This consisted of, going into Microsoft Word and creating a table by selecting 'Table', 'Insert Table' and choosing how many columns and rows I needed. ...read more.

Middle

I then clicked 'Open' and my query appeared in design view. To display the results from this query I had to click the 'data sheet view' button in the top left of the screen. In the design view I could also chose which results in which fields I wanted. In the 'Show' row I could tick and untick which fields I wanted to show or not to show. The fields that I did tick were displayed in the table in the datasheet view, and the ones I did not tick, did not appear in the table. Producing Reports - To create a report I had to go into the 'Report' tab and click 'New'. I think had to select 'Report Wizard' and from the drop down box at the bottom right I had to select the query that I wanted to show as a report. I then clicked 'Ok'. I had to move all of the fields that I wanted to be displayed in the report from the 'available fields' column to the 'selected fields' column, using the single arrow in the centre of the two columns. ...read more.

Conclusion

I then selected the table from where the data I wanted the graph to be created from. In 'Chart Wizard' I selected the field from the database that I wanted to draw the graph on by using the single arrow. I then clicked 'Next'. I could then chose a suitable type of graph for example, column graph, bar graph, pie chart, scatter graph, line graph etc. After decided this I could then look at the layout of my graph to make sure that it looked ok. I then clicked 'Next'. I gave the graph a title and chose whether it had a legend or a key. I had then finished my graph. I could not see my actual graph in design view, only a model template appears and the 'Headers and Footers' section. Producing Queries - To create a query I went into the 'Query' tab and clicked on 'New', I then selected 'Design View' and clicked 'OK'. I then had to 'Add' a table of the whole database. I then moved all of the field titles from the small added table into the field headings underneath. I could then type in my criteria in the different fields to get results to my queries. Project 1b Implementation Charlotte Body 11J 30/04/2007 Mr. Webster ...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

    main menu will appear, as this is how the system is opened for administration. Refinements - Criteria 2 Criteria Details The database must be called 'Ducks System'. Evaluation The criterion was met. Evidence Limitations - Refinements - Criteria 3 Criteria Details Every button should work Evaluation Every button tested worked-

  2. ICT BTEC UNIT 2 - REPORT

    Pro is a great program for those who want to make a profitable online business and is overflowing with features to help you design your website. This program automatically creates and obtains a sitemap for your site which save you a lot if time.

  1. Documentation of a database for a sports centre.

    Date Of Birth 21/05/90 Time/Date 6 _ _/_ _/_ _ To allow us to change them to adult when they +turn 18 Postcode IG2 0ED Text 6 Mix of number and letters Shows where they live if we want to send a letter Member Type premium Text - Either "Standard"

  2. Testing database. Test plan 1 I am going to check my data restriction. ...

    I will be adding a parameter value in the query external product delivery date and then relating the result from the customer table. I expect that the results I get are correct Testing 8 In the screen shot above I have opened the external product delivery date query and inserted my parameter value.

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

  2. The aim of my project is to make the task of the allocation of ...

    To test this we will check that the drop down menus work. These include the drop down menu of "amateur" and "professional" and the selection of which show, which will VLookup the name and whether or not it is professional or amateur and will use the correct cost in the price calculation of the fixed costs.

  1. A02 Implementation Commentary

    This works by a magnetic head reading the information off the hard disk as it spins around very quickly * Floppy Disk - Floppy Disks are portable storage devices that can hold around 300 pages of text. But actually they only hold 1.44MB of stuff, so often pictures or word art will not fit onto the floppy.

  2. Database design for a games shop.

    * The system should be easy to use. * The system should be secure. * The system should not mix up any data. * We spoke over the phone about minor requirements which you will see later in the database.

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