Databases / MS Access Advanced
Details
Outline
Advanced Tables
- Input mask
- Applying validation
- Validation text
- Calculating a field
- Multiple primary keys
- Lookup fields
- Formatting a field
- Link to external data source
Recap / More on Relationships
- Why create relationships between tables?
- Different types of relationships
- Adding tables to the relationship window
- Creating, editing, deleting relationships
- Conditions for setting up a relationship
- Understanding Referential Integrity
- Saving relationships
Advanced & Action Queries
- Creating Calculated fields
- Creating Parameter Queries
- Creating Summary Queries
- Creating a Crosstab Query
- Editing a Crosstab Query
- Use the Top Values option in a Query
- Create and use a Make Table Query
- Create and use an Append Query
- Create and use a Delete Query
- Create and use an Update Query
Advanced Forms
- Main Form and sub forms
- Exploring Layout View
- Split forms
- Using Checkboxes & toggle buttons
- Using combo boxes
- Adding Option group controls
- Adding Command button Controls
- Setting more form properties
- Calculation in a Form
- Changing the data source options
- Defining Validation Rules
- Using advanced controls
Advanced Reports
- Customise your Report
- Format the controls
- Using Expressions
- Adding Sub Reports
- Parameter reports
- Report Templates
- The Keep Together property
- Mailing Labels
- Grouping interval properties
- Group Headers/footers calculations
- Page setup
- Page breaks
Importing & Linking Data
- Importing from Access and Excel
- Linking to an external Access Database Table
- Linking to an Excel Workbook
- Renaming and Copying Tables
- Linked table manager
- Export to various formats
- Charts and Pivots
- Create a PivotChart / PivotTable
- Edit PivotTable options
- Formatting a chart/changing chart type
- Chart based on single record
Pery Square Business College provide training for companies, individuals and groups. We run scheduled training courses from our premises in Pery Square and also offer onsite training tailored to the needs of any organisation. Pery Square Business College have over 20 years industry experience.
We cater for all ages and skill levels - from Absolute Beginners to Business Professionals and Trainers.
Our Tutors are all highly qualified and class sizes are kept small.
We cater for Business Training, both in-house at our training rooms or on-site at the company's offices.
Specially customised training affords our Business Clients the assurance of compliance within their I.T. and customer service systems.
Our Recruitment Agency links up with many organisations in the Limerick city and Mid-West Region offering a discreet and confidential service for both temporary and permanent placements to the private and public sectors. All candidates are screened by experienced consultants prior to introduction, in order to match the most suitable candidate to our customer requirements.