Access 2016 - Form Fields - How To Add An Existing Field In Your Forms - Layout View and Form Wizard

In this Microsoft Access 2016 Tutorial, I show you how to add existing fields to a form. Sometimes you forget to add a field, or you need to edit your form after it's been created. This tutorial is intended for beginners who want to learn more about the Office Database program on Windows 10. Understanding how to adjust your layout to a different view and change your form labels is very important for a questions on the MOS (Microsoft Office Specialist Exam) so make sure that you study this topic before taking your test, it will help you pass.

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
Explain the Importance of File Management
Troubleshoot Common Computer Problems

Windows 10:
Perform Basic Mouse Operations
Create Folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select Multiple Files and Folders

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

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

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

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

Outlook 2016
Basic Tutorial

YouTube Analytics:
100 Subscribers
200 Subscribers
300 Subscribers

Job Search Skills:
Values, Attitude, and Goals
Top 5 Job Search Websites
Prepare For Your Interview
Negotiating Your Salary

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

[shaileshtrivedi]

This video was quite clear regarding my issue and with example, made may understanding clear. I will try and will work.

[juliawang]

Thank you very much!! You demonstrated this topic very clearly, I'm taking the test this Friday, this helps me a lot! Thank you!

[archanaaa]

Nice video.. What are the major skills to learn in MS access for beginners must knw.. Plse guide sir..

[Alexx]

Thank you Professor Adam!!!! you save my day with this tip.

[ballparkmom]

This is helpful! I have a database with multiple tables and need to add another field from a different table than originally used. Can you show us an example of adding a field to an existing form from a separate table?

[devenderrohilla]

Thanks, In my case I want to open another form in existing form conditionally, if possible please elaborate on that.

[sharathkoshy]

Hi Adam could you please make a video of how to make labels, text boxes, and a combo boxes.

[kinumbedavidministries]

This tutorials are just amazing, I am all interest in DATA management.
I have an access DATA base and an entry form but i would like to know how i can add a button that will bring an additional field that will be used to add information as an update information to a client records if needed, after that how will i do to hide all other view mode and only allow the DATA entrant to access the entry form only using a password. thanks

[myrtle_glo]

Thank you so much! This is helpful. :)

[timkirk]

Hey so I solved an issue I had that your video led me to - I was looking for a field that wasn't showing up in the field list . I just found the "show all tables" button at the top of the field list - this shows you all of the fields of all (related?) tables in case you can't find something!

[vincetroia]

Hello Adam. Thanks for all of the videos. You are an excellent teacher. I have a question in regards to Access 2016. I created a split form. After the form was created, I realized I needed to add a few more fields to the table. Once this was complete, I edited the split form (top) section and added these new fields. That was the easy part. My question is, how to I add those new fields to the datasheet (bottom) section? Please help.

[shawnalexander]

I use the contacts database and they have field that is called OPEN. I wanted to make my own database and was wondering if u could tell me how to insert that field? I tried to add that field but was not able to find it.

[lpmwalker_of_sky]

Thank you for the video, but what if the field is not in a the “add field list.” How do you add a completely new field?

[jimdavidbarnard]

I am working on lists to which tables refer. I am trying to develop the relationship between a field called "type" in table #1 to another table #2 which also has a field called "type". when I view the table #1 in relationship view, the field table "type has a -sign to the left of the "type" and and indented "type" below it. How do I get rid of the indented "type" so I am working with "type" to connect the relationship line between types in both table #1 and table #2?

[poppinpinkchampagne]

Hi I’m trying to add a field into the tables before I can add into the form but I don’t have the “click to add” tab... is that because I have too many fields already?

[jamesdubroy]

Excellent tutorial. Is it possible to modify an Access 2016 template form, if so, how so, please?

[akashpatel]

Hello,
If an action queries appear in the list box control, how can I remove it so it is no longer displayed in the list box and as well as not in the database? Thank you!!

[jette]

Hi Adam, is there a way to add multiple rows on the text form fields? If none, what other similar functionality can i use? and also do you have a tutorial on that in MS Word 2016?

[khrisscottpeterson]

What will I do if the added field goes on the top list? It didn't stacked to where I want it to be. Is there a way to correct that?

[alysiahenson]

When you add a field can you add it in to a text box with other information?