This class builds on the concepts taught in Access Basic and covers more advanced features.
Training Class Goal
Students coming from this class will have skills for developing more advanced Access databases and extracting advanced reports from their databases.
Basic Access skills including: navigation, creating and using databases in both design and datasheet view, creating basic reports, queries and forms.
- Relational databases
- Database normalization
- Table Relationships
- Referential integrity
- Creating lookup fields
- Complex queries
- Joining tables in a query
- Using calculated fields
- Summarizing and grouping values
- Advanced form design
- Adding unbound controls
- Adding combo boxes
- Reports and printing
- Customized headers and footers
- Calculated values
- Charts in forms and reports
- PivotTables and PivotCharts
Live & In-Person
All of the classes on this page are taught by live instructors who are present in the classroom.
Retake any public class up to 6 months after original class date....Read more
Interactive classes allow you to immediately try out new skills....Read more
Live instructors deliver our classes in an engaging and interactive way....Read more
Classes limited to 12 students for more individual attention....Read more