Customer Form 1

Lesson 10: Build Form, Use Layout, Edit Data

S M L XL FS | Slo Reg Fast 2x | Bookmark

In Lesson 10, we will walk through how to build a customer form in Microsoft Access, using the Quick Form Builder to create a user-friendly interface for adding and editing customer records. We will discuss the benefits of forms over tables and queries, look at layout view, and explore navigation, editing, deleting records, and form types such as basic forms, form wizards, multiple items forms, split forms, and modal dialogs. This lesson focuses on creating quick forms using layout view, while we will discuss using design view for more advanced form design in the next lesson.

Navigation

Prev: Lesson 09
Next: Lesson 11

Keywords

Access Beginner, customer form, form builder, layout view, design view, quick form, navigation pane, form types, subform, split form, continuous form, form wizard, blank form, record selector, add record, delete record, field labels, text box, save form,

Subscribe to Customer Form 1
Get notifications when this page is updated

Intro

Transcript

In lesson 10, we're going to build a customer form to present our user with a nice, friendly interface for adding and editing records. We will see how the Quick Form Builder works, learn about navigation, layout view, deleting records, and the different types of forms in Microsoft Access.

So far today, we've seen how to build a table, enter and edit data in a table, and we've created a couple of queries. Tables and queries are, of course, functional and necessary for most databases, but they're not very friendly to work with, especially if you do not know Access. In this lesson, we are going to see how to set up a couple of different types of forms.

Forms are used to work with data on the screen. Forms look a lot better than working directly with tables or queries. They make it easier for you to enter, edit, and find information. A database that's easier to use is more efficient.

Here is an example of a simple customer form. You can see all the information laid out, one customer per screen. This is a lot easier on the eyes, and a lot more user-friendly than simply dropping the user right into a table and saying, here, go to town, just like if you give them an Excel spreadsheet. This is a nice, user-friendly interface.

Forms also provide you with additional control and security over your database. You can control which fields your end users can see and what data they can edit. If you do not want them seeing the credit limit, for example, do not put it on that form. You can keep it in the table and make a separate form for you or your managers, but your average end user does not have to see all of the information for every customer.

You can control whether users can add data, edit data, or delete records, all using forms. In later classes, we will learn how to make buttons so, from the customer form, you can open up their contacts form or their orders form. You can do all kinds of neat stuff with forms.

You can set up forms to look like existing paper forms that you might have in your current system. If your users are used to entering data in a specific way on a specific paper form, you can make your on-screen form look just like it. This way, they know what data goes in what fields. It makes it easier for your users to transition from an old paper system or even old software into a new Access database.

You can design the forms to look however you want. You can have data from multiple tables displayed together on one form. For example, you could show a customer and all of their contact history in something called a subform. It is a form that displays inside of another form. Or you could have all of their order information show up in a subform. Or, like I mentioned before, you can have different buttons to open up forms related to the form that you are on. For example, here is a customer record. I can click on the order button, and that opens up the orders for that customer.

We get to subforms in the expert classes, Access Expert 3, and they are really powerful. In today's class, I am going to show you how to set up a simple customer form just to get you comfortable with form design. Over the next couple of classes, we will be spending a lot of time on form development. Keep in mind that building forms is really more of an art than a science. You can spend many, many hours making your forms look good, and I know I am pretty guilty of that.

I've got whole lessons where I spend time just showing you how to make custom form elements and custom backgrounds. You can make your database look like Windows 95, you can make it look futuristic. All kinds of crazy stuff. I will put some links down below in the link section you can click on.

Good form design is time-consuming, but it can really make your database look professional. It just takes practice, and the more you do it, the better you will get.

Now, there are two primary ways to build a form. There are a couple of different sideways too, but the two big ways are layout view and design view. Now, I use design view. Design view is a little more advanced, but once you get the hang of it, you get a lot more control over your forms. Layout view is a simple way to build fast forms, but you get fewer options up front.

