New Perspectives Access 365/2021 | Modules 1-4: SAM Capstone Project 1b

Описание: Hire Me For Complete Course , Assignments & Exams==================
For Help Contact Me on=========================================
WhatsApp:+923466480850
WhatsAppLink: https://wa.link/2a6jcc
Email: [email protected]

New Perspectives Access 365/2021 | Modules 1-4: SAM Capstone Project 1b #newperspectives #modules1-4

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences and Many more We will help you with weekly quizzes, assignments, exams, thesis writing, Dissertation writing and Technical Writing.


1. The Southeast County Library System currently includes a main library and nine branch libraries. You work in the Information Technology department for the county and are developing an Access database application to help manage the employees who work for the library system.

Open the Branches table in Design View, and then modify the table as follows:
a. After the Street field, add a new field named Website with the Hyperlink data type.
b. Use BranchID to rename the ID field.

Save and close the Branches table.
2. Open the Positions table in Datasheet View, and then complete the following tasks:
a. Delete the record for Library Intern (PositionID 5).
b. Edit Children's Librarian to be Youth Librarian for PositionID 7.
c. Enter a new record into the table using the information in Table 1.

Close the Positions table.
Table 1: New Record for the Positions Table

PositionID 18
Title Archivist
Description Manages historical documents and materials.
MinQualifications BA

3. In the Navigation Pane, make Facilities the new name for the Locations table.
4. Use the Import Spreadsheet Wizard to import the data from the Support_AC365_2021_CS1-4b_Locations.xlsx file, and then append the data to the Facilities table. Do not save the Import steps. (Hint: If a warning message appears, click Open.)
5. Create a new table in Design View with the following options:
a. Add a new field named PTEmpID with the AutoNumber data type. Set it as the primary key field.
b. Add two new fields named PTFirst and PTLast in that order. They should have the Short Text data type and field size properties of 25.
c. Add a new field named Email with the Hyperlink data type. Set the Required property to Yes.
d. Add a new field named HourlyRate with the Currency data type. Set the Default Value property to 15.
e. Save the table using PartTimeEmployees as the table name.
f. Add a new field named CellPhone with the Short Text data type. Save the table again, and then update the Input Mask property using the Input Mask Wizard. Select the Phone input mask, and then update the field to !(999) 000-0000 so that !\(999") "000\-0000;;_ is the final input. Accept the default in the last window.

Save and close the table.
6. Open the Employees table in Datasheet View, and then complete the following tasks:
a. Delete the SocSecNumber field. (Hint: It currently does not contain any data.)
b. Move the Position field to be the last field in the datasheet.
c. Sort the records in ascending order by the LastName field.

Save and close the Employees table.
7. Using the Employees and Positions tables, create a new query in Design View with the following options:
a. Select the FirstName, LastName, and Salary fields from the Employees table and the Title and MinQualifications fields from the Positions table.
b. Join the tables using the Position field from the Employees table and the PositionID field from the Positions table.
c. Save the query using LowSalaries as the name.
8. With the LowSalaries query still open in Design View, add criteria to select only those records where the salary is less than or equal to 30000.

Save the query, switch to Datasheet View, as shown in Figure 1, and then close it.
Figure 1: Final LowSalaries Query in Datasheet View



9. Use the Simple Query Wizard to create a new query with the following options:
a. Use the Employees and the Branches tables.
b. Select the FirstName, LastName, and HireDate fields from the Employees table and the BranchName field from the Branches table.
c. Use HireDates as the title for the query.

Save and close the query.
10. Open the PositionListing query in Design View, and then modify it as follows:


shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 | module 10: sam project 1b,new perspectives excel 2019 | module 2: sam project 1a,new perspectives word 2019 | module 10: sam project 1a,new perspectives excel 2019 | module 1: end of module project 2,new perspectives excel 2019 module 1 sam project 1a,modules 1-4: sam capstone project 1a,#shelly cashman excel 2019 | module 1: sam project 1b,module 5 sam project 1a