In the Access portion of the travel project, create a database file that contains a table of data, three queries, and one report. The table will list potential customers/travelers that may attend an upcoming seminar about the travel destination.
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.
Create a new table called Interested Travelers - [Your Name] within your travel database. Include the following 8 fields:
Customer ID (Use the AutoNumber field type and make this your primary key field.)
Customer Name (Use the contact names from both sheets of your Excel travel project; you will have 12 customers.)
Address (make these up)
City (Use at least 3 different cities)
State
Zip (make these up)
Gender (Vary the gender of your customers)
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.)
Two more fields of your choice. You determine the name, field type, and information that go into these two fields.
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.
Fields: Customer Name, Address, City , State, and Zip
Query for all customers who are from one city (you determine the city)
Male Customers
Fields: Customer Name, City, and Gender
Query for all customers who are male
Seminar Attendees
Fields: Customer Name, City, Gender, and Attending Seminar
Query for all who plan to attend the seminar (Yes)
Create a report using the Report Wizard feature that contains the following information:
Customer Name, Address, City, Gender, and Attending Seminar fields
Use landscape orientation
Add the title of your choice and include your name in the title
You determine the other options.
Check your spelling, proofread, and save the objects as described above.
Zip the Access database file (NOT the lock file) and submit to your faculty member.