Help with inputting data into Access

[chamPiN17]

I'm building a database in Access and I want a way for users of the database
to not have to use the tables to directly enter data into it. Can you do this?

 

[chamPiN17]

Bump

 

[John N.]

I'm building a database in Access and I want a way for users of the database
to not have to use the tables to directly enter data into it. Can you do this?

Hi champin17,

Yeah, you can do that. In fact, it's better to do that so that if the user
isn't very good at Access or something, there's less of a chance of them
ruining the data.

What you gotta do is make forms for the user to use. These will basically be
boxes on the screen where they can input data and send it directly to the
tables without actually messing with them. In the main screen that pops up
when you start Access, click "Forms" and then "create form by using wizard."
You can choose which fields from your database that you want to include on
the form. When you finish it, you've got a basic form for entering data. You
can make as many of these forms as is necessary for your database.

Hope this helps,

John

 

[chamPiN17]

Thanks John, but how do I use these forms when I'm done with them? I mean,
how will the final user use them to put data in the tables? It would make
more sense if it was like a webpage that took the user from page to page as
they entered data.

 

[John N.]

champin17,

You can use a switchboard to make it seem more like the users is using a
"web page." It basically makes it so the user can click buttons to navigate
to each of your forms. Make a switchboard by going to Tools --> Database
Utilities --> Switchboard Manager. Click "New" to make a new "page" on your
switchboard and specify what you want on it. You can put a form on one of the
"pages" and have it "linked" by another switchboard page, kind of like web
pages, like you mentioned. It's fairly easy to do, it might just take some
messing around with it to get it just how you want it.

John N.

 

[chamPiN17]

I think I'm getting the hang of this. I also made a switchboard and have made
some progress. Thanks for all your help.

Hey John, I think Im getting the hang of the forms. I also made a
switchboard and I think I udnerstand how it's supposed to work, but I haven't
really used it very much yet. But I'm making progress, anyway. Thanks for the
help