Query

QUERY
            A query is a question that we ask the database in a language called SQL.

Recordset - is the answer that we get back from the database.

3 Viewing options while working with queries:
  1. Design View
  2. SQL View
  3. Datasheet view 

Elements of a Query

-          Field List/s
-          QBE grid
o    Field
o    Sort
o    Show
o    Criteria
o    Or
o    Total
-          Column selectors

comment 0 comments:

Post a Comment

Delete this element to display blogger navbar

 
© C.L.S.T.I. Tutorial | Design by Blog template in collaboration with Concert Tickets, and Menopause symptoms
Powered by Blogger