Database Series –

Access Basics II

--------------------------------------------------------------------------------------

1. Tables, tables, tables…
1. Table Design Views
1. Field Types
2. Field Size
3. Input Mask
4. Caption
2. Creating tables and formatting them
1. Sorting
1. The sort keys (a-z with an arrow)
2. One column
3. Multiple Columns (left to right)
2. Printing Tables
3. Filtering (extracting specific records) by selection
1. Select a field or part of a field
2. Select the button (filter with lightning)
3. Click the filter button again to return to all
4. Filtering by Input
1. Select a column and right click
2. Click in the filter for text box
3. Enter your filter
4. When done click the datasheet press enter
5. Click the button (filter only) to return to all the records
5. Filtering by form
1. Click on the filter form button (filter with a page)
2. Select the field containing the data you wish to search
3. Click the down arrow, select the correct data
4. You can do more than one:
1. Select state, then city to filter first by state then by city.
5. Click the x if you wish to try a new filter
6. Click the filter to actually see your filtered records
7. Click close to end
6. Advanced Filtering (pull down menu) using criteria
1. Learning conditions =,<,>,>=,<=, or, and, *, ?, #
7. Finding Data
1. The find button (binoculars)
2. Using conditions
3. Reports
1. Using the report wizard versus by hand
2. Layout
3. Content (fields and sorting)
4. Naming it (save)
5. Printing it
1. watch those margins
2. page orientation