-
Microsoft Access 2013: Level 3 - Advanced
-
Course length:
1.0 day
Course Objective:
You will create complex Access databases by structuring existing
data, writing advanced queries, working with macros, and performing
database maintenance.
Target Student:
This course is for the individual whose job responsibilities include
working with heavily related tables; creating advanced queries,
forms, and reports; writing macros to automate common tasks; and
performing general database maintenance.
Certification:
This course is one of a series of courseware titles that addresses
Microsoft Office Specialist (MOS) certification skill sets. The
MOS and certification program is for individuals who use Microsoft's
business desktop software and who seek recognition for their expertise
with specific Microsoft Excel-Add-In.
Course Objectives:
Upon successful completion of this course, students will be able
to:
- restructure data into appropriate tables to ensure data
dependency and minimize redundancy
- write advanced queries to analyze and summarize data
- create macros
- customize reports by using various Access features
- maintain your database using Access tools.
-
Course Content
Lesson 1: Structuring Existing Data
- Restructure the Data in a Table
- Create a Junction Table
- Improve the Table Structure
Lesson 2: Writing Advanced Queries
- Create Subqueries
- Create Unmatched and Duplicate Queries
- Filter Records Using Criteria
- Summarize Data Using a Crosstab Query
- Create a PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
Lesson 4: Creating Effective Reports
- Include a Chart in a Report
- Print Data in Columns
- Cancel Printing of a Blank Report
- Publish a Report as a PDF
Lesson 5: Maintaining an Access Database
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
Appendix A: Microsoft Office Access 2013 Exam 77–885