There is no word limit and the names can be made up for the database, my travel destination is Laos
1. Create a new database and save it using the standard online filename convention: your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date.
2. Create a new table called Interested Travelers - [Your Name] within your travel database. Include the following 8 fields:
o Customer ID (Use the AutoNumber field type and make this your primary key field.)
o Customer Name (Use the contact names from both sheets of your Excel travel project; you will have 12 customers.)
o Address (make these up)
o City (Use at least 3 different cities)
o State
o Zip (make these up)
o Gender (Vary the gender of your customers)
o Attending seminar (An optional seminar is being offered to inform travelers about the vacation location and how to prepare. Make this a Yes/No data type of field. Indicate that some of the customers will attend and some won't.)
o Two more fields of your choice. You determine the name, field type, and information that go into these two fields.
3. Create the three queries below. Save each query with its respective name as indicated below.
Customers from [City] (Substitute the name of the city you use.
o Fields: Customer Name, Address, City , State, and Zip
o Query for all customers who are from one city (you determine the city)
Male Customers
o Fields: Customer Name, City, and Gender
o Query for all customers who are male
Seminar Attendees
o Fields: Customer Name, City, Gender, and Attending Seminar
o Query for all who plan to attend the seminar (Yes)
4. Create a report using the Report Wizard feature that contains the following information:
o Customer Name, Address, City, Gender, and Attending Seminar fields
o Use landscape orientation
o Add the title of your choice and include your name in the title
o You determine the other options.
5. Check your spelling, proofread, and save the objects as described above.