Question

using access, how do you create a table with a field called discount where 1=5% and 2=6%?

screenshot how to steps with microsoft access

Answer 1

Using microsoft access, how do you create a table with a field called discount where 1=5% and 2=6%?

(Note: I have cropped some unwanted area.)

(Note: zoom-in to see the screenshot clearly)

Answers:

1.     

Open your Access,click New and select Blank database.That will open a datasheet like the above image.

2.   

Now to add field, if you click the "click to Add", it will show a drop-down box with list of datatypes you can select the datatype according to your needs for the field. Here I selected Number datatype.

3.   

After selecting the datatype it will automatically ask you to enter the field name. There you can type the name for the fields. I gave the field name as discount(%).

4.

After giving the field name you can enter the record value. You just type the values in the record as it will automatically starts to give ID numbers starting from 1. Here I gave the value as 5.( Note: As I gave the field name as discount(%) I just entered the record values as 5 and 6)

  

5.    

Then now add the second value.This procedure is carried out for all.

If you want to rename ID to some other name, just click on ID you can see the insertion point, then start renaming. You can edit the field names by just clicking on that names.

____________________________________________________________________________________________

I hope this will be useful for you. If you have any doubt ask it in comment box.

Have a nice day

____________________________________________________________________________________________