|| Feedback | Books about Access | Linking Excel to Access ||
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.
an Access database for
|file: acctempindex.htm||Page last updated Jun07||© MeadInKent.co.uk 2014||accmik_template|