1 / 11

Query Task

Query Task. In this lesson you will be creating two queries a simple query an AND query You will be creating one to do the following: Super heroes that can fly Super heroes who are tall AND famous. Instructions on how to create a simple query. Select ‘ Create ’

miriam
Download Presentation

Query Task

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. Query Task • In this lesson you will be creating two queries • a simple query • an AND query • You will be creating one to do the following: • Super heroes that can fly • Super heroes who are tall AND famous

  2. Instructions on how to create a simple query • Select ‘Create’ • Choose the ‘Query Design’ icon • Click on the add button to add the table ( characters) and then click on the close button

  3. How to add your table and select fields Double click on each field name to add it to the bottom

  4. Simple Query- Super heroes who can fly A simple query is where we are searching for records that match only one criteria. Under the Super Power, in the criteriarow, enter ‘flight’

  5. Simple Query- Super heroes who can fly Next you need to save your query. Right click on the Tab and select Save. Save this query as ‘Superheroes who can fly’

  6. And Query-Superheroes who are tall and famous Check your query works by opening it. If it doesn’t work, you can check your query by right clicking on the query and opening it in Design View

  7. And Query-Superheroes who are tall and famous Save this query as –tall and famous heroes An AND query is where we are searching for records that match two or more criteria like the example shown below. If you do correctly the design view of the query will look similar to this

  8. Extra Information • The next few slides will have some extra information on Queries Extension • Can you create your own query?

  9. Logical Query • These types of queries use the following symbols • Can be used on the following types of data • Number fields • Currency Fields • Date/Time fields

  10. Example of a logical query Pocket money is Less than £10

  11. Parameter Query • A query related to particular query that can be used over and over again • It comes up with a prompt box for you to enter criteria every time it is run • E.g. • Find all the people with a certain special talent

More Related