I like design view myself, and I am going to stick with design view throughout most of this course. However, I know a lot of you who are watching this video are not necessarily looking to be Access developers. You just want to get in there and start working with Access and build some quick forms. I am going to show you layout view first, then I am going to show you design view in the next lesson.

If you are just curious about how to get in there and build a couple of quick forms, and you are not looking to be an Access developer, then this lesson is for you. The rest of you, if you really want to learn Access and get your hands dirty and become a developer, you will want to learn design view, and that is going to be in the next video.

Here we are back in our database that we started earlier, and you can see my navigation pane over here. Click on the customer table. Now, on the Create tab, right over here you will see a forms section. Now, these are all the different ways you can build a form. There is Basic Form, which we are going to start with, that is for layout view. Then here is Form Design. That is the more advanced one that I am going to show you in the next lesson.

There are some other options that I almost never use: Blank Form, Form Wizard, all this different stuff in here. I will talk about these things in future lessons, but these are the big two right here.

Click on Customer T, then come up here and click on Form, the first one. Access just goes ahead and builds a form for you. It does not give you any questions or any options, just boom, there is your form. It bases it on whatever table or query you had selected over here.

Now, I personally do not like layout view. I think this is messy. It is designed for novice users to get in here and just quickly build a form, and I understand why Microsoft put this together.

A lot of people are familiar with Excel, and they're trying to treat this almost like a spreadsheet. You can resize these objects as rows by clicking on that and then resizing it. You can resize these as columns. See that? Click here, resize that column, resize that row. But I think this overall look is just a little messy. That is just me. It takes a lot of time to make this look good.

Now, here in your form, you will see there are two components to each field. There is a label and a text box. The label is the name of that field - First Name, Last Name, Company Name, and so on. Those are labels. The data goes in something called a text box.

Some of these fields, you will see, have check boxes. Yes or no fields will have check boxes associated with them. You just click them on and off.

Now I am in layout view. I can see the data in here, but I cannot actually edit it yet. I will show you how to do that in just a second.

If you want to change any of these labels, you can. Just click on it a second time, and you can make that say, for example, First Name, with a space. These are labels. This is what the user is actually going to see on the screen. You are not changing the name of it. Remember, the actual name in the table, the name of the field, I want to be FirstName with no spaces there. But you can come in here and make these say whatever you want. These are just labels. These are just for display purposes. You can just put "Company" in here, for example, if you want to. That is not going to change anything really.

You can resize these rows like that. Again, I am not very impressed with layout view. I do not use it myself. But it is a quick option to come in here and to build a form.

Up top here in the form header, you have a bit of a description. You can change that. That is also just a label. "Customers," for example. A little picture over here - if you want that, you can delete it if you do not want it. Click on it and hit Delete. Just a little image.

Now, when you are happy with the way this looks, you can save it. Control S on your keyboard, or you can hit the little floppy disk in your toolbar. Save. I am going to call this "Customer F," my customer form. Hit OK.

Now, you will see it appears over here in the navigation pane. If you are using an older version of Access, I know in Access 2013 there was a bug where, when you saved an object, it did not appear right over here automatically in the navigation pane. You had to refresh it with F5. So hit the F5 key on your keyboard if you do not see your objects appear. That is an old bug. I just remembered it now because the last time I recorded this class in 2013, I mentioned it in that video. So, if you are using 2013, by the way, upgrade. Get Microsoft 365, get the latest version of Access. Trust me. Lots and lots of bug fixes that they have since gotten rid of.

Now that I have saved my form, I am going to close it and then reopen it again. When you open it this time, you are in form view. We are no longer in layout view, and you can tell because you have a blinking cursor right here. Customer 4. I can hit tab. I can start typing in data. I can make edits - "Forestry Services Inc.," for example. Tab, tab.

Down here, remember these are navigation buttons. Just like in tables and queries, we can move to the next record, previous record, first record, last record, new record. If you want to add a new record, start putting in the next person here. They get assigned the next auto number. You do not need to worry about what that number is.

