Master Microsoft Access 2013 & 2016 for Beginners
Master Microsoft Access 2013 & 2016 for Beginners, available at $19.99, has an average rating of 4.2, with 178 lectures, based on 95 reviews, and has 606 subscribers.
You will learn about Using touch devices Sorting information and running queries Safeguards and restrictions Creating tables and relationships Navigating the Access 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 Practice what you learned with included exercise files Sorting information and running queries Learn valuable new skills for complex data projects at work Supercharge your database projects Discover how to into import data from Excel Learn Queries, use validations, how to create and print reports How to compact, repair and backup your database How to create a linked table Discover how to use the Query Wizard Learn to use Model Dialog and Macros This course is ideal for individuals who are Anyone new to Microsoft Access or Users new to Microsoft Access 2013 or 2016 and those upgrading from previous software versions or Anyone new to the data management role or Anyone who wants to learn data management and Microsoft Access It is particularly useful for Anyone new to Microsoft Access or Users new to Microsoft Access 2013 or 2016 and those upgrading from previous software versions or Anyone new to the data management role or Anyone who wants to learn data management and Microsoft Access.
Enroll now: Master Microsoft Access 2013 & 2016 for Beginners
Summary
Title: Master Microsoft Access 2013 & 2016 for Beginners
Price: $19.99
Average Rating: 4.2
Number of Lectures: 178
Number of Published Lectures: 175
Number of Curriculum Items: 178
Number of Published Curriculum Objects: 175
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- Using touch devices
- Sorting information and running queries
- Safeguards and restrictions
- Creating tables and relationships
- Navigating the Access 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
- Practice what you learned with included exercise files
- Sorting information and running queries
- Learn valuable new skills for complex data projects at work
- Supercharge your database projects
- Discover how to into import data from Excel
- Learn Queries, use validations, how to create and print reports
- How to compact, repair and backup your database
- How to create a linked table
- Discover how to use the Query Wizard
- Learn to use Model Dialog and Macros
Who Should Attend
- Anyone new to Microsoft Access
- Users new to Microsoft Access 2013 or 2016 and those upgrading from previous software versions
- Anyone new to the data management role
- Anyone who wants to learn data management and Microsoft Access
Target Audiences
- Anyone new to Microsoft Access
- Users new to Microsoft Access 2013 or 2016 and those upgrading from previous software versions
- Anyone new to the data management role
- Anyone who wants to learn data management and Microsoft Access
Become a super star Access 2013 & 2016 user everyone relies on with this big 29-hour course with 3 courses, over 160 video tutorials.
-
Starts from the very beginning
-
No Microsoft Access experience needed
-
3 courses for learning Microsoft Access
-
160+ expertly produced videos
-
A full 28 hours of instruction
-
Makes all aspects of Access easy to master
-
Covers exciting features new for 2013 & 2016
-
Learn to use full program, not just basics
-
Get up and running quickly
-
Immediately learn things you can use at work
-
Supercharge your personal projects
-
Become the MS Access expert everyone appreciates
-
Work at your own pace in your spare time
-
Practice what you learned with included exercise files
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 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 for the Access 2013 beginner and advanced courses
Through 96 lectures, 19 hours of quality content, this training 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.
Contents and Overview for the Access 2016 beginner course
Microsoft Access 2016 For Beginners starts at the very beginning show
you where to get your copy of MS Access and how to install it on your
computer. Before we go further, you get a quick tour of all the new
features and improvements in 2016.
You will learn how to easily get started with database templates that
make the entire process faster. Then you see how to create, save, and
open databases.
After a tour of Access Workspace and Backstage, you see a complete
explanation of the toolbars and ribbons. Next you get a strong grasp of
keyboard shortcuts that will greatly increase your speed and efficiency.
Now it’s time to create your own working database. Videos step you
through the process helping you master details while understanding the
big picture.
Later the course goes into importing data from Excel, creating and
working with forms, and lots of great information on sub-forms. As you
become more advanced, you learn Queries, using Validations, how to
create Reports, and Printing your projects.
This course contains a big 10 Chapters with multiple videos in each
chapter for a total of 70 videos. Get started with this course now to
easily become expert at MS Access 2016.
Here’s what our students are saying…
“As someone who has no experience I am finding this course very easy to understand and follow. Great pace and the modules don’t overwhelm you. So glad I purchased this.”
– Sharon Knight
“Highly recommended this course to everyone.This is the best course i ever had.Good English that we can understand. Suberb…..I understood every lesson in the course.
– Yunesh Garusinghe
“Outstanding course! I will use the as a reference for years to come. I am 100% satisfied.
– Larry Reid
Did you know?
Simon Sez IT teaches all sorts of software, including:
– Microsoft Excel
– Microsoft PowerPoint
– Microsoft Word
– Microsoft Project
– Microsoft Outlook
– QuickBooks
– Photoshop Elements
– Web Development Languages
– And so much more!
Just search “Simon Sez IT” to see our full list of individual courses and incredible value multi-course bundles on Udemy.
Course Curriculum
Chapter 1: Access 2013: Introduction
Lecture 1: Acquiring Access 2013; Course Overview
Lecture 2: WATCH ME: Essential Information for a Successful Training Experience
Lecture 3: DOWNLOAD ME: Access 2013 Exercise Files
Lecture 4: Downloadable Course Transcript
Lecture 5: Free Keyboard Shortcut Guides
Lecture 6: What's New in Access 2013
Chapter 2: Access 2013: Using Touch
Lecture 1: Using Touch
Chapter 3: Access 2013: Getting Started
Lecture 1: Database Templates; Creating, Opening and Saving Databases
Lecture 2: Workspace and Backstage View
Chapter 4: Access 2013: Help
Lecture 1: Online, Offline, and Contextual Help
Chapter 5: Access 2013: Keyboard Shortcuts and Key Tips
Lecture 1: Finding Keyboard Shortcuts and Key Tips
Chapter 6: Access 2013: Access Options
Lecture 1: Customizing the Settings and Use of Access 2013
Chapter 7: Access 2013: The Ribbon and Toolbars
Lecture 1: The Ribbon
Lecture 2: Quick Access Toolbar
Chapter 8: Access 2013: Status Bar
Lecture 1: Customizing the Status Bar
Chapter 9: Access 2013: Database Basics
Lecture 1: Overview of the Main Features of Access Database
Lecture 2: Web App Basics
Chapter 10: Access 2013: Tables
Lecture 1: Creating Tables – Part 1
Lecture 2: Creating Tables – Part 2
Lecture 3: Relationships Between Tables – Part 1
Lecture 4: Relationships Between Tables – Part 2
Chapter 11: Access 2013: Datasheet View
Lecture 1: Inserting and Formatting Fields; Field Validation; Navigation Buttons
Lecture 2: Sorting, Filtering and Finding Data
Lecture 3: Entering Data; Changing the Order of Columns, Field Width and Height
Chapter 12: Access 2013: Table Design
Lecture 1: Design View; Field Properties
Lecture 2: Saving Data; Data Types, Attachments and Field Size
Lecture 3: Input Masks; More on Field Properties
Chapter 13: Access 2013: Forms
Lecture 1: Creating Forms; Form Wizard
Lecture 2: Single Forms; Insert, Delete, Modify, Sort and Filter Records
Lecture 3: Layout View; Adding Existing Fields
Lecture 4: Design View; Arranging Fields
Lecture 5: Controls
Lecture 6: Form Design
Chapter 14: Access 2013: Queries
Lecture 1: Query Design
Lecture 2: Joins and Query Wizard
Lecture 3: Query Types
Lecture 4: Operators and Expressions – Part 1
Lecture 5: Operators and Expressions – Part 2
Lecture 6: Operators and Expressions – Part 3
Lecture 7: Subforms
Chapter 15: Access 2013: Reports
Lecture 1: Report Wizard; Previewing a Report
Lecture 2: Report Design
Lecture 3: Grouped and Summary Reports; Modifying a Report
Lecture 4: Adding Subreports
Chapter 16: Access 2013: Printing
Lecture 1: Documenter; Print Properties and Options
Chapter 17: Access 2013: Importing and Exporting Data
Lecture 1: Import and Append; Copy and Paste; Export Access Database
Chapter 18: Access 2013: Templates and Application Parts
Lecture 1: Database Templates and Application Parts
Chapter 19: Access 2013: More on Forms
Lecture 1: Navigation Form
Lecture 2: Modal Dialogs – Part 1
Lecture 3: Modal Dialogs – Part 2
Lecture 4: Modal Dialogs – Part 3
Chapter 20: Access 2013: Macros and VBA
Lecture 1: Actions; Example of VBA; Creating AutoExec Macro
Chapter 21: Access 2013: Additional Topics
Lecture 1: More Access Options
Lecture 2: Info Tab
Chapter 22: Access 2013: Security
Lecture 1: Trust Center
Chapter 23: Access 2013: Conclusion
Lecture 1: Updates; Closing
Chapter 24: Access 2013 Advanced: Introduction
Lecture 1: Pre-requisites and Basic Knowledge of Access 2013
Lecture 2: WATCH ME: Essential Information for a Successful Training Experience
Lecture 3: DOWNLOAD ME: Access 2013 Advanced Exercise Files
Chapter 25: Access 2013 Advanced: Indexes
Lecture 1: Course Review
Lecture 2: Indexes and Introduction to the Movies Database
Chapter 26: Access 2013 Advanced: Datasheet View
Lecture 1: Basics in Working with Datasheet View
Lecture 2: Controlling the Display and Advanced Sorting and Filtering in Datasheet View
Chapter 27: Access 2013 Advanced: Linking Access Databases
Lecture 1: Linking to Other Access Database Tables
Chapter 28: Access 2013 Advanced: ODBC and SQL Server
Lecture 1: How to Install SQL Server Express
Lecture 2: Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
Chapter 29: Access 2013 Advanced: Splitting an Access Database
Lecture 1: Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
Lecture 2: Consequences of the Split; Moving a Database; Adding a Trusted Location
Chapter 30: Access 2013 Advanced: Multi-user Aspects
Lecture 1: Access Options relating to Multi-user Issues; Record Locking
Chapter 31: Access 2013 Advanced: Macros
Instructors
-
Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 3 votes
- 3 stars: 17 votes
- 4 stars: 33 votes
- 5 stars: 40 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024