1 / 12

Agenda

Agenda. STARTER: Demo importing data (10 mins) MAIN: Importing data, create the query and report PLENARY. LEARNING AIMS. All students will know how to setup a new database and import data from an external file Most will know how to use a query to filter their results

taylor
Download Presentation

Agenda

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Agenda • STARTER: Demo importing data (10 mins) • MAIN: Importing data, create the query and report • PLENARY LEARNING AIMS • All students will know how to setup a new database and import data from an external file • Most will know how to use a query to filter their results • Some will know how to create a report with sorting and labels

  2. Save the data file from vispvle.com to D:/Y10 • Open Microsoft Access 3. Click blank database File Name: Something meaningful like: Cinema Database

  3. Click on the External Data tab and under Import, click on the Text File.

  4. Press Browse to locate the file where you have downloaded it. This may be in “Downloads” or the D: drive D:\Year 10Film Data

  5. Row headings have already been added so make sure the box is ticked

  6. CHECK ALL DATA TYPES ACROSS ALL FIELDS (COLUMNS). THEN PRESS NEXT

  7. Choose your own primary key: First column or “NO PRIMARY KEY”

  8. ADD A sensible name then click next

  9. As we are not going to be importing this data again, just press close

  10. By clicking on your film data table, your new table will open. Go to HOME->view->DESIGN VIEW to do any further formatting of fields e.g. currency or boolean

More Related