This is what your end user is going to work with - this form. They are not going to play with your tables or your queries.

If you want to make changes to the layout of the form, right up here under Views, drop this down. There is Form View, Layout View, and Design View. We are going to talk about Design View in the next lesson. That is how I prefer to work with forms.

For now, if you want to change the layout, just go back to Layout View. Remember that? You can see you have these yellow bars around these guys right here. You can move things around - you can move Credit Limit down here, for example. There is all kinds of stuff you can do. Click and drag things. But again, this is not my preferred way to work with Access forms. Done changing the layout? Come back over here. View, Form View. You go back to Form View.

I personally like to close a form, save the changes, and then reopen it. That is a good habit to get into, especially if you are planning on becoming a developer. Take it from me. Once you start putting Visual Basic programming code behind these forms, you want to make sure you close them and reopen them so any changes take effect. You do not want to flip between views.

Now, as a reminder, just like queries, the data that you see here is live. This information is linked to the table. So if you delete records out of here or make changes to records, it affects the data in the table. It is not a copy. It is a live view of that table's information. It is just displaying it in a nice, pretty way.

When you are adding a record or editing an existing record, remember you will see the pencil over here. That indicates the record is dirty. That means it has not been saved to the table yet. How do you save it? You simply move off the record or close the form, and that will save the record to the underlying table.

If you come in here and start editing, now it is dirty. As soon as you close the form or move off that record, it saves the information to the table.

Now, if you do not want this record, how do you delete it? Come over here and click on this big gray bar on the left-hand side. That is called the record selector. Click on that and then hit Delete on the keyboard. Access will say you are about to delete one record. You cannot undo this operation. Once you say OK, you are done. That record is gone. So be careful. You want to delete that? Yes, OK, all gone.

If you want to delete multiple records, I recommend going right to the table. But be careful. That is dangerous. Make sure you have good backups. Back up your data. Back up your data regularly, especially if it is important. I have got whole lessons on backing up your data. I will put some links down in the link section for you. Go watch those.

When you are working with your forms, you will also find a familiar set of buttons up top here - sort ascending, descending, filter buttons. We learned about a lot of these working with tables. You can come over here, for example, and find a state, right click on it, Equals Ohio, for example. Now you will see just the Ohio records. We learned about sorting and filtering earlier. Let me unfilter that now.

If you want to sort these records by last name, click on the last name field, and then hit sort ascending or descending or however you want them to sort.

Now, like I said, I do not particularly like building forms this way. I want to show you the quick way for you non-developers who want to get in here and just quickly work with Access. But for the rest of us, I am going to delete the customer form. Click on Customer F, hit Delete on the keyboard. Are you sure you want to permanently delete Customer F? Yes, and now it is gone.

In the next lesson, we are going to make a customer form with Design View.

I want to really quickly, though, show you the other form options that are here and just explain what they do real quick. So click on Customer T.

Blank Form just gives you a blank form. No controls. That is it. That is all you get - blank form. It is not that useful. Get rid of that. Close that.

Click. What is the next thing over here? There is the Form Wizard. The Form Wizard is not too bad. It will ask you what fields do you want on your form? Customer ID, click on that one, bring it over, first name, last name. Let us say I do not care about the address. I just want their email and their discount rate. Sometimes you can make specialized forms. Like I mentioned earlier, you might have a form for your front-end people to use and a different one for the managers with all of the fields on it.

Hit next. How do you want it to look? There are different options in here for how you want it to appear. Let us go with column. That is the default, column. Next.

Open the form to view or enter information, or modify the form's design. We have not gotten into form design yet, so let us pick the first one and then hit Finish. Then it builds the form for you. Very similar to what we did before. It puts you in layout mode like this. Quick and dirty way to build a form. But again, I do not want this. Let us just close it and delete it. Are you sure? Yes.

Again, just a quick tour of the different types of forms.

