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 CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop 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 WordPress Node.Js 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 Data Science
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:

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

Microsoft Office Access 2013: Basic

Microsoft Office Access 2013: Basic
Rating: 3.1 out of 53.1 (2 ratings)
5 students
Created by Integrity Training
Last updated 11/2018
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn how to use Access 2013 to manage your data
  • Create a new database
  • Construct tables
  • Design forms and reports
  • Create queries
  • Generate reports
  • Join, filter, and sort data

Requirements

  • The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or Microsoft Office 2010 especially Microsoft Office Access.
  • In addition to that, a good knowledge of getting around with Microsoft Windows 10 is required as well.
  • The course is offered as part of the three course series and it is recommended that the candidates must enroll in the courses in sequence.

Description

The Microsoft Office Access 2013: Basic course helps the individuals and their organizations to collect and manage large amounts of data. Microsoft Office Access 2013: Basic course allows the candidates to use Microsoft Office Access 2013 as a personal data management tool, or to develop applications for a department or an entire organization. The course focuses on the Access 2013 to manage the data by creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. It also enables a smooth migration from older versions of Microsoft Office Access.   

Microsoft Office is critical to the day to day operations of any organization. This course is specifically focused on the Microsoft Office Access 2013 that is an essential data management tool used by many organizations. The complete course series offers comprehensive knowledge along with the tips and tricks to make full use of the new features in Microsoft Office Access 2013.

Who this course is for:

  • Individuals looking to update their skill-set to Microsoft Office Access 2013
  • Data entry operators
  • Writers and publishers
  • Candidates seeking to move to the latest version of Microsoft Office Access

Course content

