6. Use the Form Wizard to create a new form for inputting sales data. a. Include all the fields from the Sales table. b. Include the Item and Quantity fields from the SaleDetails table. c. View the form data by records in the Sales table with related records in the SaleDetails table displayed in a subform. d. The subform should be displayed as a Datasheet. e. Name the main form: SalesForm and name the subform: SaleDetailsSubform (Hint: Be sure to remove the space between SaleDetails and Subform in the subform name suggested by Access.) f. Open the form in Form view to review your work. g. Navigate to the record in the main form for SaleID 3 and enter sale details in the subform as follows: Item: Truffle, Quantity: 4 Item: Old Bay, Quantity: 2 h. Close the form.
Added by Destiny M.
Close
Step 1
Open Microsoft Access and navigate to the Form Wizard. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 65 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
2. Create a database named "school.mdb" and perform the following tasks: a. Create a table named "student info" having following table structure. Field Name | Data type | Description Class | Number | Section | Text | Roll no | Number | Name | Text | 40 characters long Status | Look up wizard | Two value: "senior", "junior" Photo | OLE object | Photos of students DOB | Date/time | Date of birth of students Remarks | Memo | b. Fill at least 5 records. c. Prepare a query to display all records and Name should be in ascending order. d. Prepare a query named "senior" to display records including fields name, class, sec, roll no, status, photo and value of "status" field must be senior. e. Prepare a form of above query "senior". f. Prepare a report of all the fields of above table.
Madhur L.
Create a form (frmUpdateMedia), write a VBA code to extract the data and display it in a listbox, dropdownbox or any form of grid. Integrate the spreadsheet data into the application. HINT: the spreadsheet can contain any special list such as new DVDs or updated notes. Write a code to update your inventory table, which can be a CD list or DVD list, from the list. HINT: for the update (the easy way), delete the current records and then insert the records from the spreadsheet. Extra credit advanced way: compare each record. If it is new, add it to the table. If it already exists, update the info from the spreadsheet. If you are going to do this option, please indicate it in the student comments so we can look for it. Make sure you upload the spreadsheet with the database.
Supreeta N.
Use the Query Wizard to create a crosstab query using the Cap2 Inventory table. Set the Supplier ID field as the row headings, and set the Department field as the column headings. Sum the Quantity field, and do not include row sums. Name the query Cap2 Crosstab Query and then finish the query. Run the query and apply Best Fit to all of the fields. Save and close the query. 3.5 16 Create a query in Design view using the Cap2 Inventory table that prompts you to enter the Department, and then answers the question, "What is the department, item name, and Cost for inventory items, sorted first in ascending order by Department and then in ascending order by the item name?" Add the fields in that order. The query should prompt an individual to enter the Department. Run the query, and type "Face & Neck" when prompted for the criteria. Five records match the criteria. Save the query as Cap2 Parameter Query and close it. 3.5
Akash M.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD