Managing Your Data with Microsoft Access

Managing Your Data with Microsoft Access, available at $19.99, has an average rating of 4.67, with 27 lectures, based on 6 reviews, and has 31 subscribers.

You will learn about 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. This course is ideal for individuals who are Business users looking for ways to better manage data or Students trying to understand Microsoft Access It is particularly useful for Business users looking for ways to better manage data or Students trying to understand Microsoft Access.

Enroll now: Managing Your Data with Microsoft Access

Summary

Title: Managing Your Data with Microsoft Access

Price: $19.99

Average Rating: 4.67

Number of Lectures: 27

Number of Published Lectures: 27

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Downloading the Demo Database: Job Search Plus

Lecture 3: What is Microsoft Access?

Lecture 4: What Should Access Be Used For?

Lecture 5: What is a Relational Database?: Examining the Tables in Depth

Chapter 2: Creating The Collier Public Library Application

Lecture 1: Building Your Own App: The Collier Public Library Database

Lecture 2: Creating the Database File

Lecture 3: Data Modeling in Microsoft Access

Lecture 4: Microsoft Access Data Types

Lecture 5: Creating the First Table: Books

Lecture 6: Creating the Customers Table

Lecture 7: Linking the Tables

Lecture 8: Importing Data Into Microsoft Access

Lecture 9: Creating the Author's Table

Lecture 10: Introduction to Form Design in Access

Lecture 11: Working with Form Controls

Lecture 12: Using Subforms in Microsoft Access

Lecture 13: Introduction to Report Design

Lecture 14: Creating the Overdue Items Report

Lecture 15: Report Settings in Microsoft Access

Lecture 16: Creating Labels in Microsoft Access

Lecture 17: Printing to a Dymo Label Printer from Access

Lecture 18: Creating a Switchboard Menu

Lecture 19: Splitting an Access Database

Chapter 3: Bonus Materials

Lecture 1: Basic Programming with Microsoft Access

Lecture 2: Referential Integrity in Microsoft Access

Lecture 3: Generating Random Test Data with Mockaroo.com

Instructors

Andrew Comeau
Programmer and Technology Author

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 1 votes
5 stars: 4 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!

Menu