Date/Time
Date(s) - 14/09/2016
All Day
Location
Edinburgh Training Centre
Categories
Audience: This course is ideal for those who wish to interrogate existing Access databases, create queries and reports as well as gaining an insight into the fundamentals of database design using Tables and Relationships.
Course Duration: 1 day(1)
Module 1: Table Design
- Setting advanced field properties in tables
- Input masks
- Validation rules
- Default values
- Lookup fields
- Creating Calculated Fields on Tables
- Relating Tables and the different types of Relationships
Module 2: Creating Relationships between Tables
- Creating Relationships
- Different Relationship types
- Viewing subdatasheets
- Setting referential integrity
- Cascade options
Module 3: Select Queries
- Select queries explained
- Creating select queries
- Working with query views
- Adding and deleting fields
- Sorting records in the Design View
- Using query criteria
- Adding calculated fields
Module 4: Designing Advanced Queries
- Setting join types between tables and queries
- Setting top values in a query
- Creating Calculated fields
- Creating Summary queries
- Grouping queries
- Creating Parameter queries
Module 5: Action Queries
- Update Query
- Make Table Query
- Delete Query
- Append Query
- Union Query
Module 6: Working in Form Design View
- Manipulating controls in form design view
- Changing form and control properties
- Adding controls to a form
- List boxes, Check boxes and Option buttons etc.
- Using calculations on forms
Module 7: Working in Report Design View
- Manipulating controls in a report
- Changing report control properties
- Managing sorting and grouping in reports
- Adding calculations to a report
- Controlling pagination
Module 8: Using Sub forms and Sub reports
- Creating Sub forms
- Creating Sub reports
Bookings
Bookings are now closed for this event.