Access Tips
Note: sound quality may
vary by TIP - sorry! Will be redoing many
of them soon for Access 2013.
Some
of these tips are done using Access 2013, some
with Access 2010.
If you need additional tips / help you can check
out http://
www.gcflearnfree.org/access2013 or
http://www.gcflearnfree.org/access2010
or you use your old friend, Google :)
If you are using USF's
apps.usf.edu - here are the 'save'
instructions:
Apple users: apps.usf.edu/content/mac.xensavingfiles.pdf
Windows users: apps.usf.edu/content/pc.xensavingfiles.pdf
DATABASE / TABLE / FORM/SWITCHBOARD Tips
Creating a Database & Table - Basics
Table fields - required, adding, deleting
Importing data into a table from Excel - single primary key
Importing data into a table from Excel - multiple field primary key
Data Validation within a Table
validation rules (numbers/text),
error messages, required fields, input mask
Creating Relationships between Tables
Creating/Editing a Form - Basics
Creating a Lookup Field from a List ~ Creating a Lookup Field from a Table
Switchboards --- Info on installing the switchboard manager in Access 2010
QUERY Tips
Numeric Criteria
Greater Than, Less Than, etc.
Using Several Wildcards & Combining Wildcards with Parameters
Advanced Wildcards
* ? #
Percent Calculations -
use a calculated field (above) and
see the percent formulas discussed on the Excel Tips
Page
Using Top Value within a Query
Formatting Fields & Sorting
(including multiple
sorts)
REPORT Tips
Creating / Editing with the Report Wizard - Basics
Report Formatting - More Advanced
Creating a Quick Report from a Query
EXPORTING Tips
Exporting to an Excel workbook
General Tips on Copying Files / Showing File Extensions
Note: if you are working ahead & don't see the TIPS you need OR you are looking for Access 2003 Tips, check the Old Tips for additional demos.