I need to build a database using access with two tables suppliers and products Y

Question

I need to build a database using access with two tables
suppliers and products
You must use Access to complete this assignment.  Using other software will result in a grade of zero.
When you are finished, your database must contain TWO tables, Suppliers and Products.
The Suppliers table must contain the following fields:
Vendor ID
Vendor Name
Contact name
Business Phone (use input mask)
Email
You must have at least (10) different records. You need to make up this data, it is not provided.

The Products table must contain the following fields:
sequence (AutoNumber)
Product Brand
Product Description
Vendor ID
You should have at least (4) vendors selling the same item. You need to make up the data, it is not provided.
You should create one report that groups all products by vendor, listing out each product the vendor supplies, sorting the products by name alphabetically.
The report should be formatted in a manner that gives a professional appearance, with columns aligned.
Finally, you need to use forms to give a user-friendly way to input, add, and update data in the tables.

Explanation / Answer

There are many ways to create multiple tables in a Microsoft Access database, here are just 4 of the most common ones.

1. Design View

One way is to simply use the design view wizard to create multiple tables in your database. This is the easiest and most obvious way to create multiple tables.

2. Import Table

Another way would be to right click on the right pane of the main Access dialog box and click on "Import". Select the Microsoft Access file that has the tables you want to import into this Access database.

3. Drag and Drop

If you have two Microsoft Access databases open in two separate windows, you can drag and drop a table from one database into the other. You do this by making sure there are 2 instances of Microsoft Access open (each database is open in its own Microsoft Access window). Click on "Tables" on the left pane of both windows so that the tables are displayed. Drag and drop a table icon from one window into the right pane of the other one. This will be the equivalent of copying that table (the fields and data) from the original database and pasting it into the new database.

4. Copy and Paste

You can duplicate a table you currently have by simply copying and pasting it on the right pane. Right-click the table icon and click copy (Edit -> Copy) and then right-click anywhere on the right pane where it is blank and click paste (Edit -> Paste).

For this example I will copy and paste the table called People. Right click on the table called People, click on copy. Right click anywhere on the right pane and click paste. It will ask you to give this table a name. Call it anything you want. For this example, I will call it People2. For the paste options you have the chance to select between "structure only", "structure and data", and "append data to this table". For this example I will choose "structure and data".

Once you have made the selection and enter the table name click OK. Now you will see the additional table that you just pasted on the right pane. If you double click and open the People2 table you will see that it is exactly the same as the original People table.

This new table, is a second table and is totally separate than the original one. You can make changes to this People2 table and it will not affect anything in the original People table.

This is probably the easiest and simplest way to create multiple tables very fast in Microsoft Access, but I would not recommend it because it will result in 2 tables with exactly the same fields and data.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.