Access 2016 - Create a Query Report & Form - How to Make Queries Reports Forms in Microsoft Tutorial

This is a tutorial that shows the basics of creating Queries, Forms and Reports in Access. Obviously all 3 of these objects can't be covered in 10 minutes, but this video is meant to get you acquainted with what the objects are, how to insert them, and what they do. Let me know if you have any questions.

Here is a full list of tutorial videos available on my channel:

Windows 10:
Perform Basic Mouse Operations
Create Folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select Multiple Files and Folders
Download a File From a Website
Use File Explorer to Access OneDrive and Upload Student Data Files
Capture an Image of the Entire Screen
Explore the Control Panel and the Settings App
Personalize the Desktop
Modify Screen Brightness and Resolution
Explore the Control Panel and the Settings App
Personalize the Desktop
Adjust the Sound
Plan the Organization of Files and Folders
Run an App

Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format from Default Formatting
Table of Contents Tutorial
Format Paragraphs
Create a Custom Word Template
Preview and Print a Document
Change Document and Paragraph Layout
Use AutoComplete and AutoCorrect
Correct and Reorganize Text
Header and Footer Tutorial
Page Numbers Tutorial
Captions in Word
Review Document Headings in the Navigation Pane
Reorganize Document Text Using the Navigation Pane
Collapse and Expand Body Text in a Document
Use Continuous Section Breaks for Page Layout
Insert Page Numbers Starting from a Specific Page

Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep - Basic Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The VLookup Function
The MIN or MINIMUM Function
Histogram Charts
Use the Sum Button to Sum a Range of Cells
Enter Formulas Using the Keyboard
Format Cells with Merge & Center, Cell Styles, and Themes
Chart Data to Create a Column Chart & Insert Sparklines
Select Cells and Ranges
Use CountIF and IF Functions and Apply Conditional Formatting
Use Date &Time Functions and Freeze Panes
Use Goal Seek to Perform What-if Analysis
Add Fill Colors and a Background Image
Insert Functions from the Formula Library
Use the PMT Function to Calculate a Loan Payment

Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
The Primary Key
Import Excel Spreadsheet into Access
Create a Table in Design View
Modify the Structure of a Table
Create a Subform
MOS Prep - Basic Certification Exam Practice Study Guide
Add Existing Fields to a Form
Create a Query, Form, and Report

PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists
Customize Slide Backgrounds and Themes
Animate a Slide Show
Apply a Theme Used in Another Presentation
Search for and Download an Online Theme
Microsoft Office Specialist Exam Certification
Print and View a Presentation
Lighten Background Images in Microsoft Office

Outlook 2016
Basic Tutorial

Office 2016:
Identify the Components of the Microsoft Office Ribbon

Computer Fundamentals:
Computer Case Types - Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive - Creating Uploading Downloading and Syncing
Explain the Importance of File Management
Troubleshoot Common Computer Problems

Job Search Skills:
Values, Attitude, and Goals
Top 5 Job Search Websites
Prepare For Your Interview
Negotiating Your Salary
7 Steps of Goal Setting
Resume Writing - Final Draft

Video Requests:
Download GMetrix Test Preparation Software

Remember, the goal of my channel is for you to learn. You can request a video at any time in the comment section, and I will make the video for you. I will make tutorials and simulations and demos for whatever you'd like to learn in our class. So, I encourage you to make a request. I also YouTube Live Stream once a week to answer your questions!

Instructor A Morgan

[khaya]

literally one day before my test, this saved my life i tell ya

[hrithvikappaiah]

This is very helpful thank you for saving me from my exam

[TinaxVale]

In less then 10 minutes you explained more then 10 hours of video course!!!! great!!!!

[sabrinasamreen]

yeah i was sleeping throughout the whole course and just 2 days before the exam God blessed me with this video. bro this was amazing on a whole new level. thanksss :))

[cosmin]

Thank you very much, Adam! This was the most useful video I've ever seen regarding Basic Access aspects. Straight to the point unlike other 2-hour tutorials and very well-explained. Keep up the good work, mate!

[ricsellang]

Thanks!! this type of teaching really feels better than reading text and trying to figure out some black and white blurred picture of instructions! much appreciated!

[caraid]

This dude is the best, thank you for saving me before the assignments due

[vaughanbogran]

Just stumbling upon these videos and wow !!! They are detailed enough to get the info across but short enough to where I don't loose interest. VERY GOOD !! Keep it up !!!

[snoopy]

Thank you so much for this great video Professor Morgan. I just randomly found this video. You did a fantastic job of explaining everything and making Access feel much more welcoming and intuitive. Thanks again.

[kmunson]

This video was awesome. It was awesome because there wan't a lot of extra bologna like most other Access tutorials videos have. Thanks for posting!

[josephmanoj]

I gotta admit. I have never seen your channel before but I knew you deserved that subscribe button. Also tmrw is my exam. Guess I joined the studying 1 day before exam crew.

[lisacaravello]

This is very helpful! I asked my boss for Access because the survey analysis I need is a bit sophisticated for Excel but then got a little scared trying to learn it on my own. Thank you!!

[FresitaDM]

Prof Adam,
I want to thank you so much. Thanks to your videos I passed my Accounting Analytics class which includes to build the physical aspect of my REA data model on Access. This is a very hard class, but thank you to your videos I got an A on building my system successfully. I will recommend your videos to my friend who is talking the same class next semester.

[GoniSiromare-olce]

very precise information, short, sharp and straight to the point. I love it. thank you for sharing this !

[teefit]

i passed my exam becuase of you.. you legendary beast

[HamzaMohamed-xjtz]

The second you said let's get started at 0:09.... I just gave a straight sub and like 👏🏽👏🏽👏🏽👏🏽 my man

[LT-strf]

Wow!! Your 9 min video really wraps up a 3 hour lecture in my accounting info system class. Thanks so much for the video professor!

[lavinmohammad]

I’m here because of a test tomorrow (which I will Ace)! My lecture is nothing compared to this Prof. So effortlessly explained.

[OS-qdwo]

WHO TF? would give this video a thumbs down. Thanks this is got to be one of the best Access Database videos I've seen it's simple and to the point and I can't thank you enough for that 🙏🙏

[bloodhound]

I was having a hard time understanding these concepts but they way you explained them helped immensely, thank you!