Question: I need help with this Mircrosoft Access project. Thank you so much. 2 ADDITIONAL CASE Tracking Animal Licenses and U Citations OBIECHIVES Create table relations







I need help with this Mircrosoft Access project. Thank you so much.
2 ADDITIONAL CASE Tracking Animal Licenses and U Citations OBIECHIVES Create table relations Greate select query wizar Create forms using wizards a dCase |North River Residences custo Greate.Calculated controls[in arms Leslie Fong is the office manager in the Animal Control depart- ment at North River Residences, a residence for seniors on 100 acres of land with accommodation for 6,000 residents. Residents must purchase licenses for their pets, and North River Residences issues citations for animal infractions on its property. Among her responsibilities, Leslie coordinates issuing licenses for the residents pets and processing citations for on-site infractions. Budget reduc- tions have forced her department to reduce the number of part-time workers. As a result, the department is experiencing an increase in the backlog for processing citations and pet licensing requests. ot createa custom report e Create an unbound formm create macros Create a navigation form Set database properties and startup options In this case you will use skills you learned in the followin tutorials: Pet licenses for dogs and cats are issued to residents. A license must be visible on the pet's collar, and must be renewed annually. Each license request form must include the license number, animal type, and the resident's name. With each license, the resident receives a brochure that describes the North River Residences animal regula- tions and the fines for viglations of these regulations. Tutorials 1-11 and 12 (startup options only The animal control department is within the security department. The security department employs guards who maintain a secure facility and issue citations for violations including those related to the pet regulations. Each animal citation includes the citation number, the date and time of the violation, and a description of the violation. For animals with licenses, the citation includes the license number and the type of animal. For animals without licenses, the citation includes the animal type but not the license number. Leslie's staff also tracks payments for the fines levied with the citations Leslie needs to create a database that will allow her to track and update the animal licenses and citations. Leslie's initial database contains three tables: tblLicense, tblCitation, and tblPayment. STARTING DATA FILES AddCases AnimalLicense.accdb 2 ADDITIONAL CASE Tracking Animal Licenses and U Citations OBIECHIVES Create table relations Greate select query wizar Create forms using wizards a dCase |North River Residences custo Greate.Calculated controls[in arms Leslie Fong is the office manager in the Animal Control depart- ment at North River Residences, a residence for seniors on 100 acres of land with accommodation for 6,000 residents. Residents must purchase licenses for their pets, and North River Residences issues citations for animal infractions on its property. Among her responsibilities, Leslie coordinates issuing licenses for the residents pets and processing citations for on-site infractions. Budget reduc- tions have forced her department to reduce the number of part-time workers. As a result, the department is experiencing an increase in the backlog for processing citations and pet licensing requests. ot createa custom report e Create an unbound formm create macros Create a navigation form Set database properties and startup options In this case you will use skills you learned in the followin tutorials: Pet licenses for dogs and cats are issued to residents. A license must be visible on the pet's collar, and must be renewed annually. Each license request form must include the license number, animal type, and the resident's name. With each license, the resident receives a brochure that describes the North River Residences animal regula- tions and the fines for viglations of these regulations. Tutorials 1-11 and 12 (startup options only The animal control department is within the security department. The security department employs guards who maintain a secure facility and issue citations for violations including those related to the pet regulations. Each animal citation includes the citation number, the date and time of the violation, and a description of the violation. For animals with licenses, the citation includes the license number and the type of animal. For animals without licenses, the citation includes the animal type but not the license number. Leslie's staff also tracks payments for the fines levied with the citations Leslie needs to create a database that will allow her to track and update the animal licenses and citations. Leslie's initial database contains three tables: tblLicense, tblCitation, and tblPayment. STARTING DATA FILES AddCases AnimalLicense.accdb
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