Customer T. Create. What else do we have here? Navigation forms. Navigation forms let you make forms to open other forms. I am going to show you how to use these in Access Beginner 7. I spend about 10-15 minutes showing you how they work. Personally, I do not like them. I like to build my own menu forms using my own buttons. Here is an example of my TechHelp free template, for example. I like to build my own menus like this. Customer list. Customer form. I do not like to use built-in navigation forms. So I am going to spend a little time showing them to you, but I do not personally use them.

What else do we have under here? More forms. There is this thing called a multiple items form. That looks like this. Let me close this field list. We will talk about the field list in the next lesson. This is the multiple items form. Now it comes in pretty big. I am going to just resize one of the rows like that. Another name for this is a continuous form. Here, this is called a continuous form in Access speak.

Now, I use continuous forms all the time, but I do not build them this way. Again, I do not really use the wizards that come in Access. I like to build things by hand. Here is what my continuous form looks like. I think you will agree this looks a lot nicer. So again, I do not want that. Close it. Save changes? No.

What else do we have? Create, More Forms. We have a split form. Split forms are OK. Split form gives you the layout view on top and then a spreadsheet view down here at the bottom that looks like a table. You can move through the records this way. Again, I do not particularly care for this. I do not use it myself. I like taking my continuous form and making it so you can double-click on a customer and it opens up the customer form. That is how I like to build them. Again, I cover how to do all of this in the videos that come with the TechHelp free template. I will put links down below if you want to go watch that now, but I will cover this throughout the entire course, throughout the series of these classes. You will learn it. I just go over it faster in the template video.

So again, split forms are not my favorite. I do not usually use those either.

The last option in here, modal dialog, is for making little pop-up windows, usually to give some kind of warning or some kind of information, or to get a few bits of data from the user and do something else with it. Again, I do not use these. I will show you how to make modal dialog boxes, but we are not going to use this More Forms option.

So, that is a quick tour of all the different kinds of form building buttons that are in here, all the different ways you can build a form, except the one way that I personally prefer, and that is by using Form Design. So, that is what we are going to cover in the next video.

Form Design lets you get in here and actually position all of these elements exactly where you want them, resize them, move things around, and so on. We will talk about that next.

You

Quiz

Q1. What is the main purpose of using forms in Microsoft Access?
A. To provide a user-friendly interface for entering and editing data
B. To run advanced queries automatically
C. To replace tables entirely
D. To create complex reports

Q2. What is a subform in Access?
A. A separate table for storing unrelated information
B. A form that displays inside of another form to show related data
C. A section of a table used for summaries
D. A navigation menu for switching forms

Q3. Which of the following is NOT a major benefit of using forms over tables for data entry?
A. Additional control and security over database access
B. Automatic creation of macros
C. Making the database easier and more efficient for users
D. Customization to look like existing paper forms

Q4. What is the difference between a label and a text box on a form?
A. Labels are used for input; text boxes display calculations
B. Labels show field names, while text boxes hold the user's data
C. Text boxes hold passwords; labels hide them
D. Labels are only for printing

Q5. Why might you use multiple different forms for different users in your database?
A. To randomize record order for each user
B. To restrict which fields certain users can see or edit
C. To allow users to create their own tables
D. To automatically back up data

Q6. What happens to data you add or edit in a form?
A. It is stored in a temporary file until you export it
B. It is saved directly to the underlying table
C. It is visible only within the form you are using
D. It cannot be deleted

Q7. In the video, why does the instructor prefer Design View over Layout View?
A. Design View is faster to use for beginners
B. Design View offers more control and customization options
C. Design View automatically generates subforms
D. Layout View has more advanced controls

Q8. What does a pencil icon in the record selector area of a form mean?
A. Record is locked by another user
B. Record contains unsaved changes
C. Record is being deleted
D. Record is invalid

Q9. What type of field in a form will often display as a checkbox?
A. Date fields
B. Currency fields
C. Yes/No fields
D. Text fields

Q10. What should you do to delete a record from a form?
A. Double-click the record's field
B. Click the gray record selector bar and press Delete
C. Delete it from the query window
D. Drag it to the trash icon

