Basic Querying in Access
Categories: Microsoft Access
Basic Querying in Access.

About the Course:
This course is for Microsoft Access versions up to 2003 Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.

Course Contents:

- Designing a database
- Identifying the tables
- What are relationships?
- Setting a primary key
- Creating tables
- Defining fields
- Types of field
- Entering data
- Drawing relationships
- Creating relationships
- Referential integrity
- Importing data
- Importing from Excel
- Linking to Excel spreadsheets
- Problems with importing
- Creating queries
- The query design grid
- Sorting
- Setting criteria
- Combining criteria
- Advanced queries
- Grouping and totalling
- Creating expressions
- Parameter queries
- Creating ad hoc joins
- Types of join
- Creating forms
- Using the form wizard
- Using forms to enter data
- Form design
- Creating controls
- Creating reports
- Using the report wizard
- Using print preview
- Report design

 
Tools
 
Key Details
Duration1 day
 
£225
per delegate