7 sections • 125 lectures • 3h 48m total length

  • Preview01:17
  • Preview00:45

  • Preview00:21
  • Preview00:40
  • Preview02:03
  • Preview01:04
  • Preview01:50
  • Preview01:00
  • Preview05:38
  • Access 2013 Window Components
    01:30
  • Demo 1-3: Navigating and Editing Data in Tables
    08:21
  • Forms and Views
    01:07
  • Record Navigation Bar
    01:12
  • Demo 1-4: Navigating and Editing Data in a Form
    04:06
  • The Capable Query
    01:19
  • A Query Join
    01:47
  • Demo 1-5: Using Queries
    06:03
  • Demo 1-6: Using Reports
    02:43
  • Demo 1-7: Exploring Access Ribbon Commands
    05:18
  • Topic B: Create a Simple Access Database
    00:25
  • Create a Simple Access Database
    00:27
  • Create a Simple Access Database (cont.)
    01:22
  • Saving Options
    00:37
  • Initial Views
    Processing..
  • Field Data Types
    02:24
  • Field Data Types (cont.)
    01:36
  • Primary Key
    01:08
  • Object Names
    02:33
  • Demo 1-8: Creating a New Database
    10:11
  • Demo 1-9: Creating and Testing a Form
    05:55
  • Topic C: Get Help in Microsoft Access
    00:06
  • Access Help Window
    01:09
  • Demo 1-10: Getting Help in Access
    03:13
  • Lesson 01 Review
    00:20
  • Review - Question
    5 questions

  • Working with Table Data
    00:14
  • Topic A: Modify Table Data
    00:11
  • Modify Table Data
    01:00
  • Demo 2-1: Undoing Record Modifications
    03:34
  • Quick Search
    00:23
  • Demo 2 -2: Using Quick Search to Find and Modify Records
    01:53
  • Demo 2 -3: Using Find and Replace to Modify Records
    03:20
  • Adding Calculations to the Totals Row
    00:49
  • Demo 2 -4: Adding a Totals Row to a Datasheet
    02:14
  • Topic B: Sort and Filter Records
    00:20
  • Records in Ascending Order by Dept
    00:35
  • Filtering Records
    01:07
  • Demo 2 -5: Sorting and Filtering Records
    04:14
  • Topic C: Create Lookups
    00:11
  • Table Relationship
    01:31
  • The Relationships View
    00:43
  • Foreign Keys
    00:48
  • Referential Integrity
    00:33
  • Demo 2 -6: Examining the Purpose of a Primary Key
    02:34
  • The Property Sheet
    01:02
  • Demo 2 -7: Configuring a Form Lookup Field
    07:44
  • Lesson 02 Review
    00:14
  • Review - Question
    5 questions

  • Querying a Database
    00:16
  • Topic A: Join Data from Different Tables in a Query
    00:18
  • Query Object Views
    00:45
  • Simple Query Wizard
    00:40
  • Types of Queries
    00:54
  • Demo 3 -1: Creating a Query by Using the Query Wizard
    04:30
  • Using Query Design to Create a Query
    02:11
  • Types of Queries
    00:33
  • Demo 3 -2: Creating a Query by Using Query Design
    04:20
  • Topic B: Sort and Filter Data in a Query
    00:16
  • Query Criteria
    01:31
  • A Comparison Operator
    00:42
  • Logical Operators
    00:34
  • Wildcards
    02:32
  • Like Operator Examples
    01:31
  • Demo 3 -3: Filtering a Query Using a Comparison Operator
    03:08
  • Demo 3 -4: Filtering a Query Using a Wildcard
    03:17
  • Zoom Dialog Box
    01:06
  • Demo 3 -5: Filtering a Query Using a Date Range
    04:23
  • Topic C: Perform Calculations in a Query
    00:06
  • Calculations in a Query
    00:55
  • Demo 3 -6: Performing Calculations
    09:55
  • Lesson 03 Review
    00:19
  • Review - Question
    5 questions

  • Creating Advanced Queries
    00:16
  • Topic A: Create Parameter Queries
    00:10
  • Create Parameter Queries
    00:57
  • Matching a Parameter Query
    01:17
  • Using the Ampersand Operator
    01:05
  • Demo 4 -1: Creating a Parameter Query
    03:40
  • Demo 4 -2: Using Wildcards in a Parameter Query
    02:08
  • Demo 4-3: Creating a Query with Multiple Parameters
    01:43
  • A Parameter Query Displays a Prompt
    00:20
  • Topic B: Create Action Queries
    00:12
  • Action Queries
    01:13
  • Action Query Update Expression
    00:47
  • Demo 4-4: Creating Action Queries
    06:06
  • Topic C: Create Unmatched and Duplicate Queries
    00:17
  • Find Unmatched and Find Duplicate Queries
    01:01
  • Demo 4-5: Creating Queries to Search for Unmatched and Duplicate Records
    04:36
  • Topic D: Summarize Data
    00:09
  • Crosstab Queries & Display Details
    00:25
  • Analyzing Country of Origin
    01:56
  • Demo 4-6: Creating a Crosstab Query
    06:24
  • Lesson 04 Review
    00:15
  • Review - Question
    5 questions

  • Generating Reports
    00:18
  • Topic A: Create a Report
    00:12
  • Report Creation Tools
    01:26
  • Report Object Views
    00:37
  • The Report Wizard
    00:29
  • Demo 5-1: Creating Reports
    03:30
  • Demo 5-2: Using the Report Wizard
    03:38
  • Topic B: Add Controls to a Report
    00:11
  • Sections in a Report
    01:41
  • The Completed Report
    00:44
  • Demo 5-3: Adjusting Report Control Layout
    05:42
  • Topic C: Enhance the Appearance of a Report
    00:14
  • Galleries and Themes
    00:53
  • Demo 5-4: Enhancing the Appearance of a Report
    04:11
  • Topic D: Prepare a Report for Print
    00:09
  • Page Setup Options
    00:35
  • Print Preview Tab
    00:34
  • Demo 5-5: Preparing a Report for Print
    01:58
  • Lesson 05 Review
    00:25
  • Review - Question
    5 questions

  • Customizing the Access Environment
    00:09
  • Topic A: The Access Options Dialog Box
    00:13
  • Access Options
    01:28
  • Demo 6-1: Setting Access Options
    04:01
  • Lesson 06 Review
    00:06
  • Course Closure
    00:48
  • Review - Question
    5 questions

Instructor

Integrity Training
Certification Trainers for Over 20 Years
Integrity Training
  • 4.2 Instructor Rating
  • 9,169 Reviews
  • 74,821 Students
  • 146 Courses

Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. 

  • 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.