I have done up to question 7, and i got confused from question 8 ---## Assignment 6: Creating the Babbage Bookkeeping Database### Problem:Babbage Bookkeeping is a local company that provides bookkeeping services to several small businesses in the area. The database consists of two tables:1. **Client table**: contains information on the businesses that use Babbage’s services.2. **Bookkeeper table**: contains information on the bookkeeper assigned to the business.### Instructions:Perform the following tasks:1. Create a new database to store all the objects related to the bookkeeping data.2. Save this database. The database must be named with Your Last Name + First Name + Assignment6. For example, if your name is John Smith, the file must be named: SmithJohnAssignment6. 5% will be deducted for the wrong filename.3. Create the Client table using the structure and data shown in the table below: Save the table as “Client Table.”#### Client Table Structure| Field Name | Data Type | Field Size | Primary Key | Description ||--------------------|-----------|------------|-------------|--------------------------------------|| Client Number | Short Text| 3 | Yes | Client Number (Primary Key) || Client Name | Short Text| 20 | | Name of Client || Address | Short Text| 15 | | Street Address || City | Short Text| 15 | | City || Zip Code | Short Text| 5 | | Zip Code || Balance | Currency | | | Amount Currently Owed for Services || Bookkeeper Number | Short Text| 2 | | Bookkeeper Number |4. Enter the data for the Client Table as shown in the table below:![Client Table Data Entry](https://example.com/client-table-image)5. Create the Bookkeeper table using the structure and data shown in the table below: Save the table as “Bookkeeper Table.”#### Bookkeeper Table Structure| Field Name | Data Type | Field Size | Primary Key | Description ||------------------|-----------|------------|-------------|-------------------------------|| Bookkeeper Number| Short Text| 2 | Yes | Bookkeeper Number (Primary Key)|| Last Name | Short Text| 10 | | Last Name of Bookkeeper || First Name | Short Text ### Task Instructions for Bookkeeper Table and Query Creation#### Step 6:**Enter the Data for the Bookkeeper Table:**Below is the required data for the Bookkeeper Table, as shown in the image provided:![Bookkeeper Table Screenshot](embedded_image.png)---#### Step 7:**Create a Relationship Between Two Tables:**1. Specify referential integrity between the Bookkeeper table (the one table) and the Client table (the many table).2. Save the Relationships.---#### Step 8:**Create the Following Queries:****8.1. Client Table Query:**- **Details:** The query must display the `Client Number`, `Client Name`, and `Balance` fields for all clients located in `Empoer` with a balance greater than $300.00.- **Save As:** `Q21-Client-Empoer Query`**8.2. Client Query Display:**- **Details:** The query should display the `Client Number`, `Client Name`, and `Address` fields for all clients with an address on `Mauv`.- **Save As:** `Q22-Client-Mauv Query`**8.3. Search Query by City:**- **Details:** Create a query that allows the user to enter the city to search when the query is run. The query results should display the `Client Number`, `Client Name`, and `Bookkeeper Number`. Test the query by searching for those records where the client is located in `Portage`.- **Save As:** `Q23-Client-City Query`**8.4. Display Clients in Ascending Order:**- **Details:** Create a query from the Client table to display the cities in ascending order. Each city should appear only once (i.e., no repeating city).- **Save As:** `Q24-City-Sort Query`**8.5. Bookkeeper-Specific Client Query:**- **Details:** Display the `Client Number`, `Client Name`, and `Balance` fields for all clients where the bookkeeper number is 24 or 34 and the balance is greater than $300.00.- **Save As:** `Q25-Client-Bookkeeper24-34 Query`**8.6. Sorted Client-Bookkeeper Query:**- **Details:** Display the `First Name`, `Last Name`, and `Hourly Rate` fields from the Bookkeeper table and the

“Since you have asked multiple questions, we will solve the first question for you. If you want any…

