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			ox
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 variables
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

Plus another one...

Union queries are not one of the regular query types created by Access. Nevertheless they are a useful method of combining similar tables or queries to produce a single set of data.

Office
Leave
Planner

an Access database for
recording and displaying
planned staff absences

[View details]

file: acctempindex.htm

Page last updated Jun07

accmik_template