This one-day course builds on the skills and
concepts taught in Access 2013: Basic. Students will
learn how to normalise data; work with Lookup fields and
subdatasheets; create join queries; add objects to
forms, print reports and labels; create charts; and use
PivotTables and PivotCharts.
After completing this course, students will know how to:
Relational databases
Topic A:
Database normalisation
Topic B: Table relationships
Topic C: Referential integrity
Related tables
Topic A: Creating
lookup fields
Topic B: Modifying lookup fields
Topic C: Subdatasheets
Complex queries
Topic A: Joining
tables in queries
Topic B: Using calculated fields
Topic C: Summarizing and grouping values
Advanced form design
Topic A:
Adding unbound controls
Topic B: Graphics
Topic
C: Adding calculated values
Topic D: Adding combo
boxes
Topic E: Advanced form types
Reports and printing
Topic A:
Report formatting
Topic B: Calculated values and
subreports
Topic C: Printing
Topic D: Label
printing
Charts
Topic A: Charts in forms
Topic B: Charts in reports
Before taking this course, you
should be familiar with personal computers and the use
of a keyboard and a mouse. Furthermore, this course
assumes that you've completed the following courses or
have equivalent experience: Windows : Basic level and Access 2013: Basic
level.
Youshould be comfortable using a personal computer and Microsoft Windows. You
should also have some experience using Access 2013. You
will get the most out of this course if your goal is to
become proficient using more advanced Access features
and functions, such as relating tables, referential
integrity, joins, queries, forms, reports, charts,
PivotTables, and PivotTables charts and forms.
For comprehensive training, you should complete all of the following courses: Access 2013: Basic, Access 2013: Intermediate, and Access 2013: Advanced.