Create a new database and save it using the standard online


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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Create a new database and save it using the standard online
Reference No:- TGS0136924

Expected delivery within 24 Hours