• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

Q1:Explain the difference between the And and Or query conditions.
A1: With the And condition, both of the specified conditions must be true in order for the row to appear in the query result. With the Or condition, only one of the specified conditions must be true in order for the row to appear in the query result.
Q2:Explain the difference between ? and * in query criteria.
A2: ? acts as a wildcard for a single character, whereas * acts as a wildcard for multiple characters.
Q3:Explain the difference between a Select query and an Action query.
A3: A Select query retrieves data, whereas an Action query inserts, updates, or deletes data (that is, modifies data in some way).
Q4:Explain the difference between saving a query and saving the layout of a query.
A4: Saving a query saves the SQL underlying the query. Saving the layout of a query saves the visual appearance of the datasheet.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint