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 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 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:

  • 4.5 hours on-demand video
  • 1 article
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development Database Design

Managing Your Data with Microsoft Access

A Step-By-Step Guide to Building a Database Application with Microsoft Access
Rating: 4.9 out of 54.9 (4 ratings)
12 students
Created by Andrew Comeau
Last updated 5/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Design of data entry applications with Microsoft Access including table design, entry forms and printed reports.
  • General database design principles including organization of data (normalization) and correct use of data types.
  • Design of user-friendly data entry forms for quick and accurate entry of data.
  • Access query and report design for presentation of collected data.

Course content

3 sections • 24 lectures • 4h 42m total length

  • Preview05:42
  • Preview02:50
  • Preview06:59
  • What Should Access Be Used For?
    05:33
  • What is a Relational Database?: Examining the Tables in Depth
    06:11

  • Building Your Own App: The Collier Public Library Database
    00:54
  • Creating the Database File
    08:39
  • Data Modeling in Microsoft Access
    08:28
  • Microsoft Access Data Types
    05:25
  • Creating the First Table: Books
    26:45
  • Creating the Customers Table
    06:33
  • Linking the Tables
    09:58
  • Importing Data Into Microsoft Access
    19:40
  • Creating the Author's Table
    12:07
  • Introduction to Form Design in Access
    11:36
  • Working with Form Controls
    12:49
  • Introduction to Report Design
    05:45
  • Creating the Overdue Items Report
    22:47
  • Creating Labels in Microsoft Access
    10:40
  • Preview18:24
  • Preview13:03

  • Preview29:45
  • Referential Integrity in Microsoft Access
    17:37
  • Generating Random Test Data with Mockaroo.com
    14:14

Requirements

  • Basic Microsoft Office Skills, especially Microsoft Excel.
  • Basic Windows skills, ability to save, find and copy files.

Description

A common complaint about Microsoft Access is that it's simply too complicated for many people to work with on their own. The reason for this is that Access is designed for building database applications that can be used to automate and manage processes. Too few resources approach it from that perspective. This leaves users and students without the understanding they need to effectively use the software.

Managing Your Data with Microsoft Access demonstrates from start to finish how to organize your data and build an application that will enable you to manage it as needed.  This course will show you the clear and logical steps involved in modeling your data, designing tables around it and then creating forms and reports based on it.

During this course, you will be able to see and follow along with the design of the Collier Public Library Database, a database application used to manage a fictional lending library. This application will include multiple tables, forms and reports intended to manage the processes involved in a library including  checkouts and customer registration.  The Job Search Plus application also serves as an example of a finished, distribution-ready application and what can be accomplished with Access.

Managing Your Data with Microsoft Access also includes previously published bonus content demonstrating specific tasks and concepts related to working with Access. This content will help you gain an additional perspective on some of the things that are possible with Microsoft's premier database software.


Who this course is for:

  • Business users looking for ways to better manage data
  • Students trying to understand Microsoft Access

Instructor

Andrew Comeau
Programmer and Technology Author
Andrew Comeau
  • 4.9 Instructor Rating
  • 4 Reviews
  • 12 Students
  • 1 Course

My experience includes the development of Windows applications, online tools and database solutions with technologies including SQL Server, .NET and Microsoft Access. I am Microsoft certified in database design and software development and have provided solutions for areas including manufacturing, laboratory testing, employee training and pharmacy operations.

I develop online and print content in order to share technical knowledge with a wider audience. These have included multiple websites and my 2015 book, "MySQL Explained: A Step-By-Step Guide to Database Design".  I've previously taught computer programming at the college level and currently organize the Ocala I.T. Professionals, an I.T. networking group in Ocala, Florida.

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