Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Access > Create Access 2013 Forms using the Form Wizard

Create Access 2013 Forms using the Form Wizard

If you are using only Access 2013 tables to manage your database, then you are just using a fraction of the functionality that it has to offer. You should go a step ahead and start using Access 2013 forms to make your database user friendly and interactive. Access 2013 forms allow you to impose controls on the way data is entered. Creating forms in Access 2013 is extremely simple; all you have to do is to select a table, then the form type, and finally the fields. A highly customisable form would be ready to become the face your database.

Watch the free video here, transcripts for the entire video follow:


Facebook Linkedin Twitter

Need effective Access 2013 training? Get our 9-hour of Microsoft Access 2013 training – click here.

Video transcripts:

Welcome back to our course on Access 2013. In this section we’re going to start to take a look at forms and forms are the primary means by which we allow users to interact with our database. During most of the course so far we’ve been looking at tables and table design and entering data directly into the tables in that general spreadsheet style, the Datasheet View as we call it in Access. But that’s not really a good way to get users in general working with the data in a database. It’s far too dangerous. It doesn’t present the data in a way that’s easy for users to understand and generally speaking it’s asking for trouble really. So what we do is to provide forms and with those forms not only can we control what people are able to do with the database but we can do many other things as well, such as perform calculations and checks in the background. We can fire those events which I mentioned earlier on whereby when we change a piece of data in one place it causes something else to happen elsewhere in the database. So forms are a great way of both protecting the database and perhaps more importantly helping users to get the best out of the use of the database.

Now as we’ll see there are a few ways of creating forms in Access 2013 and I want to start with a very simple case. What I’m going to do is to open the genre table, so just double click to open the genre table and then I’m going to minimize the Navigation Pane, then I’m going to the Create Tab and then there’s a Forms Group. Now in the Forms Group there are really four ways or four main ways I should say of creating a form. There is this button, Form, where you create a form that lets you enter information for one record at a time. There’s form design which gives you a blank form and then lets you layout the form in exactly the way that you want by adding controls to the form in exactly the positions you want. This one, blank form, which creates a form with no controls or formatting whatsoever and lets you start literally from scratch and then there’s also a Form Wizard and we’ll look at the Form Wizard a little bit later on. That’s a very helpful way of creating forms but given that the way it does things may not quite agree with the way you like to do things. Sometimes the Form Wizard although it looks as though it’s going to save you time can actually take you longer to create forms and this probably particularly the case when you’ve been using Access for a while and created quite a few forms. Now the other on there, the navigation form, is very often a feature that you’ll use as what I would call the front end to the database. It’s the way that you control in the broadest sense what users are able to do in your database and we’ll be looking at a navigation form much later on in the course. Now the drop down here with more forms gives us access to modal dialogues, split forms, etcetera and we’ll come back to a couple of those later on as well.

 

Simon Sez IT courses

 

The first thing I want to demonstrate is the Form Wizard. So in the Forms Group I’m going to click on Form Wizard. It’s actually a sequence of dialogues. Given the table that is selected which is the genre table at the moment there is only one available, field. All of the available fields are here but there is only that one, genre. So I choose the available field or fields that I want on my form and click on the arrow there and that becomes one of the selected fields that will appear on this form. Having chosen the fields that I want, in this case there is only one, I click on Next and then I’m given a choice of four layouts for a form. Now datasheet layout, the third one, is pretty much the same as a datasheet. You can try that yourself but it doesn’t really help us very much. There are some situations where it’s useful as we’ll later on. But the one I want to demonstrate first is a very straightforward form. It’s tabular form. And what happens in a tabular form is that we have a table with the fields that we’ve chosen across the page. So the first field is one column, the second field is another column, and so on. So having chosen tabular layout click on Next, now we’re asked to give our form a name. The prefix I use on form names is F-R-M and I’m going to call this frmGenreTabular for the moment just so we can remember what it is.
Now when I click Finish I get a choice here. I can either open the form to view or enter information or I can modify the forms design. I’m going to open the form, click on Finish, and there is my form. Now it may not look very different from a datasheet but it’s actually really quite different. We have still one row per record and the tabular, the tables in this case, there is only one column. The column is genre and the genre we’ve got are Action, Adult, Adventure, and so on. Now what the Form Wizard has done is to look at our table definitions and to decide how wide to make these fields. Now we changed the size of this field to 30 characters maximum and it’s pretty much allowing for 30 characters maximum. Clearly looking at the data that’s there all ready that field is probably a bit too wide but never mind. If I wanted to change any of the data in this using this form I could literally just click in a field and delete, type, whatever I want to do. I get the familiar pen symbol in the left there, the little icon that tells me I’m changing that field and I can either click undo or press Escape if I want to undo any changes. And when I insert new records they’re always inserted at the end. I’ve even got a set of navigation controls down here. So if I want to go to new record, new blank record, click there and I can add a new genre at the end and that’s where it will appear.

Now that’s a pretty straightforward form updating genre and you probably look at it and think, Well that’s not really giving me anything over Datasheet View and to some extent that’s true. But at the moment I’m just trying to look at the overall features of forms.

