Can I use a query to store data?

[wannabesmart]

Example;


there are some tables, they're:
Item table, Vendor table, Employee table, Purchase table, and PurchaseDetail table.
Then, I want to make a new table that contains some fields from tables above (Invoice number, employee id, vendor id, address, phone number, item code, price, unit, total using formula).
I want to input data through form, I make a form from query, so data will be stored in the new table, purchase and purchase detail table will be empty.


Is this possiible?
is it allowed in database?


Another question is:
When I read books about Access, why the next step after making tables is making query, why not making forms then query?


I'd be grateful if anyone could help, thanks in advanced

[Ruegen]

Basic run down as I am unsure if you know:

Table stores the data

Query represents the table/s

The form has a record source, it can be direct to the table or for efficiency and table relationships it can be a query. Having a query will mean if the tables are related you can pull in fields from two tables and have them show on the form.

So when you make a query you:

pick a table
pick what fields you want (always include the ID field if possible).

[Ruegen]

Example;
there are some tables, they're:
Item table, Vendor table, Employee table, Purchase table, and PurchaseDetail table.
Then, I want to make a new table that contains some fields from tables above (Invoice number, employee id, vendor id, address, phone number, item code, price, unit, total using formula).
I want to input data through form, I make a form from query, so data will be stored in the new table, purchase and purchase detail table will be empty.


Is this possiible?
is it allowed in database?


Another question is:
When I read books about Access, why the next step after making tables is making query, why not making forms then query?


I'd be grateful if anyone could help, thanks in advanced

If you make and save a query yes you can use it to store the data in the corresponding tables however it's not a great way of viewing the data and not recommended - forms are what I would suggest. You can make a form off a query.