Using Microsoft Access

Add the following fields to the table:$$TripID$,$ TripName, NumberOfDays, DepartureCity, DestinationCity, DepartureDate, and CostPerPerson.

The TripID should use an AutoNumber data type and be the primary key. Select appropriate data types for the other fields.Save the table as$$Trips$.$

Edit the field properties, like Field Size, to match the needs of the database.

Enter at least $5$ records into the table for cruises of various lengths. Search the web if you need help finding examples of data to enter.

Change the layout as desired to create a professional$-$looking layout.

Create a filter using compound criteria to locate all cruises that leave from a select city and have the same trip length.