MeadInKent
| 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
office leave

an Access database for
recording and displaying
planned staff absences

[View details]



file: acctempindex.htm Page last updated Jun07 MeadInKent.co.uk 2014 accmik_template