| new skills - Team Nuggets
New Training: Create Forms in Access 2019
In this 8-video skill, CBT Nuggets trainer Jacob Moran teaches you how to create forms in an Access database. Learn how to correctly define controls and use the different elements of a form to convey real-time data. Watch this new Microsoft Office training.
Watch the full course: Microsoft Access 2019 Training
This training includes:
- 8 videos
- 41 minutes of training
You’ll learn these topics in this skill:
- Introduction to Access Forms
- Identifying How Forms are Used In Access
- Navigating Access Forms
- Creating a Form using the Form Tool and Form Wizard
- Creating a Form from Scratch
- Defining Tab Controls for Access Forms
- Defining Tab Order in Access Forms
- Summary of Creating Forms in Access
How are MS Access Forms Unique?
Microsoft Access is a unique type of self-contained database. It is a fully functional relational database, but instead of being contained in a server, such as MySQL, it is file-based. Unlike a database like MySQL, that also makes Access databases very transportable. Because of this, one of the unique features that Access databases offer is Forms.
Forms are a function of Access itself. Forms can be created within the Access application to work directly with a database. Forms can be created to accomplish all sorts of tasks like adding data to the database, deleting data, or pulling and displaying data.
This is different compared to a database like MySQL. Though MySQL databases can be interacted with directly, those interactions are done through the command line. Access Forms are an integrated, graphically native way to interact with an Access database.
Access Forms are different from something like an HTML Form. An HTML form is an element of another programming language. It is processed by other apps like a web browser. HTML forms interact with other software controllers which then interact with the database. There is a series of apps and tools required in this scenario to interact with the MySQL database. These mechanisms are not needed for an Access database. Instead, forms created in Access work directly with that access database. No other tools are required.