Q11. What does the Form Wizard allow you to do when creating a new form?
A. Select which fields to include on the form
B. Automatically backup the database
C. Export the form to Excel
D. Create only split forms

Q12. What is a continuous form (or multiple items form) in Access?
A. A form which only displays the first record
B. A form that shows multiple records at once in a list layout
C. A form split with a datasheet on the bottom
D. A form designed for only yes/no data

Q13. Which of the following form-building tools does the instructor state he rarely uses?
A. Form Wizard and Blank Form
B. Form Design and Layout View
C. Continuous Forms
D. Report Wizard

Q14. What is the recommended action if you do not see a newly saved object in the navigation pane?
A. Restart Access
B. Refresh the pane by pressing F5
C. Create the object again
D. Reboot your computer

Q15. Why is it important to close and reopen forms after making changes, especially if you will use VBA code?
A. To export the changes to Excel
B. To ensure changes and code updates take effect properly
C. To reduce file size
D. To print the form

Answers: 1-A; 2-B; 3-B; 4-B; 5-B; 6-B; 7-B; 8-B; 9-C; 10-B; 11-A; 12-B; 13-A; 14-B; 15-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone is all about building a user-friendly customer form in Microsoft Access. Up to this point, we've created tables and queries, entered data, and seen how that all works, but working directly with tables and queries is rarely intuitive for most users. Forms allow us to present a clean interface, making it much easier and more pleasant to add, edit, and manage records.

One of the main advantages of forms is that they transform an otherwise bland database into something that is welcoming and easy to use. When information is presented one customer per screen, it is easier on the eyes and much more user-friendly than simply showing the table or dumping users into something that looks like a spreadsheet. With forms, you control exactly which fields users can see and modify. If there is sensitive information, such as a credit limit, you can choose not to display it on a standard user form but keep it available in the table for managers or those who need that access. You can also set permissions for adding, editing, or deleting records, increasing your overall database security.

Forms give you the flexibility to design them in a way that matches your existing paperwork. If your users are used to filling out a certain paper form, you can recreate that look on the screen. This greatly eases the transition from old paper systems or outdated software to Access, as users can continue to work with a layout that feels familiar.

You also have full control over how your forms appear. You can merge data from multiple tables on a single form, display related records with subforms, and even add buttons to connect your forms together so users can easily jump from a customer form to contacts or orders. We explore subforms in more depth in the Expert classes, since they are a powerful feature, but today is about getting comfortable with basic form design.

There are two primary views for working with forms in Access: Layout View and Design View. Design View gives you the most control and is my personal preference, but it is a little more advanced. Layout View, on the other hand, is the quick and easy option for beginners who want to get started fast with minimal fuss. This lesson focuses on Layout View, and in the next lesson, I will cover Design View for those who want to dig deeper and customize their forms more extensively.

To create a basic form, you start by selecting the customer table and choosing the Form option from the Create tab. Access will instantly build a form for you based on the structure of the selected table or query. This quick method is designed for users who are not interested in fine-tuning every little detail but just want a working form fast.

In Layout View, each field comes with two parts: a label (like "First Name" or "Last Name") and a text box for entering or displaying data. Some fields, such as Yes/No types, will have checkboxes. While Layout View does allow for simple resizing of fields and labels and you can edit what is shown (for instance, changing "FirstName" to "First Name" in the label), it can feel a bit clunky. I find it is not the cleanest way to build forms, but it does help you get started with minimal effort.

The form includes a header area, which works like a title. You can update the header label and remove any decorative picture if you do not want it. Once you are satisfied with your layout, you can save your form (such as naming it "Customer F"). Sometimes in older versions of Access, the newly saved object might not immediately appear in the navigation pane, and refreshing it helps, but with the latest versions, this is rarely an issue.

After saving, closing, and reopening your form, you enter "Form View." This is the main mode your end users will interact with. Form View allows users to enter or edit records directly. Navigation buttons at the bottom enable users to move between records, jump to the first or last record, or add a new customer. Since users will generally interact with forms rather than directly with tables or queries, you can design forms that match the specific workflows your users need.

