Access Intermediate
Who is the course for?
If you find yourself needing to know more about what an Access database can do, this course will give you a good overview; providing practical hands-on experience with its many features.
You will finish the course with a good general knowledge on Access and how you can use it to meet your needs.
What the course will cover:
- Database Concepts Revision
- Database development
- Creating a database
- Creating tables
Field properties
- Creating a Lookup fields (for drop down boxes)
- Default values
- Setting a mandatory field
- Input masks
- Validation rules/text
Queries
- Creating a Sum and Count query
- Average
- Maximum and minimum values
- Top Values
- Parameter queries for a multipurpose query
- Using wildcards in queries
Relationships
- Looking at relationships and how they work
- Applying relationships to tables
- One to one relationships & Many to many relationships
- Applying joins
Forms
- Main/subform wizards
- Linking forms
- Form controls
- Combo boxes & List boxes
- Reports
- Customising and modifying Reports
- Creating Summary reports with calculations
- Grouping reports
- Sub reports
- Calculating fields in a report
- Headers and footers
Importing & exporting data
- Time permitting Action queries - crosstab, find duplicates queries
