I am working in a Final Project in Microsoft Access.
I have to create a Data base with multiple steps and I need some help on where to start.
These are the directions on what we need on the database
After your design is completed and correct, you will create a database using Microsoft Access. Deliverables will include: • Multiple tables (no more than four table). • One form - The form should be used to enter in student transactions. • Four queries - the queries will address the following questions: 1. What trips begin and end in August? 2. Which students are going to which destination (students can go to multiple)? 3. What are the most popular destinations? 4. Who has paid deposits for which trips greater than $1000? • One report - Your report will display the amount of money owed for each trip by each student by using a calculated field...
The information that we need to use for the Database is as followed:
Background College students often like to volunteer to help others. They also enjoy traveling to interesting destinations. Those two factors inspired the owners of Volunteer Vacations to create a company that combined both. Volunteer Vacations organizes vacations for college students to destinations in the United States and across the world. Each vacation has a purpose to help people, animals, or nature. Students can choose from trips to help at camps in the United States for disabled or low-income children, or they can take trips to Sri Lanka to build homes for orphans. If a student likes nature, he or she can work on nature conservation in New Zealand or work to protect the golden lion tamarin, or a monkey in Brazil. Housing is provided for all trips and meals are provided on some. The total cost of the trip will not include the flights. Volunteer Vacations started as a small company and is growing rapidly. You have been hired to create a database to keep track of the trips each summer, all the students who sign up for the trips, and what trips they sign up to take