Microsoft Office Access 2013: Level 2 Training in Medford
Enroll in or hire us to teach our Microsoft Office Access 2013: Level 2 class in Medford, Massachusetts by calling us @303.377.6176. Like all HSG
classes, Microsoft Office Access 2013: Level 2 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it
is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Access 2013: Level 2 may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
This course is designed for students wishing to gain intermediate-level
skills or individuals whose job responsibilities include constructing
relational databases, performing database maintenance, creating advanced
queries and reports, or integrating Access with other programs.
Course Length: 1 Days
Course Tuition: $250 (US) |
Prerequisites |
|
To ensure your success, it is recommended you have completed Microsoft® Office Access® 2013: Part 1, or possess equivalent knowledge. |
Course Outline |
Lesson 1: Designing a Relational DatabaseTopic A: Relational Database Design Topic B: Create a Table Topic C: Create Table Relationships Lesson 2: Joining TablesTopic 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 EfficiencyTopic A: Data Normalization Topic B: Create a Junction Table Topic C: Improve Table Structure Lesson 4: Sharing Data Across ApplicationsTopic 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 ReportingTopic A: Organize Report Information Topic B: Format Reports Topic C: Include Control Formatting 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 OptionsAppendix B: Microsoft Office Access 2013 Exam 77-424Appendix C: Microsoft Access 2013 Common Keyboard Shortcuts |
Course Directory [training on all levels]
Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.
- Intermediate Python 3.x
16 February, 2021 - 19 February, 2021 - VMware vSphere 6.7 Boot Camp
25 January, 2021 - 29 January, 2021 - Java Programming for Experienced Programmers
22 February, 2021 - 26 February, 2021 - Advanced Java Programming
15 February, 2021 - 19 February, 2021 - Administering the WildFly 14 and JBoss EAP 7.2 Application Servers
22 March, 2021 - 26 March, 2021 - See our complete public course listing