Question: Security ID - First Name . Last Name . Hired Date . Per-Day Sale Click to Add. 111-11-111 Syed Sallu 1/21/2021 $50.00 222-22-222 amijd khan

 Security ID - First Name . Last Name . Hired Date

Security ID - First Name . Last Name . Hired Date . Per-Day Sale Click to Add. 111-11-111 Syed Sallu 1/21/2021 $50.00 222-22-222 amijd khan 12/15/2020 $10.00 333-33-333 Ali 12/15/2020 $60.00 + $0.00 fahad Open the file DataBase2 1. Create a Table: Marks:20 A Create a table called Security Guards having the following structure: Books Products Security Guards Task Field Name Data Type Security ID Short Text First Name Short Text Last Name Short Text Hired Date Date/Time Per-Day Salary Currency 2. Create a Report: Marks:20 Use the Report Wizard and choose the Books table to create a report having the following requirements: . Select the Author, Year, ListPrice and Publisher fields. Do not choose any grouping levels. Sort the report by 1) the Year field in descending order and 2) the ListPrice field in ascending order. Choose Tabular layout and Portrait orientation Type Book List as the report's title. 3. Create a Form: Marks:30 Use the Form Wizard and choose the Products table to create a form having the following requirements: Select the ProductID ProductName and Units in Stocks fields. Choose the Columnar layout. Type Product Items as the form's title. Add Background color change the Text Style and drag all column into center. Set the field Security ID as the primary key, Create the social security number input mask for the Security ID field Set the Required field property of the fields Security ID, First Name and Last Name to Yes. Set the Field Size field property of the field Security Number to 11. Set the Field Size field property of the field Last Name to 25. Set the Field Size field property of the field First Name to 25. B. Enter the following data for the Security Guards table: 4. Create Queries: Marks 30 Query 1: List all of the books that are published by Prentice Hall using the Title Year, ListPrice, and Publisher fields of the Books table. Sort the query in descending order according to the ListPrice field. Save this query as Hall Books. Query 2: List all of the books where the Author begins with a H using the ISBN, Title, Author fields of the Books table. Save this query as Authors with a H

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!