Microsoft Office Access 2013: Level 3 Training in Cambridge
Enroll in or hire us to teach our Microsoft Office Access 2013: Level 3 class in Cambridge, Massachusetts by calling us @303.377.6176. Like all HSG
classes, Microsoft Office Access 2013: Level 3 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 3 may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
Students taking this course are database administrators or prospective
database administrators who have experience working with Access 2013 and
need to learn advanced skills. This course is also for students who seek
the Microsoft Office Specialist (MOS) certification and who want to
prepare for Exam 77-885, Microsoft Office 2013
Course Length: 1 Days
Course Tuition: $250 (US) |
Prerequisites |
|
To ensure your success in your course you should have experience working with Microsoft Access 2013, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. |
Course Outline |
Lesson 1: Implementing Advanced Form Design
Topic A: Add Controls to Forms
Topic B: Create Subforms
Topic C: Organize Information with Tab Pages
Topic D: Enhance Navigation of Forms
Topic E: Apply Conditional Formatting
Lesson 2: Using Data Validation
Topic A: Field and Record Validation
Topic B: Form Validation
Lesson 3: Using Macros to Improve User Interface Design
Topic A: Create a Macro
Topic B: Restrict Records Using a Condition
Topic C: Validate Data Using a Macro
Topic D: Automate Data Entry Using a Macro
Topic E: Convert a Macro to VBA
Lesson 4: Using Advanced Database Management
Topic A: Link Tables to External Data Sources
Topic B: Manage a Database
Topic C: Determine Object Dependency
Topic D: Document a Database
Topic E: Analyze the Performance of a Database
Lesson 5: Distributing and Securing a Database
Topic A: Splitting a Database for Multiple User Access
Topic B: Implement Security
Topic C: Set Passwords
Topic D: Convert an Access Database to an ACCDE File
Topic E: Package a Database with a Digital Signature
Lesson 6: Managing Switchboards
Topic A: Create a Database Switchboard
Topic B: Modify a Database Switchboard
Topic C: Set Startup Options
|
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.
- Advanced Java Programming
15 February, 2021 - 19 February, 2021 - Java Modules and New Features (Java 11+)
15 February, 2021 - 16 February, 2021 - VMware vSphere 6.7 with ESXi and vCenter
25 January, 2021 - 29 January, 2021 - Advanced C++ for Experts - Design Patterns, STL, C++11/C++14
12 April, 2021 - 13 April, 2021 - Intermediate Python 3.x
16 February, 2021 - 19 February, 2021 - See our complete public course listing