6. Enter the data for the Bookkeeper Table as shown in the table below: BES. • 86 Key Assignments: Database-Nid Document Classes Class-SBS-CABACC.. Changchit, Chuleepom (1) Fie Home Create External Data Tell me what you want to do Calli (e) x cm Rocopy M Database Tools Fields Table selection Advanced Toggle Fiter 0 Relocat New save 2 Replace +60 10 Totals Spelling Mare -1 BTUA Fivd View Pale H. All-X Delicte Clipboard Recordi Find Bookkeeper Table Hourly Rate YTD Camings Click to Add Bookkeeper * 22 Last Name Lewes First Name Johanna Mario Address 25 Cotton City Portage Grant City - Zip Code 59130 58120 $14.50 $19,245.00 Rodriguez 79 Marsden $13.50 $18,745.50 G Wong chol 253 Topper Empor 58216 $14.00 $17,750.25 7. Create a relationship between two tables. Specify referential integrity between the Bookkeeper table (the one table) and the Client table (the many table). Save the Relationships. 8. Create the following queries. 8.1. Create a query for the Client table. The query must display Client Number, Client Name, and Balance fields for all clients located in Empeer, with a balance greater than $300.00. Save the query as "Q21-Client-Empeer Query." 8.2. Create a query to display the Client Number, Client Name, and Address fields for all clients with an address on Maum, Save the query as "Q22-Client-Maum Query." 8.3. Create a query that will allow the user to enter the city to search when the query is run. The query results should display the Client Number, Client Name, and Bookkeeper Number. Test the query by searching for those records where the client is located in Portage. Save the query as "Q23-Client-City Query." 8.4. Create a query from the Client table to display the cities in ascending order. Each city should appear only once (i.e., no repeating city). Save the query as "Q24-City-Sorting Query." 8.5. Create a query to display the Client Number, Client Name, and Balance fields for all clients where the bookkeeper number is 24 or 34 and the balance is greater than $300.00. Save the query as "Q25-Client-Bookkeeper24-34 Query." 8.6. Create a query to display the First Name, Last Name, and Hourly Rate fields from the Bookkeeper table and the Client Number, Client Name, and Balance fields from the Client table. Sort the records in ascending order by bookkeeper's last name and client's name. Save the query as "Q26-Client-Bookkeeper Query." 8.7. Create a query for the Bookkeeper table to display the Bookkeeper Number, First Name, Last Name, and Hourly Rate in the design grid. Create a new field named as "Hour Worked" in this query to calculate the number of hours each bookkeeper has worked (YTD Earnings/Hourly Rate). Display the data in this "Hour Worked" field as a standard number with 0 decimal place and also show this new created field in the Datasheet view Save the query as "Q27- Bookkeeper-Hour Worked Query." 8.8. Create a query to display the following statistics: a. the total balance for all clients - Save the query as "Q28a-Client Total Balance Query." Display Balance field. b. the total balance for each bookkeeper. Save the query as "Q28b-Bookkeeper Total Balance Query." Display Bookkeeper Number and Balance fields. c. the total balance for clients of bookkeeper 22 - Save the query as "Q28c-Client- Bookkeeper22 Balance Query." Display Bookkeeper Number and Balance fields. 8.9. Create the crosstab query as shown in the Figure below: The crosstab groups total of clients' balances by city and bookkeeper number. Save the query as "Q29-City-Bookkeeper Crosstab Query." BR · KeyAnsignment Database-Nid Document ClementClass-SBS-CABAccess 201 Access Amnigament-S85KeyAmignmenhaccob Plcces.. Changchie, Chulerpom (5) Fie Home Creste External Data Database Tools Tell me what you want to do T: Σ Totals K 6 New save Replace Call (ta) X cu Copy File Format Paint apboard 21 Ascending Selection- 11 Descending Advanced- Remove Sort Toggle Filter Sort & Fiter -11 BTUAAA.R. Find Spaling X Deicte Mare Recordi Rela All- Tec Fomalling 34 25 City Bookkeeper Crosstab Query City Total Of Balance - $1,077.50 $1,027.50 Empeer Grant City BATIMA CHAP 35 21 Ascending 1 Descending Remove Sort Sort & Fit 22 24 $577.50 $500.00 $325.30 $722.00 548 25 → Go To Select- Find Ted: Femalling