Please Make this assignment on (access)

Tracking system at Avis car rental agency

Including mandatory:

1. Describe the business environment and key business operations crown. In the description of the tables (at least four tables) fields, the main fields Description of the connections between the tables 2 Create a file Access the system: a. Create the system Back-end access includes the connections between the tables Fill in the records eg Create two queries related to the business process you opened in Section 1. At #4 (clinic): patient list, equipment list in clinic 2. At #11 (follow-up scores):average score for each student, number of courses completed by each student.

Includes an example to illustrate.

Examples of table design:

Example - gym

You are required to create a website for the "Long Life" gym. The institute advertises itself online to encourage new arrivals as well as encourage healthy living. In a mountain room, two different camps are held by different guides. The main people in the gym (the system users) are the coaches. Tonai Institute of Holistic Therapists Director of Institute Schedules:

* Table of the number of employees. Employee Name, Appointment Date, Address, Phone, Cell Email Customer Table Customer Number Customer Name, Join Date, Address, Phone, Cell Phone, Email, Lesson Type

Class schedule number department class name, opening date, end date, number days of the week, class cost Class teacher number table managed number class

Customer circles table: customer number and department number

Database on access about Tracking system at Avis car rental agency