1 / 8

The Vintage Catalogue Queries

The Vintage Catalogue Queries. Learning intentions. Be able to perform a simple search (Level 4-) Be able to perform a complex search (on more than one field) (Level 4) Be able to create a printable report (Level 4-/4). Tasks. Open the Catalogue table in your vintage database

vega
Download Presentation

The Vintage Catalogue Queries

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. The Vintage Catalogue Queries

  2. Learning intentions • Be able to perform a simple search (Level 4-) • Be able to perform a complex search (on more than one field) (Level 4) • Be able to create a printable report (Level 4-/4) Tasks Open the Catalogue table in your vintage database Open the slides from VLE 3) Create a simple query 4) Create a report based on that query

  3. Create a query Open your catalogue table Click on the Create Tab Create a Query Design

  4. Add your Catalogue data table Add in all your fields by double clicking

  5. Entering criteria For a simple search, choose one thing on the CRITERIA ROW: e.g. Category: “Shoes” Year: <2000 Price: >=30 Notice that when you search for words in your query you use quotation marks. Notice also how you do not need to use the £ sign for price Printscreen this search criteria in a Word or Powerpoint file

  6. Create queries and create 2 printscreens to show the criteria and results • All clothing which costs more than £5 • All shoes made before the year 2000, larger than a size 4 • All Accessories made after 1999, costing £5 or more.

  7. Create a report To create a report, change the view of your query to Datasheet view and then simply click: Create-> Report You will be asked to save your query. Give it a sensible name. Format it the same as you did your form last week: Design view: To Design i.e. fonts and colour Layout view: To Layout i.e. re-arrange/reposition Report view: To View/Print ADD YOUR NAME AND PRINT YOUR FINISHED REPORT

  8. Homework Print and label your query printscreen and your finished report: Explain what you are searching for in your query Explain the design of your report (fonts, colours, layout, title, pictures)

More Related