MicroSoft Access Database Queries for Beginners

MicroSoft Access Database queries are used to retrieve specific records and trends from your data.

3.58 (6 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
MicroSoft Access Database Queries for Beginners
1,005
students
2.5 hours
content
Jan 2023
last update
$19.99
regular price

What you will learn

Retrieve data from a database by using MicroSoft Access Queries

Learn about MicroSoft Access unique Primary Keys and Auto-Numbers

Copy or Import Data from MS Excel to MicroSoft Access

Create user interfaces and menus with MicroSoft Access Forms

Parameter Queries with MicroSoft Access

Description

This MicroSoft Access Course is designed to introduce you quickly and easily to the most powerful aspects of MicroSoft Access.


This, (the most powerful aspects of MicroSoft Access), is the ease with which you can draft powerful MS Access Database Queries to access data subsets contained in your large data tables. Queries are used to retrieve and find specific records and trends from your MicroSoft Access data tables.

MicroSoft Access provides a graphical user interface, so that you can drag and drop to create a query.

It also draws an ERD (Entity Relationship Diagram) of your tables, so that you get a visual idea of how tables inter-relate. This is a tremendous help when it comes to creating new queries.


You will also learn how to import data from Excel or other datasets. You will learn about primary keys and auto-numbers.


MicroSoft Access is excellent for small business who would like to easily manage their data. Also, it is excellent for large corporates with big data to allow all users companywide to retrieve data without in-depth SQL development skills.


MicroSoft Access will also help new data-analysts to understand data terminology and concepts, to enter the data industry with ease.


Being a MicroSoft product, most likely, you are already paying for it, with your MicroSoft licence. Why not use it?

We hope that you will enjoy learning new Access Database skills.


Content

Introduction

Introduction to the MS Access Course

Section 2: Starting out with Access

Introduction to your data
Lecture 1: Create a new database in MS Access
Create a new table in MS Access
Import Data From Excel, using copy and paste
Import Data From Excel, and verify the data types
Import Data From Excel, let's do it all the data together
Get useful insights from your data, simply from the Home Ribbon!

Section 3: Access Query Basics

Create a Query
Access Housekeeping: Rename a table, Delete a table, Close a Query
MS Access Query Criteria: Filter a dataset using text values
Query Cretiria: Filter a dataset using number values
Query Crietiria: Filter a dataset using date values
Sort a query
Top value queries
Multiple Query Criteria in Access: Using OR
Multiple Query Criteria in Access: Using AND
Multiple Query Criteria in Access: Using AND and OR

Section 4: MS Access Expression Queries and Total Queries

MS Access Expression Queries
MS Access Totals Queries, Grouping records and using Aggregate Functions

Save a MS Access query for regular use

Save an MS Access Query

Section 5: Parameter Queries

What is a parameter query
Simple Parameter Query, Using Text Values
Parameter Query Using Number Values
Parameter Query Using Date Values

Section 6: All about Auto-Numbers

What is an Auto-Number in MS Access?
Create a table with Auto-Numbers
Re-using auto-numbers, once a number is deleted
Starting auto-numbers at any value but 1
Create a table an importing and using an existing series of auto-numbers
Copy And Paste Excel Data, maintaining the incoming Auto_Numbers
Use an Apped query to start Auto_numbers at something other than 1

Reviews

Aaron
August 1, 2023
The content is good, but the volume is hit or miss. One section I could hear and all the rest have been so quiet it is hard to hear it. I do have all my volume adjusted as loud as it can go on the course, on my computer, and on my speakers.

Coupons

DateDiscountStatus
1/19/2023100% OFF
expired

Charts

Price

MicroSoft Access Database Queries for Beginners - Price chart

Rating

MicroSoft Access Database Queries for Beginners - Ratings chart

Enrollment distribution

MicroSoft Access Database Queries for Beginners - Distribution chart
4845318
udemy ID
8/22/2022
course created date
1/19/2023
course indexed date
Bot
course submited by