Question

In: Computer Science

using Access show step by step how to create a table for ID (data type number...

using Access

show step by step how to create a table for ID (data type number and field size 10) and discount (data type number where 1=5% and 2=10%)

one table with two fields (id and discount)

Solutions

Expert Solution

Hello There, Thanks for Asking to answer. I hope you are safe and doing well.In this answer i am providing you the step by step procedure for creating a table in MS Access. If You Have any query feel free to ask in the comments.

  1. Download and install ms office from the official microsoft website.
  2. after installation open the ms access.
  3. Create a database by clicking on the blank database as shown in the image.                                                                                                                                                                                                                                                                                                                                                                                    
  4. click on the name if you want to rename it or on the file if you want to store it in the prefered location otherwise leave it as it is.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
  5. After creating the database select the data type option as shown in the image.                                                                                                                                                                                                                                                                                                                  
  6. Choose number as Datatype and After selecting it your field will be created.To rename it Just double click on the field label.                                                                                                                                                                                                                                
  7. To add the field size just click on the design view located in the bottom-right corner of your screen it will also ask you to save your table before going in the design view.                                                                                                                                                                                                                           
  8. Now you can change your field size as defind in the genral menu.                                                                                                                                                                                                                                                                                                                                 

I hope the above solution fulfiled your needs.However, If you think you need furthur help or classification do let me know in the comments and if you think this solution helped you then please upvote this answer.

Thanks,Happy Learning!!!.                                                                                                                                            


Related Solutions

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,...
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
Create a class named Salesperson. Data fields for Salesperson include an integer ID number and a...
Create a class named Salesperson. Data fields for Salesperson include an integer ID number and a doubleannual sales amount. Methods include a constructor that requires values for both data fields, as well as get and set methods for each of the data fields. Write an application named DemoSalesperson that declares an array of 10 Salesperson objects. Set each ID number to 9999 and each sales value to zero. Display the 10 Salesperson objects. public class DemoSalesperson { public static void...
What would be a good Access SQL data type for a Phone Number field?
What would be a good Access SQL data type for a Phone Number field? 
Create a crosstab table of frequencies from the data containing case id, age, sex, and marital...
Create a crosstab table of frequencies from the data containing case id, age, sex, and marital status, using an Excel pivot table. A crosstab is a table showing the relationship between two or more variables. When the table shows the relationship between two categorical variables, a crosstab is also known as a contingency table or a two-way table. Format the data as number with 1000 separator. Please outline step by step how to create the pivot table in Microsoft Excel...
The data in the table show the number of pounds of bananas sold per week at...
The data in the table show the number of pounds of bananas sold per week at a grocery store when the banana display was positioned in the produce, milk, and cereal sections of the store. a) Perform a one-way ANOVA using alphaαequals=0.05 to determine if there is a difference in the average number of pounds of bananas sold per week in these three locations. b) If warranted, perform a multiple comparison test to determine which pairs are different using alphaαequals=0.050...
In this create a code that will drop a student by ID number //////////////////////////////////////////////////////////////////////// import java.util.Scanner;...
In this create a code that will drop a student by ID number //////////////////////////////////////////////////////////////////////// import java.util.Scanner; public class COurseCom666 {     private String courseName;     private String [] students = new String[1];     private int numberOfStudents;     public COurseCom666(String courseName) {         this.courseName = courseName;     }     public String[] getStudents() {         return students;     }     public int getNumberOfStudents() {         return numberOfStudents;     }     public String getCourseName() {         return courseName;     }     public void...
Create a schematic to show the step by step progression of joint faulting distress in a...
Create a schematic to show the step by step progression of joint faulting distress in a JPCP section of rigid pavement.
Thanks for the step by step instructions A. Using the Table of Standard Reduction Potentials table...
Thanks for the step by step instructions A. Using the Table of Standard Reduction Potentials table shown below, what is the standard cell potential for an electrochemical cell that has iron (Fe) and magnesium (Mg) electrodes? Also, identify the cathode. B. What is the standard cell potential for a voltaic cell using the Pb2+/Pb and Mg2+/Mg half-reactions? Which metal is the cathode? (Use the Standard Reduction Potentials table shown below) C. What is the standard cell potential for a voltaic...
using the data below create a time-phased budget for the project. Show how much daily and...
using the data below create a time-phased budget for the project. Show how much daily and cumulative costs of a project is, just as monthly and cumulative costs are shown in figure 10. WBS Activity Intermediate Predecessor Duration in Weeks Resource Hourly cost Hours per week 1 Operational definition 1.1 Research literature 3 Becky $35 30 1.2 Identify and define terms 1.1 1 Ann $60 30 1.3 Obtain approval of definition 1.2 2 Clive $50 30 2 Target selection 2.1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT