Access Help

[itsniks]

Could someone help me with a task in Microsoft Access?

[jwhite]

Welcome to the forum. Everyone here is willing to lend a helping hand. Post what you are working on and what your issue is.

[itsniks]

I will post in about 20 minutes what have to be done. It's a task from my university so please help me solve it.

[itsniks]

1. To create a database with the following tables:
1.1. Details for which data is stored:
1.1.1. Catalogue Number - a numeric field integer primary key (PK) of the table;
1.1.2. Name of the piece - a text box with up to 50 characters;
1.1.3. Unit - numeric field, choice of table Units.
1.2. Units for which data is stored for:
1.2.1. Code unit - a numeric field, which may have values ​​greater than 255, PK;
1.2.2. Name of the unit - a text box with up to 40 characters.
1.2.3. Abbreviation of the unit - a text box with up to 5 characters
1.3. Products for which data is stored for:
1.3.1. Item code - a numeric field integer, PK;
1.3.2. Name of item - a text field 60 characters;
1.4. The relationship between the entities Products and Details (consumption) is described in a table of costs that contains the following columns:
1.4.1. Item code - select from table Products;
1.4.2. Code of detail contained in the article - choice of table details;
1.4.3. Amount of investment detail - integer required for entry without unique.
2. To define the primary key of a table of calculation, taking into account that the same component can be incorporated into various products, and an article can comprise more than one piece.
3. Describe the relations between the tables.
4. To create screen forms for the four tables.
5. Please fill in details:
5.1. Five detail (Table Details)
5.2. Three units (Table Units);
5.3. Three products (Table Products);
5.4. Two consumption levels, each with three parts (Table Cost norms).

This is the task guys.
If you can do it send it to my skype: niks_1328

[pbaldy]

I deleted your duplicate posts/thread. Please don't post the same question multiple times. It's unlikely you'll find somebody to do your homework for you. Many of us will help with specific things you get stuck on.