Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 2.5 hours on-demand video
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Microsoft Access

Microsoft Office Access 2016: Part 1 (Beginner)

Learn the basics of building an Access database. Learn step-by-step how to create tables, queries, forms and reports.
Rating: 4.0 out of 54.0 (32 ratings)
332 students
Created by SONIC Performance Support - E-Learning Experts
Last updated 5/2019
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Requirements

  • Just basic computer skills.

Description

A relational database application such as Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Who this course is for:

  • This course is designed for you, if you wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Course content

6 sections • 42 lectures • 2h 26m total length

  • Preview03:04
  • Orientation to Access
    04:28
  • Preview02:20
  • Navigate Tables
    03:56
  • Navigate and Edit Data in Forms
    02:05
  • Relational Databases
    03:42
  • Use Queries - Introduction
    01:32
  • Use Queries
    01:50
  • Use Reports
    02:28
  • Create a New Database
    06:56
  • Get Help
    05:12
  • Configure Options in Access
    06:03
  • Microsoft Access 2016 Part 1 Quiz 1
    3 questions

  • Preview00:57
  • Record Modifications
    02:45
  • Use Quick Search to Find and Modify Records
    02:30
  • Use Find and Replace to Modify Records
    03:05
  • Ask Questions to a Table - Introduction
    00:34
  • Add a Totals Row to a Datasheet
    01:55
  • Sort and Filter Records
    04:27
  • Microsoft Access 2016 Part 1 Quiz 2
    2 questions

  • Preview01:25
  • Create a Query by Using the Query Wizard
    03:41
  • Create a Query by Using Query Design
    03:28
  • Filter a Query Using a Comparison Operator
    03:05
  • Filter a Query by Using a Wildcard
    04:03
  • Filter a Query by Using a Date Range
    03:00
  • Sort Records in a Query
    01:53
  • Preview03:05
  • Microsoft Access 2016 Part 1 Quiz 3
    3 questions

  • Preview01:09
  • Create and Test a Form
    04:29
  • View and Change Data in a Form
    04:35
  • Preview01:02
  • Set Form Properties
    03:40
  • Configure a Form Lookup Field
    06:36
  • Microsoft Access 2016 Part 1 Quiz 4
    2 questions

  • Preview01:59
  • Preview02:47
  • Use the Report Wizard
    03:30
  • Adjust the Report Control Layout
    07:53
  • Enhance the Appearance of a Report
    03:29
  • Prepare a Report for Print
    02:20
  • Report Modifications
    06:51
  • Format a Report
    10:23
  • Microsoft Access 2016 Part 1 Quiz 5
    6 questions

  • Bonus Lecture
    02:10

Instructor

SONIC Performance Support - E-Learning Experts
Training Company
SONIC Performance Support - E-Learning Experts
  • 4.3 Instructor Rating
  • 4,185 Reviews
  • 26,462 Students
  • 72 Courses

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.