Home	Excel	Access
| Feedback | Books about Access | Linking Excel to Access |

Twenty things to do with Access database queries - help and examples

Databases will be very limited in scope without an understanding of queries. A query can almost always enhance a  table and improve the presentation of the data, either by sorting, joining, updating, grouping or limiting fields and records.

These pages contain examples of Access database queries that are designed to indicate the scope of what can be achieved with relatively little experience. This guide does not talk you through step by step on how to use the Access program. A basic understanding of database design and creating a query is assumed.

Pages about queries
1 User defined fields and query parameters	2 setting date parameters	3 introduction to_linking_tables	4 alternative sort by options
5 adding a total row within a query	6 splitting records into more than one row in a query -_journals	7 conditional formatting	8 referring to program data
9 a top values query to see the highest or lowest items	10 linking two tables using wildcard values (and updating)	11 using Like and wildcards in criteria	12 delete and update queries
13 using values from a form	14 identifying postcodes within address fields	15 text functions and an append query	16 finding a value within a text field or string
17 formatting values and column headings	18 using wildcards to link tables	19 transposing a single record into several rows	20 null values and missing links

Office Leave Planner

an Access database for recording and displaying planned staff absences [View details]