Question: Database and Project Management Module 3: Creating Queries Assignment 2 PART 1 Using the database, you created for Module 2, add/modify or edit the following

Database and Project Management Module 3: Creating Queries Assignment 2 PART 1 Using the database, you created for Module 2, add/modify or edit the following information: 1. Order the Staff and Client Table alphabetically. 2. Create a Category Table CategoryID Category Tip A Adoption Assign CategoryID as Primary Key D Divorce EP Estate Planning G Guardianship PA Prenuptial Agreements AN Annulments S Separation Agreements 3. Create Rates Table RateID Rate Tip 1 $200 Assign RateID as Primary Key 2 $250 3 $300 4 $350 5 $400 4. Create Billing Table For the Hours Field use Field Type Number. Field Size Double. Decimal Places 2 BillingID ClientID BillingDate Category ID Hours RateID StaffID Tip AutoNumber 3 08/01/2018 A 1.0 3 1 Assi

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 General Management Questions!