From the course: Building Solutions Using Excel and Access 2016 Together

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Building a basic form on Excel tables

Building a basic form on Excel tables

From the course: Building Solutions Using Excel and Access 2016 Together

Start my 1-month free trial

Building a basic form on Excel tables

- [Instructor] If you work with an Excel solution, you know that something as simple as a name change can almost start the whole process over again. Right now, people are manually entering information into Excel sheets, maybe sending it to someone else. We could all benefit from some simple data entry forms. That way when the data is changed, everywhere is up to date. Let's take a look. OK, let's go ahead and choose department list names. We want to create a form that will allow us to keep this department list up to date. I'll go to create. I'm going to use the form wizard for this example. It defaults to department list names but I could change it to any table or query. I'm going to add all the fields. I'll choose next. I can choose any of the formats, but for this example, we'll use columnar. I'll choose next. If I wanted to change the title of the form, I could do that now. We'll just keep the default. We'll choose finish. Now I have a basic data entry form. Let's take a look at…

Contents