So let me close that form and I’m going to close the genre table as well and I’m going to open up the Navigation Pane again and we’ve now got a new section in our Navigation Pane for forms. And don’t forget if we’re interested in one particular type of object we can collapse the list for another object like tables and we’re just concentrating on forms at the moment.

Now with the form we’ve just created I’m now going to go into Design View. I’m going to take a look at it in Design View because in Design View it looks like a very different thing altogether. And you can see the structure of that form. In fact at the moment the structure has really three parts. There is a header, there is a detail section, and there is a footer. So we’ve got a form header and a form footer and they will be common features in forms, headers and footers. Now this particular form doesn’t currently have a footer but don’t worry about that. We’ll come back to that in a while. The detail section is very important because this is the part that is repeated for each record in our table. So basically at the moment the detail section is one field, it’s the genre field. And you can see there the size of the field.

 

Simon Sez IT courses

 

Now what I want to do is to look at the properties of that field. And if I click just on the edge of that field you’ll see that the field now has a sort of orange border around it. That indicates that the field is selected. If I right click right down at the bottom you may just about see it, it says Properties and that opens up a property sheet on the right here. And this contains the properties of that one field. Now as you can see there are a lot of properties. You can do an awful lot of things with a field on a form in Access. And the first time you see that it probably looks a bit scary, but we’re just going to concentrate on a couple of the main points to begin with.
Now one thing to be careful of whenever you’re looking at properties on forms is to make sure that you have the right object selected. Sometimes you’ll have an individual field selected as we have here. Sometimes you might have the whole form selected. You can always check your selection over on the top here because it says the selection type in this case is a textbox and the particular control we’ve got there holding the text for the genre of the field is a textbox. It’s one of the simplest controls you’ll see on a form. By the way let me just move the Navigation Pane out of the way there.

Now let’s look at some of the other properties of this particular textbox. It has a name. It’s called Genre. It gets the same name as its next property control source. What this means is given the table or query that this form is being populated by, so where the data’s coming from, which field goes in here. And the field that goes in there is the genre field.

We then have format. Now we talked about format in relation to tables earlier on and I also mentioned that you don’t necessarily make all of your definitions in your table design. Sometimes you may want to do some of your definitions in your forms. And this will apply to things like input mask, format, etcetera. Now most of the other properties we’ll either come back to later or they’re a little bit detailed. But just to give you one or two further examples down there, you have a text align option here of general. You could change that if you wanted to. If you for instance wanted the text here to be right aligned on this particular form you could select right align here instead of leaving it at general. And there are many other properties, some of which we’ll be looking at later on.

Now this is a very long list of properties and in fact we are looking at the All Tab here which lists all of the properties of that field. There are tabs here whereby the properties are categorized. So properties associated with the format are on that tab, with the data are on that tab, with events are on that tab. So for example what happens if the user double clicks on that field and then we have a category of other as well. So when you’re used to using these properties you’ll probably be able to go more quickly to a particular property that you might need in a given situation.

Now when I right clicked on that field before you may have noticed that one of the options was not properties but form properties; let me just click on form properties down at the bottom. And now what I have selected is the whole form. You can see selection type is form. And what we see is the properties of this form. Now we’ve currently got the other tab selected. Let’s just select the All Tab and what we can see is first of all the record source. Let me just pull this over. Note we can make that property sheet bigger; make it a bit easier to read what each of the properties are. The record source is the table genre, tblGenre. The caption on the top is F-R-M-GenreTabular.
Why don’t I change that caption and say. There I think that’s probably better. Is it a pop up form? No. Is it modal? No. Now the significance of modal will become apparent when I talk about that a bit later on, but basically a modal form is one where you have to deal with it and click OK or cancel it before you can do anything else. That’s rather oversimplifying but that’s the general principle. The default view if this form is continuous forms. That’s very important. That’s the thing that makes it work in the way that it did, like a datasheet if you like. You scroll through all of the records and that’s because it’s a continuous form. Now there are various other properties and several of those we’re going to look at in detail later on. But it’s very important as I said before to know whether you’re looking at the form or one of the fields on the form.

So let’s close this property sheet. Let’s close the form, saving changes, open up the Navigation Pane again, and let’s just open our form again. You can see the revised caption at the top there, the one that I typed in. Don’t worry too much about what’s in the heading because we’re going to tidy up the heading later on. But as you can see the form works in the way that it did before and the continuous form part of it is the bit that means that we scroll continuously through all the records in that particular table.

In the next section we’re going to look at another type of form so please join me for that.

 

MS Project 2013 online training by Simon Sez IT

 

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

START LEARNING Create Access 2013 Forms using the Form Wizard ON SIMONSEZIT.COM

START MY MEMBERSHIP

Similar Posts

Cropping Pictures in PowerPoint 2016

How to Use Nested VLOOKUP in Excel? A Step-by-Step Guide

Top 10 Essential Microsoft Project Templates for Project Management

Google Sheets vs Excel—The Ultimate Showdown

Using the Layout Tab for Excel 2010 Charts and Graphs – Part 2

Assigning Cost Accruals in Microsoft Project 2016

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)