MS Access - how do I create this form?

Question

I am teaching a high school class to build a database for a video store. I would like them to build a form that would allow a clerk to register a video rental. In other words, they would enter the customer number and the film title, and then a record would be added to the Orders table, and the OrderDetails table.

How can I create a form (or something!) that will allow me to update two tables, with the data entered in the form? Thank you, this is worrying me.

Answer 1

Hey Good Question! I teach Access at the local college as well as use it to create databases for my clients and this is how I teach my students at this level.

Create a query using the queries containing the fields you need in the form. Base your form on the query. If you need the form to be for data entry only, in design view of the form open the property box for the form and set data entry to True.

Good Luck!

Jen

Answer 2

did you recognize th time period 'many to many'? each and every each and every now and then, get precise of entry to received't provide help to edit files on a form because get precise of entry to isn't confident in certain which record is being edited. My way round it really is that i visit apply a subform so as that get precise of entry to knows precisely which record is being edited [a subform resources archives of the 2d table one-through-one] OR I make a clean variety open even as a person clicks an EDIT button. That new variety will in worry-free words include the tips of the unique record which i desire the person to edit. it really is complicated although because think ofyou've got to replace the unique variety once the edited variety closes. Mike

Answer 3

there is something you need to do programming in VB CODE or try to make some relationship where it can link some of the data from one part to other part

Answer 4

the tutorials on this site are easy to follow and very informative.

http://www.gcflearnfree.org/Tutorials/

Answer 5

Why not just use the software program????