Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Database Querys

And, Or queries in MS Access
by

Chris Bowler

on 25 May 2011

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Database Querys

DATABASES OBJECTIVES > Search the database using simple queries

> Search the database using And Or queries

> Create a parameter query to find specific information What is a query? A query is a question that you ask the
database in order to get an answer. OR Queries Or queries let you search for
records that match either 1
criteria or another. Size 5 or 6 shoes AND Queries And queries lets you search for
records that match both criterias Blonde hair and No alibi The computer searches the database
for all the records that match the criteria and displays it on screen Query Queries let you search for
records that match the
criteria. Blonde hair Task 1 Create separate queries to find all the reords for the following criteria > Black hair
> Do Not have an alibi
> Size 5 shoes
> Have a distinguishing mark Task 2 Create seperate queries to find all
the records for the following criteria > Black or Brown hair
> Size 5 or 6 shoes
> Tattoo or Piercing

> Create 2 more of your own Task 3 Create separate queries to find all
the records for the following criteria > Blond hair and Size 7 shoes
> A Tattoo and Have an alibi (yes)

> Create 2 more of your own
Full transcript