Question

In: Computer Science

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

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

Expert Solution

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

____________________________________________________________________________________________

venereology answered 3 months ago

You have a table called scholar where there are two fields id and create date. You...

You have a table called scholar where there are two fields id and create date. You want to create an ETL process that loads the data from scholar table into the big data platform. What are the different things that you will put on a requirement document for the developer to write code and implement the solution?

Using SQL create a new database called school_app. Create a student table with fields id (auto...

Using SQL create a new database called school_app. Create a student table with fields id (auto increment), first_name, last_name. Create a course table with fields id (auto increment), course code (such as ITC or MTH), and course number (such as 100 or 295). Note that the relationship between student and course is many-to-many (n:m). Create a join table called student_course that implements the n:m relationship with fields id (auto increment), student_id, course_id, and grade (which has values 0, 1, 2,...

I need at least a page. Section #2: Accessing Data Where and how do you access...

I need at least a page. Section #2: Accessing Data Where and how do you access information stored in a Database? Discuss how you use information either at work, school or in your personal life. For example: accessing a product inventory, customer account information, checking the balance or making a deposit in your bank account, etc. What application do you use to reference this information, such as using a web interface to access an XML or MySQL database? Further outline...

1. What are the Discount For Liquidity and the Discount For Control. How do they affect...

1. What are the Discount For Liquidity and the Discount For Control. How do they affect a corporation’s valuation? 2. Consider three firms A, B, and C, all of which have the following financial costs: re= 16% WACC = 12% iL(interest rate on its liabilities) = 6% These three firms have the following profitability measures: A B C ROA 14% 8% 5% ROE 18% 12% 10% For each of these three firms, answer the following questions: Is the overall enterprise...

1. Where do you access the setting configurations for a proxy server within IE? Question 22...

1. Where do you access the setting configurations for a proxy server within IE? Question 22 options: a) LAN settings b) WAN settings c) Network settings d) General settings

Create a query in Access that uses two tables, the Patient table and the Session table. Add

Create a query in Access that uses two tables, the Patient table and the Session table. Add the LastName, FirstName, and SessionDate fields to the query grid. Run the query. How many records are displayed? Delete the join line between the field lists in Query Design View. Rerun the query. How many records are now displayed? Why are the results different? You do not need to save the queries.

how do you access the icf crosswalk database?

in ACL (access control List) : 1.How do you determine who can access object x? 2....

in ACL (access control List) : 1.How do you determine who can access object x? 2. How do you determine which objects user y can access? 3. What happens if a file is deleted?

Using C++, you will create a program, where you will create two doubly linked lists. These...

Using C++, you will create a program, where you will create two doubly linked lists. These doubly linked lists will contain integers within them. Using the numbers in both of these linked lists, you add the numbers together, and insert the addition of the two numbers into a singly linked list. the input can be from the user or you just write the input. for example, if one number in the doubly linked list is 817 and in the other...

Identify the steps you would take to create a one-field table named Titles that could

Identify the steps you would take to create a one-field table named Titles that could be used to constrain the values in the Title field of the Employees table to the existing values in that field.