Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
The Most Convenient Way to Boost Your Confidence And Learn MS Access 2013 Inside And Out—Quickly, No Travel or Classes.
Get An Advanced Understanding of the Many Access 2013 Features That Will Enable You to Gather and Interpret Data Faster.
- Sorting Information and Running Queries
- Creating Tables and Relationships
- Designing Forms (+ Advanced Form Options)
- Generating Reports
- Splitting the Frontend and Backend
- Macros
- Visual Basic for Applications (VBA)
Learn to Capture and Synthesize Information, Becoming a Data Management Guru.
Being a data rock star is more important than ever. To stand out in the workplace, it's essential to be able to find information fast and to identify game-changing insights.
The Microsoft Access 2013 database can help you store and track a variety of information, such as inventory, contacts, or business processes. Logistically, it combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools, and is a member of the Microsoft Office suite of applications, included in the Professional and higher editions, or sold separately.
It is a tool that spans across many fields and is helpful to anyone needing to tightly organize varied data: office managers, project managers, executive assistants, scientists, and busy families to list a few.
Contents and Overview
Through 96 lectures, 19 hours of quality content, and 2 quizzes, this 19-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources.
Budding Access 2013 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence.
Practice files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application.
This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills.
Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately.
** Updated June 2017. Course transcripts now available.
Course Content
- 41 section(s)
- 99 lecture(s)
- Section 1 Access 2013: Introduction
- Section 2 Access 2013: Using Touch
- Section 3 Access 2013: Getting Started
- Section 4 Access 2013: Help
- Section 5 Access 2013: Keyboard Shortcuts and Key Tips
- Section 6 Access 2013: Access Options
- Section 7 Access 2013: The Ribbon and Toolbars
- Section 8 Access 2013: Status Bar
- Section 9 Access 2013: Database Basics
- Section 10 Access 2013: Tables
- Section 11 Access 2013: Datasheet View
- Section 12 Access 2013: Table Design
- Section 13 Access 2013: Forms
- Section 14 Access 2013: Queries
- Section 15 Access 2013: Reports
- Section 16 Access 2013: Printing
- Section 17 Access 2013: Importing and Exporting Data
- Section 18 Access 2013: Templates and Application Parts
- Section 19 Access 2013: More on Forms
- Section 20 Access 2013: Macros and VBA
- Section 21 Access 2013: Additional Topics
- Section 22 Access 2013: Security
- Section 23 Access 2013: Conclusion
- Section 24 Access 2013 Advanced: Introduction
- Section 25 Access 2013 Advanced: Indexes
- Section 26 Access 2013 Advanced: Datasheet View
- Section 27 Access 2013 Advanced: Linking Access Databases
- Section 28 Access 2013 Advanced: ODBC and SQL Server
- Section 29 Access 2013 Advanced: Splitting an Access Database
- Section 30 Access 2013 Advanced: Multi-user Aspects
- Section 31 Access 2013 Advanced: Macros
- Section 32 Access 2013 Advanced: The Ribbon
- Section 33 Access 2013 Advanced: Visual Basic for Applications
- Section 34 Access 2013 Advanced: Events
- Section 35 Access 2013 Advanced: Forms
- Section 36 Access 2013 Advanced: SQL
- Section 37 Access 2013 Advanced: Joins
- Section 38 Access 2013 Advanced: Action Queries
- Section 39 Access 2013 Advanced: Packaging your Application
- Section 40 Access 2013 Advanced: Web Apps
- Section 41 Access 2013 Advanced: Conclusion
What You’ll Learn
- Sorting information and running queries
- Practice with exercise files that are included with both courses
- Safeguards and restrictions
- Creating tables and relationships
- Navigating the Access 2013 interface
- Designing forms
- How to use queries
- Generating reports
- Discover how to effectively link to other data sources
- Learn how to split a database by splitting the frontend and backend
- Find out about the use of macros
- Explore the use of Visual Basic for Applications (VBA)
- Discover advanced options for the use of forms
- Dive into options for packaging your application for distribution
Skills covered in this course
Reviews
-
NNuria
Bien, pero hay partes que no se pueden aplicar . Templares que ya no existen o sitios web para alojar web apps ( Microsoft ya no recomienda MS Share Point
-
CChristopher J Barrero
I like the pace at which this course in been taught. I am hoping to see if there is a section where it shows how to print reports, including attachments from the same data base.
-
TTimothy C Nicholas
I learned quite a few new tricks and programming techniques. Great instruction plan in a nice logical sequence. Thanks Toby for your help.
-
AAllan R Caple
It looks like it will be a very positive experience, [update] and it has proven to be so. I have learnt so much and I am applying that knowledge in building my own database. I had to cover some subjects a couple of times as I started with almost no working knowledge of this subject. However, the ability to revisit material that didn't 'click' the first time is invaluable. I'm very pleased with the content and the presentation. Excellent value!