If you decide later to adjust the layout, you can switch from Form View back to Layout View. Here, you can move, resize, and edit field arrangements or label text. Once finished, return to Form View to continue data entry or review.

It is always a good habit to close, save, and reopen forms after making changes, especially if you plan to add Visual Basic code behind them. This ensures all updates take effect correctly. Also, keep in mind that changes you make in the form are immediately reflected in the underlying table. If you delete a record or update a field, that data is changed in the table immediately - a form is just another window into your data, not a separate copy.

Editing or adding a record triggers a "dirty" state, which Access indicates with a pencil icon. This means the changes are waiting to be saved. Moving to another record or closing the form will save your update to the table.

To delete a record, select the gray bar along the left - called the record selector - and press Delete. Access will warn you that the action is permanent and cannot be undone. Always have proper backups before deleting records, especially if you are removing multiple entries or working directly in the table.

Forms also include familiar controls like sorting and filtering, just like in tables and queries. You can quickly sort by last name or filter by a particular value, such as a specific state. Remember to clear filters when you want to see all records again.

Although Layout View offers a quick way to create forms, more advanced users or those looking to polish their database will want to explore Design View, which I will cover in the next lesson. For now, feel free to experiment with the various form creation options in Access. Beyond the basic form, you will find options like Blank Form (a completely empty form), Form Wizard (which lets you choose exactly which fields to include), Navigation Forms (for building form-driven menus), Multiple Items Forms or Continuous Forms (for displaying multiple records at once), Split Forms (showing a form and datasheet below), and Modal Dialog forms (for popups or simple interactions). While all these options exist, I prefer to build forms manually using Design View for maximum control and customization.

So, this gives you a good overview of the different approaches to form creation in Access and why forms are essential. In the next lesson, I will show how to create forms using Design View so you can fine-tune every detail. For a full, step-by-step video tutorial covering everything we discussed here, visit my website at the link below. Live long and prosper, my friends.

Topic List

Building a simple customer form in Access
Using the Quick Form Builder
Understanding layout view vs design view
Editing and customizing form labels
Resizing and rearranging form fields
Saving and naming your form
Switching between form views
Entering and editing data with forms
Adding and deleting records via forms
Understanding live data updates from forms
Using navigation and sort/filter buttons in forms
Overview of different form types in Access
Using the Form Wizard to create forms
Explaining multiple items (continuous) forms
Exploring split forms in Access
Understanding modal dialog forms
Deleting forms you no longer need

Article

In Microsoft Access, forms provide a user-friendly way to interact with your data. Instead of working directly in the tables or queries, which can be daunting for many users, forms let you design screens that make data entry, editing, and viewing much easier. A well-designed form not only makes your database more accessible for users but also adds a layer of control and security, allowing you to decide exactly which data your users can see and modify.

To start with a common scenario, imagine you have a customer table set up in your database. If you drop a new user straight into the table to manage customer records, they might have a hard time figuring out where to enter or find specific information. It is much more effective to build a form where each customer has their own screen. This makes the process of adding or editing customers much more pleasant and efficient.

Forms can also be customized so that you only show certain fields to some users. For example, if there is a sensitive field like credit limit, you might want to exclude that from most users' forms and create a manager-only version where this information is accessible. This extra control helps keep your data secure and prevents users from seeing or changing information they should not.

Another advantage of forms is the ability to manage how users interact with your data. You can configure whether they can add new records, edit existing data, or delete records at all. Later, you can even add buttons and other features that let users jump from relevant forms, such as opening a set of orders for a specific customer straight from the main customer form.

You are not limited to simple, single-table forms either. Access lets you create forms based on multiple tables. This means you can show related data together. For instance, you could set up a customer form that includes a subform showing all contacts or order history related to that customer. Subforms are essentially forms within a form and are extremely powerful for presenting related information all in one place.

