KnowledgeCity

Microsoft Access 2021: Forms

Learn how to create different types of forms and how to use them to create a database application in Microsoft Access 2021
Preview the first lesson free — get full access to all 7 lessons.

To view this video please enable JavaScript.

Course: On-Demand
Beginner  Provider John Varan  7 Lessons ·  34m  in Arabic, German, English, Spanish, French, Portuguese, Chinese Simplified 

Course Description

Forms are the user interface of a database application, the front end that every user sees and interacts with. These are the flashy and glamorous parts of applications, including database applications, but the sheer number of options available can make them overwhelming when you first begin. Where do you begin? What types of forms can be found in Microsoft Access 2021? What is the best use for each type of form?

In Microsoft Access 2021: Forms, we will discuss the basic design principles of creating a user interface for a database application in Microsoft Access 2021. You will learn about the major types of forms available in Microsoft Access, such as table forms, split forms, multiple record forms, navigation forms, and subforms. We will cover how to create each type, what they are used for, the pros and cons of each type, and how to configure each of them. You will also learn how to combine separate forms into more complex forms to create a complete application user interface experience for users.

What You'll Learn

  • Recognize table forms in Microsoft Access 2021
  • Understand split forms and how to configure them
  • Explain multiple record forms and their best uses
  • Create blank forms and navigation forms in Microsoft Access
  • Combine separate forms and subforms into a complete application user interface
  • Apply basic design principles for building a database user interface

Key Takeaways

  • Forms are the user interface of a database application, the front end that every user sees and interacts with.
  • Microsoft Access 2021 offers several major form types, including table forms, split forms, multiple record forms, navigation forms, and subforms.
  • The course covers how to create each form type, what each is used for, and the pros and cons of each.
  • Separate forms can be combined into more complex forms to create a complete application user interface experience.
  • The course teaches basic design principles for creating a user interface for a database application in Microsoft Access 2021.

Frequently Asked Questions

What does this course cover?

It covers the basic design principles of creating a user interface for a database application in Microsoft Access 2021, including the major types of forms such as table forms, split forms, multiple record forms, navigation forms, and subforms, plus how to create, use, and configure each.

Which form types will I learn about?

You will learn about table forms, split forms, multiple record forms, navigation forms, and subforms, including how to create each type, what they are used for, and the pros and cons of each.

Will I learn how to build a complete user interface?

Yes. The course teaches how to combine separate forms into more complex forms to create a complete application user interface experience for users.

What skills does this course focus on?

The course focuses on skills including Form Fields, Microsoft Access, Microsoft Forms, Oracle Forms, UserForm, and Windows Forms.

What topics are taught in the lessons?

Lessons include What are Forms?, Table Forms, Split Forms, Multiple Record Forms, Forms Navigation, Creating Blank Forms, and Forms and Subforms.