ACCESS 2016 LEVEL 2

Your training and experience using Microsoft® Access® has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users. 
You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft® Access® . 

 

Course Objectives:


In this course, you will work with relational database structure, relationships, efficiency, integrity, and customization. 
 

You will:


Design a relational database. 
Join tables to retrieve data from unrelated tables. 
Organize a database for efficiency, performance, and to maintain data integrity. 
Share data between Access and other applications. 
Customize reports to organize the displayed information and produce specific print layouts. 

 

Course Content


Lesson 1: Designing a Relational Database 
Topic A: Relational Database Design 
Topic B: Create a Table 
Topic C: Create Table Relationships 

Lesson 2: Joining Tables 
Topic A: Create Query Joins 
Topic B: Join Tables That Have No Common Fields 
Topic C: Relate Data within a Table 
Topic D: Work with Subdatasheets 
Topic E: Create Subqueries 

Lesson 3: Organizing a Database for Efficiency 
Topic A: Data Normalization 
Topic B: Create a Junction Table 
Topic C: Improve Table Structure 

Lesson 4: Sharing Data Across Applications 
Topic A: Import Data into Access 
Topic B: Export Data to Text File Formats 
Topic C: Export Access Data to Excel 
Topic D: Create a Mail Merge 

Lesson 5: Advanced Reporting 
Topic A: Organize Report Information 
Topic B: Format Reports 
Topic C: Include Charts in a Report 
Topic D: Add a Calculated Field to a Report 
Topic E: Add a Subreport to an Existing Report 

Appendix A: Additional Reporting Options 
Appendix B: Microsoft Office Access 2010 Exam 77-885 
Appendix C: Microsoft Access 2010 Common Keyboard Shortcuts

Convenience and Quality instruction is our goal at John Mason Institute.

Available formats

Live in person instructor at our classroom or remote instruction in the traditional classroom style

 

 

Remote one on one  instruction for your convenience with our top quality teachers.

Instruction with a very flexible schedule

Do you need a class date and time not on the schedule or prefer the instruction be done at your location? Then please contact us and we work very hard to meet your needs.

GET MORE INFORMATION

CALL US NOW

603 879 0991

Full Placement and Temporary service available with
John Mason Services
Now Featuring CCNA, CCNP and CCIE Training
Photography Services available including Headshots

© 2023 by John Mason Institute /Hellenic College 
436 Amherst street , Nashua, NH 03063, USA

  • Facebook Round
  • Twitter Round
  • YouTube - Black Circle
  • Google+ - Black Circle
  • LinkedIn Round