Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Get An Advanced Understanding of the Many Access 2013 Features That Will Enable You to Gather and Interpret Data Faster.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Access 2013: Introduction|
Acquiring Access 2013; Course OverviewPreview
IMPORTANT - Read this to ensure the best video quality!
What's New in Access 2013Preview
|Section 2: Access 2013: Using Touch|
|Section 3: Access 2013: Getting Started|
Database Templates; Creating, Opening and Saving Databases
Access 2013 Exercise Files
Workspace and Backstage View
|Section 4: Access 2013: Help|
Online, Offline, and Contextual Help
|Section 5: Access 2013: Keyboard Shortcuts and Key Tips|
Finding Keyboard Shortcuts and Key Tips
|Section 6: Access 2013: Access Options|
Customizing the Settings and Use of Access 2013Preview
|Section 7: Access 2013: The Ribbon and Toolbars|
Quick Access Toolbar
|Section 8: Access 2013: Status Bar|
Customizing the Status Bar
|Section 9: Access 2013: Database Basics|
Overview of the Main Features of Access Database
Web App Basics
|Section 10: Access 2013: Tables|
Creating Tables - Part 1Preview
Creating Tables - Part 2
Relationships Between Tables - Part 1
Relationships Between Tables - Part 2
|Section 11: Access 2013: Datasheet View|
Inserting and Formatting Fields; Field Validation; Navigation Buttons
Sorting, Filtering and Finding Data
Entering Data; Changing the Order of Columns, Field Width and Height
|Section 12: Access 2013: Table Design|
Design View; Field Properties
Saving Data; Data Types, Attachments and Field Size
Input Masks; More on Field Properties
|Section 13: Access 2013: Forms|
Creating Forms; Form WizardPreview
Single Forms; Insert, Delete, Modify, Sort and Filter Records
Layout View; Adding Existing Fields
Design View; Arranging Fields
|Section 14: Access 2013: Queries|
Joins and Query Wizard
Operators and Expressions - Part 1
Operators and Expressions - Part 2
Operators and Expressions - Part 3
|Section 15: Access 2013: Reports|
Report Wizard; Previewing a ReportPreview
Grouped and Summary Reports; Modifying a Report
|Section 16: Access 2013: Printing|
Documenter; Print Properties and Options
|Section 17: Access 2013: Importing and Exporting Data|
Import and Append; Copy and Paste; Export Access Database
|Section 18: Access 2013: Templates and Application Parts|
Database Templates and Application Parts
|Section 19: Access 2013: More on Forms|
Modal Dialogs - Part 1
Modal Dialogs - Part 2
Modal Dialogs - Part 3
|Section 20: Access 2013: Macros and VBA|
Actions; Example of VBA; Creating AutoExec Macro
|Section 21: Access 2013: Additional Topics|
More Access Options
|Section 22: Access 2013: Security|
|Section 23: Access 2013: Conclusion|
Access 2013 Quiz
|Section 24: Access 2013 Advanced: Introduction|
Pre-requisites and Basic Knowledge of Access 2013
Access 2013 Advanced Exercise Files
|Section 25: Access 2013 Advanced: Indexes|
Indexes and Introduction to the Movies DatabasePreview
|Section 26: Access 2013 Advanced: Datasheet View|
Basics in Working with Datasheet ViewPreview
Controlling the Display and Advanced Sorting and Filtering in Datasheet View
|Section 27: Access 2013 Advanced: Linking Access Databases|
Linking to Other Access Database Tables
|Section 28: Access 2013 Advanced: ODBC and SQL Server|
How to Install SQL Server Express
Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
|Section 29: Access 2013 Advanced: Splitting an Access Database|
Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
Consequences of the Split; Moving a Database; Adding a Trusted Location
|Section 30: Access 2013 Advanced: Multi-user Aspects|
Access Options relating to Multi-user Issues; Record Locking
|Section 31: Access 2013 Advanced: Macros|
Basics of Macros and Properties of Macro EditorPreview
Examples of Macros; Autoexec
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.