Introduction to Microsoft Access: A Database Management Tool

Discover how to create and manage tables, queries, forms, and reports. Analyze and visualize your data

4.33 (3 reviews)
Udemy
platform
English
language
Online Education
category
instructor
Introduction to Microsoft Access: A Database Management Tool
7
students
2.5 hours
content
Aug 2022
last update
$19.99
regular price

What you will learn

Create a new database and design tables with appropriate fields and data types

Use select queries to interogate table data by selection or date range. Add basic calculations

Create a data input form to manage large data sets

Produce dynamic reports to generate management information automatically

Understand the purpose and benefits of using a relational database system

Create and customize reports to present data in a professional format

Apply basic formatting and design principles to enhance the appearance and usability of your database

Why take this course?

The main goals for an Access beginners course are to introduce the basic concepts and features of Microsoft Access, to teach the skills needed to create and manage a database, and to provide practical examples and exercises that demonstrate how to use Access effectively. By the end of the course, you should be able to:


- Understand the purpose and benefits of using a relational database system

- Navigate the Access interface and use common tools and commands

- Create a new database and design tables with appropriate fields and data types

- Establish relationships between tables and enforce referential integrity

- Enter, edit, and delete data in tables and forms

- Use queries to filter, sort, and summarize data

- Create and customize reports to present data in a professional format

- Apply basic formatting and design principles to enhance the appearance and usability of your database.


The course content is as follows:

Understand The Database Window

Database Objects - Tables - Queries - Forms - Report - Macro

Database Terminology -fields - records - data set

Creating a Database

Basic Tables and Table design, data types, data formatting and field rules

Using Queries and design your own. Select queries

Using the Auto Form Feature

Form Design -starting from a blank form. Add a table to a form and manipulate the fields

Using the Auto Report Feature

Report Design, create your own report, move and resize fields and labels.

Copying Data

Freezing Columns

Printing Tables

Printing Reports

Sorting Records

Using the Filter Sorts and advanced filters

Renaming Columns

Using the Chart Wizard

Importing data from Excel

Linking to Excel Data

After this course you will a good understanding of the basic concepts used in a Microsoft Access database.

Screenshots

Introduction to Microsoft Access: A Database Management Tool - Screenshot_01Introduction to Microsoft Access: A Database Management Tool - Screenshot_02Introduction to Microsoft Access: A Database Management Tool - Screenshot_03Introduction to Microsoft Access: A Database Management Tool - Screenshot_04

Charts

Price

Introduction to Microsoft Access: A Database Management Tool - Price chart

Rating

Introduction to Microsoft Access: A Database Management Tool - Ratings chart

Enrollment distribution

Introduction to Microsoft Access: A Database Management Tool - Distribution chart

Related Topics

3216155
udemy ID
6/8/2020
course created date
10/23/2020
course indexed date
Bot
course submited by