Access 2016 - Creating Forms - How to Use the Form Wizard in MS Microsoft Access Database Tutorial

This Access 2016 tutorial shows you how to create a form using the Form Wizard. Forms can be based off of tables or queries, and in this example I show you how to make a new form based off of selected fields from a Table. Enjoy!

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
Format Text
Undo and redo Commands or Actions
Modify a Style

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
Describe the Excel Worksheet
Enter Formulas Using Point Mode

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
How To Use the Property Sheet
Open and Save an Existing Database
Create Table Relationships
Learn Basic Database Concepts and Terms
Create and Use a Form to Add and Delete Records
Learn the Guidelines for Designing Databases and Setting Field Properties
Find, Modify, and Delete Records in a Table
Create a Form Using the Form Wizard

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
The Importance of Networking
Interviewing - What You Need To Know Before a Job Interview

Instructor A Morgan

[sterlingspots]

Thanks for making these videos. It has been years since I have worked in Access and your videos are a great way to dust off the cobwebs and get back up to speed.

[ethanpfx]

Simple, easy, straight to the point, tysm

[xiiscc-priyanshuroy]

U saved me in last minute...I have exams today...
I like ur videos....a lot...keep it up., !

[LakersNotFakers]

Thank you for really breaking it down for me, I am a beginner and this is made a lot of sense.

[shauryaiswk]

Thank you sir thank you so much. I can’t really explain how much this video has helped me. Tomorrow is my assignment and this was the kind of material which, I was looking for. Thank you sir thank you so much again.

[SOMEONE-qvrd]

My teacher used some of your video in class and im here to study from your videos for the quiz:)

[epibaleicolo]

Very specific details which is very helpful for me as a beginner

[abdullahasif]

My teacher Mr.David is a bad teacher. You are a great person because you helped me with my theest for tommorow. Thanks!

[yushao]

My access is exactly like yours. Normally you can choose "how do you want to view your form" after selecting all the fields to create a form with subform, but in your video you didn't even have that option, and neither do I! Do you know how to fix that? Thank you very much!

[kylejacobs]

I am not super proficient in access, but I was wondering if there is a way to create a dynamic query/report/form or anything that prompts for the fields you wish to summarize based on?

I have a query set up that pulls all of the data together into 1 query that I plan to pull from. What I am hoping to do is when the user runs the query(this user will likely have no access knowledge at all so user friendliness is key), that it give them the option to choose the fields they wish to add using a check box
[ ] Include Region
[ ] Include Sales Person
[ ] Include Sales Date
[ ] Include Customer Address
etc....
or a series of combo box's that list out each potential field and you can choose which ones you want that way.
Field 1 [Sales Person]
Field 2 [Sales Date]
Field 3 [ ]

I want them to be able to be able to build the data in any way they wish, using what ever fields they want at the time.

I have access 2013 if it makes a difference.

[RafaelBCastillo]

Good morning. How do I replace one of the records to a drop down menu? I want to be able to select from a drop down menu when entering the data into the form. I found the combo box but not sure how to integrate it.

[salmanagy]

I want to learn how to connect to tables with a special way like: I have a database for students and in the main table there is a field of the number of absence days, in the other table is like a calendar with the teachers if she marked on one day or added a link to the document it will automatically count one number more in the first main table under the field of absence and student's record . can you please help me in that ?

[marwaessam]

Can you make video about how to make buttons in access

[troya]

How do I create a form with a field that gets filled in as I fill in other fields in the form view. For instance..if there is a unique number that comprises first and last initial as well as date of birth...how can I make a field that automatically fills in as I fill in the required data? Thanks much