Access 2016 - Subform Tutorial - How To Create Subforms in Microsoft Office 365 - Add Form and Forms

In this Microsoft Office 2016 Tutorial, I show you the basics of how to create or add a subform to your Access Database. Keep in mind that this demo is meant for beginners, and I tried to keep the layout as simple as possible. I had a relationship created between the VendorID fields on the table. This Office 365 tutorial on Windows 10 shows you the basics of creating a form and a sub form based off of a few fields. It was created as an example for beginners or for those of you who are trying to pas the MOS certification test, as it is on the exam.

My goal is to provide you with the best learning experience possible, for all beginners of technology. Please see a list of topics below that my various playlists cover, and don't forget to like and subscribe!

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

Also, check out these other playlists to improve your Office 365 and Job Search Skills

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

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

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

PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists

Outlook 2016
Basic Tutorial

YouTube Analytics:
100 Subscribers
200 Subscribers

Job Search Skills:
Values, Attitude, and Goals
Top 5 Job Search Websites

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

[dileepsaisharan]

You Sir, A LEGEND! You saved me because I had to make a very large sub-form for my project and this helped me a ton, many thanks!

[virginiaharlow]

Excellent! You’ve no idea how I’ve struggled on my own! Thanks so much!

[herseem]

Outstanding demo. Staggering how quick it is

[TireSpare]

thank you it did help me alot with understanding how to create a subform in a form. i was struggling to solve this issue from pre exam stuff in Korean language

[KaI]

I'm going to pass my exam with your database of all videos

[mr]

Hi Adam, after selecting the fields I want on the form, I don't get the same prompt as your tutorial. Instead I get the prompt that says "What layout would you like for your form?" and my options are "Columnar, Tabular, Datasheet, Justified". None of which I want and no mention of subform. I am using Access 2016 on Windows 10. Any suggestions?

[satyabanukil]

Sir I watch your tutorials regularly. I have a question. In passing a data from or to perform calculation between parent and subform I use the following syntax
On the subform field: FieldName=
Forms!Table1!Field - Subform FieldName.
But I don't know what would be the syntax if I want to pass a value from one subform to another subform

[anilbagga]

Thanks Adams. That addresses the basics. I want to create a Order form where in the header I will have values from Customer Master and another table - the shipping master. In the detail section again I will fetch details form the item master for parts and enter quantity and values of exch items and will have some natural total value columns and Grand Total of the Order at the end of the details sheet. I have seen some videos on similar subjects but they are either without voice or too fast and difficult to follow. Can you help and create one. If it exists already, please share a link.

Please do also add some navigation tips from header to sub form, from one order to the other etc

[SteveMartinUSA]

This video is about how to use the form wizard, just barely enough to be dangerous. What happens beneath the surface...? Like what if you have to re-arrange the fields, or make changes to the subform? What if the master form already exists?

[curiosabouttech]

Thank you so much you I appreciate this.

[kenai]

When i click next it tells me "you have chosen fields from these tables one or more of these tables isn't related to the others. Click ok to edit system relationships" please help

[satyabanukil]

I have a single table. Therefore relationship not required. But I want to build two forms. The first one shows only personal details and second one details of the person included in the main form. Shall be grateful if any tutorial is presented on that. Regards.

[fadikronfli]

I want to use the IDNo variable as the key that links both tables. I want to create a trigger in the parent form to open the subform so that I can enter the necessary data (except the IDNo variable)

[fadikronfli]

Thanks Adam, I actually have one master form that I initially created to fill the basic table called 'staff'. and I want to create a sub-table called "dependents" using the IDNo variable

[bretthemson]

Hey Adam, gr8 video .. iam trying to build a simple purchase order form. i have my supplier table, product table, but cant seem to link them all together, , any help would be much appreciated

[mandyallen]

I have a form with a subform. Data selected from the subform does not show in the form until the form view is switched to layout view then back to form view or design view. Can you create a video that solutions this data display issue?

[hotwebs]

May i know if want to show the sequence number in the sub form base on number of item ID on each page, how to achieve that?

[jacquelinedarcey]

Hi Adam -
I am learning ACCESS for a research project related to the pandemic and your videos have made my life so much easier. While waiting for IRB review I have developed our DB. Multiple providers will be inputting data. I have one DB with multiple tables and 3 forms (to keep it easy on the eyes). I just need the studyID# to go from one table to the next so it doesn't need to be inputted each time (higher margin for error). I have tried lots of things but can't get it to work so that the studyID# is automatically popping up when they use the command button to go to the next form. I am sure it is way easier than I have made it. Can you help? Thank you so much! Best, JD

[zoeygreene]

Hi Professor Morgan, thank you for your videos. they are extremely helpful. i have a table 1 with fields like: po_no, receiver_id, received_date, received_qty, table 1 is a query linked to a database; i need to add a new field say filed A for data input in Access form. So i created table 2 with all fields linked to table 1. is there a way that when i linked table 2 field po_id to table 1, the rest of the field from table 1 will auto populated in table 2. this way, the operator does not need to look up the rest of the field. thank you Zoey

[alicepobudova]

Your videos have helped me a lot, thank you! I want to create some sort of training database, would this sub form work for that? I would want to also create a report from it. But not using two existing tables like you did, I would need to have a table for data entry to continue adding to this form. I would need to add new documents and new employees. Any ideas are greatly appreciated!