JC Consulting database tables:

1. Categories ( Category )

2. Client ( ClientID, CientName, Street, Zip, Government )

3. Employees ( EmployeeID, LastName, FirstName, HireDate, Title, Salary )

4. ProgectLineItems ( ProgectLineItemsID, ProjectID, TaskID, TaskDate, Quantity, Factor, ProgectLineItemsNotes )

5. Projects ( ProgectID, ProgectStart, ClientID, EmployeeID,ProgectNotes )

6. TaskMasterList ( TaskID, Description, CategoryID, Per, Estimate )

7. Zips ( City, Zip )

What is the notation for each of the seven current tables in the JC Consulting database?

Examine the Employees table. Note that the data in the Title field contains redundant values and therefore is a candidate for a one-field lookup table. Use your Access Query Design View or SQL skills to create a lookup table named Titles with the unique values in the Title field of the Employees table. List the steps you performed to create the lookup table.

Identify the steps you would take to create a one-field table named Titles that could be used to constrain the values in the Title field of the Employees table to the existing values in that field.

The ProjectsAndLineItems query currently uses the ProjectID field from the Projects table. Explain why that field cannot be edited in Query Datasheet View.

What type of backup schedule and process would you recommend for JC Consulting?

What type of compact and repair schedule would you recommend for JC Consulting?

Is it as important for a small business like JC Consulting to have a disaster recovery plan as it is for a large corporation? Please site three different examples to support your position.

How might JC Consulting use the cloud?

Identify the characteristics of the business problem that lends itself to an Access solution.

As JC Consulting grows, they may need to convert their Access application into technologies that can handle more users and locations. What solution stacks would you recommend they consider?

Answer rating: 100% (QA)

Solution Categories Table Notation Table Name Categories Fields Category Primary Key Client Table Notation Table Name Client Fields ClientID Primary Key ClientName Street Zip Government Employees Tabl... View the full answer