Design Database Application, Computer Science Assignment Help

Assignment Task

1.    Midwest Executive Professionals is a firm that connects professional job seekers with job openings. You work in the Research Department of Midwest Executive Professionals as a research analyst. You are developing an Access database application to help manage and analyze companies, jobs, applicants, and job placements facilitated by your company.

In this project, you will improve an existing database by modifying tables, queries, forms, and reports.

Open the JobSeekers table in Design View and complete the following:

a.    After the existing Phone field add a new field named Email with a Hyperlink data type.
b.    Add a second new field named Comments with a Long Text data type. 

Save and close the JobSeekers table

2.    Open the Jobs table in Design View and complete the following:

a.    Add Salary as the caption property to the StartingSalary field.
b.    Add >=Date() as the Validation Rule property for the PostingDate field.
c.    Add Date must be on or after today as the Field Validation Text property for the PostingDate field.

Save and close the Jobs table. If prompted to test data integrity click Yes.

3.    Open the Companies table in Design View and complete the following:

a.    Use the Lookup Wizard to lookup values for the Industry field.
b.    The lookup field should get its values from the Industries table.
c.    Select the Industry field and sort the records in ascending order by the Industry field.
d.    Widen the Industry field to get the best fit for all of the values in the list.
e.    Enable data integrity on the relationship and use Industry as the label for the lookup field.
f.    Save the table if prompted

This Computer Science Assignment has been solved by our Computer Science experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.