querying tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » Querying Tables

Querying Tables

resolvedResolved · Low Priority · Version Standard

Gillian has attended:
Access Introduction course

Querying Tables

Please explain how to modify existing query criteria

RE: Querying Tables

Hi Gillian, Welcome to the forum, I hope you enjoyed your Access course, to answer your question; modifying query criteria is usually undertaken in query design view in the query design grid, here you can add or delete fields and add or delete criteria, change the type of query that you wish to use, as well as adding calculated fields etc. I hope that helps, best regards Pete


 

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips


Server loaded in 0.09 secs.