You have a lot of freedom in the way your forms look. If your organization is migrating from a paper-based system, you can design your Access forms to mirror the look and layout of those paper forms. This helps users learn the new system much faster because the transition feels familiar. As you gain experience, you can make your forms as simple or as complex as you like, customizing fonts, background colors, and more to match your company's style or preferences.

There are two main ways to build forms in Access: layout view and design view. Layout view is designed for beginners and is the fastest way to get a functional form on the screen. It is very visual and lets you drag and drop fields, resize columns and rows, and quickly adjust basic formatting. For example, if you want to resize a column to make the first name field bigger, or adjust a row so the company name fits better, you just grab the edge and drag. You can also click labels like FirstName and change them to add spaces, or shorten longer labels like CompanyName to just Company, which only affects the display on the form, not the underlying field name in the table.

When you use the quick form builder, Access creates a basic form automatically based on the table or query you have selected. Each field gets a label and a corresponding input control, such as a textbox or checkbox for Yes/No fields. Once you save your form, usually by pressing Ctrl+S or clicking the save icon, it will show up in your database navigation pane. Be aware that older versions of Access sometimes had a bug where new objects did not appear immediately, and you had to refresh the navigation pane to see them.

When you open your form for regular use, it will switch to form view. Here, you can type directly into fields, navigate through records using the navigation buttons at the bottom, and add new records without worrying about assigning unique IDs, since Access handles that automatically for you.

If you need to revise the structure of your form, maybe to rearrange fields or adjust the sizing, you can switch back to layout view. This lets you see live data and adjust the interface, but your options are a bit limited compared to design view, which offers much more control over every aspect of your form.

It is important to remember that forms display live data from your tables. Any edits, additions, or deletions you make through the form are immediately reflected in the underlying table. When you are editing a record, a pencil icon will appear to indicate a pending change. As soon as you navigate to another record or close the form, Access saves the changes automatically.

If you need to delete a record, you can click the gray record selector bar on the left side of the form for the record you want to remove, then press the Delete key. Access will warn you and ask for confirmation, because deletions cannot be undone. For deleting multiple records, it can be easier and faster to delete them directly from the table itself, but you should always keep current backups before doing bulk deletions to prevent accidental data loss.

Access forms also let you sort and filter information easily. For example, you can right-click a field like State and filter for just one state, or sort by last name by selecting the field and clicking the sort buttons. This makes it simple to quickly find or organize the data you need. Any filters applied in the form are temporary and do not change the underlying table.

Access offers several different ways to build forms beyond the quick layout form. A blank form gives you an empty canvas, which can be useful if you want to build everything from scratch but is not often necessary. The Form Wizard lets you pick exactly which fields to include and guides you through some basic options about layout and style. This can be handy when you want a specialized form, perhaps one just for emails and discounts, for a specific group of users.

Another available form type is the multiple items form, sometimes called a continuous form. This displays several records at once in a list format, similar to a spreadsheet, but with the ability to add buttons or other controls for each row. Split forms show your records in two views: a single record form at the top and a datasheet at the bottom for easy navigation and editing. There are also navigation forms, which are pre-built menu forms designed to open other forms or reports in your database, and modal dialog forms, which are pop-up windows used for gathering a small amount of information or displaying a message.

While these tools are quick and convenient, many users eventually prefer to build forms from scratch using design view. Design view gives you the most precise control over the form's appearance and behavior. You can place fields exactly where you want, adjust sizes, add command buttons, and set up complex interactions or validations using VBA code if needed.

To summarize, Access forms are essential tools for building professional, easy to use, and secure interfaces for your database. They make entering, editing, and viewing information much more efficient and reduce the likelihood of user error. Using forms, you can also control user access, secure sensitive information, and provide a more familiar or comfortable experience for people used to paper forms or other systems. Whether you use the quick layout builder, wizards, or build your forms in design view, mastering forms is key to making a usable Access database. Practicing different approaches and customizing your forms will help you get comfortable with Access and prepare you for more advanced database development in the future.