Updating ms access table from form

For example, if you run a store, you would create a Customers table, a Products table and an Invoices table.

Then, when you open an account for a new customer you would have a Customer form to input a customer's data into the Customers table and an Order form to input the purchase information.

The application is a Video Rental Store and it's well suited to showing how a small businees could put into practice all these notions of management with databases.

updating ms access table from form-46updating ms access table from form-78updating ms access table from form-70updating ms access table from form-9

If you’ve used previous versions of Access, these are the databases you’re already familiar with, and you’ll continue to work with files you’ve created in the past.

The important thing is this: the concepts of relational database design, the tables, fields, primary keys, relationships, the SQL language for queries and the VBA code behind the objects, all of that is unchanged.

The interface is different, meaning that it may be easier to create forms or reports in some cases and you edit objects differently but the main fact is that the essential material that you have to learn is behind the interface anyway. The Professor suggests that you study these tutorials diligently, no matter what version of Access database you are using.

Later, you could print any number of Sales reports, grouping and arranging the information from the Invoices, Customers and Products tables to analyze daily or weekly or monthly sales in all kinds of combinations.

To help you along, Access contains a whole series of Wizards to guide you through the process.

Leave a Reply