Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

MGIS 3310: Assignment 1: Create a Business Database using Microsoft Access 2013 (100 points = 10%)FOR HOW-TOs, READ THESE TUTORIALS FIRST:How to use MS Access: http://www.fgcu.edu/support/office2007/access/index.aspTo create tables: https://www.youtube.com/watch?v=p_I54RvlYUUTo create forms: https://www.youtube.com/watch?v=Rj0ZBLlbsRcTo create queries: https://www.youtube.com/watch?v=QRQhBVF-6NgFor query criteria: http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspxTo create a relationship between tables: https://www.youtube.com/watch?v=mEkOWAEF-nQ1. Create the following two tables. (10 pts.)Create fields and their properties as follows. Manually enter the data on page 2 into these tables.Customers TableOrders TableCustomer No (Primary Key) (formatted as autonumber)First Name (shorttext)Last Name (shorttext)City (shorttext)State (shorttext)Number of Purchases (number)Total Amount of Purchases (currency)Date of Last Purchase (date/time)Order No (Primary key) (autonumber)Customer No (number)Total Price (currency)Order Date (date/time)2. Create a form for Customers table by using Form Wizard. Include all the fields. (10 pts.)Using this new Customers form, enter the following two additional customers:ooAmy Adam, Houston, TX, 5, $2500, 8/15/2011John Doe, Austin, TX, 10, $3500, 3/15/20113. Create the following queries. (10 pts. each) ** You need to review the query links listed above. **3.1 Display Last Name, City, State, and Number of Purchases of all customers. Sort the results by State in descendingorder. (Result: all seven customers)3.2 Display First Name and Last Name of all customers whose city is unavailable in the data. (Result: Claudia Julie)3.3 Display Last Name, City, State, and Number of Purchases of all TX customers who have purchased more than 4times between 7/1/2011 and 9/1/2011. (Result: Adam)3.4 Display Last Name, City, State, and Number of Purchases of all customers who EITHER have purchased more than4 times OR made the last purchase after 7/1/2011. (Result: Julie, Adam, and Doe)3.5 Display Last Name, City, State, and Number of Purchases of all TX customers who EITHER have purchased morethan 4 times OR made the last purchase after 7/1/2011. (Result: Adam and Doe)Note: You will need to create a relationship between the two tables in order to create the following queries, because theyinclude columns from both tables (unlike the above queries including only columns from Customers table). Therelationship is One-to-Many based on Customer No (the common column), because one customer can have many orders.3.6 Display Order No, Customer No, First Name, Last Name, City, State, and Total Price of all TX customers. Total priceof the selected order must be greater than or equal to 2000. (Result: no one)3.7 Display Order No, Customer No, First Name, and Total Price of all customers EITHER whose second letter of the firstname is the letter a OR whose Total price is greater than 100. (Result: Mike, Kamphol, Pam, and Sanjay)4. Create a report for any one of the above queries by using Report Wizard. (10 pts.) Data for Customers and Orders tablesNOTE: It is OK if your numbers in the autonumber columns are different (e.g. 6 instead of 7).HOW TO SUBMITClick Assignment 1 link in Blackboard, and then on the next screen click “Browse My Computer”.Select the database file of this assignment (.accdb file), and then click Submit.

MGIS 3310: Assignment 1: Create a Business Database using Microsoft Access 2013 (100 points = 10%)FOR HOW-TOs, READ THESE TUTORIALS FIRST:How to use MS Access: http://www.fgcu.edu/support/office2007/access/index.aspTo create tables: https://www.youtube.com/watch?v=p_I54RvlYUUTo create forms: https://www.youtube.com/watch?v=Rj0ZBLlbsRcTo create queries: https://www.youtube.com/watch?v=QRQhBVF-6NgFor query criteria: http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspxTo create a relationship between tables: https://www.youtube.com/watch?v=mEkOWAEF-nQ1. Create the following two tables. (10 pts.)Create fields and their properties as follows. Manually enter the data on page 2 into these tables.Customers TableOrders TableCustomer No (Primary Key) (formatted as autonumber)First Name (shorttext)Last Name (shorttext)City (shorttext)State (shorttext)Number of Purchases (number)Total Amount of Purchases (currency)Date of Last Purchase (date/time)Order No (Primary key) (autonumber)Customer No (number)Total Price (currency)Order Date (date/time)2. Create a form for Customers table by using Form Wizard. Include all the fields. (10 pts.)Using this new Customers form, enter the following two additional customers:ooAmy Adam, Houston, TX, 5, $2500, 8/15/2011John Doe, Austin, TX, 10, $3500, 3/15/20113. Create the following queries. (10 pts. each) ** You need to review the query links listed above. **3.1 Display Last Name, City, State, and Number of Purchases of all customers. Sort the results by State in descendingorder. (Result: all seven customers)3.2 Display First Name and Last Name of all customers whose city is unavailable in the data. (Result: Claudia Julie)3.3 Display Last Name, City, State, and Number of Purchases of all TX customers who have purchased more than 4times between 7/1/2011 and 9/1/2011. (Result: Adam)3.4 Display Last Name, City, State, and Number of Purchases of all customers who EITHER have purchased more than4 times OR made the last purchase after 7/1/2011. (Result: Julie, Adam, and Doe)3.5 Display Last Name, City, State, and Number of Purchases of all TX customers who EITHER have purchased morethan 4 times OR made the last purchase after 7/1/2011. (Result: Adam and Doe)Note: You will need to create a relationship between the two tables in order to create the following queries, because theyinclude columns from both tables (unlike the above queries including only columns from Customers table). Therelationship is One-to-Many based on Customer No (the common column), because one customer can have many orders.3.6 Display Order No, Customer No, First Name, Last Name, City, State, and Total Price of all TX customers. Total priceof the selected order must be greater than or equal to 2000. (Result: no one)3.7 Display Order No, Customer No, First Name, and Total Price of all customers EITHER whose second letter of the firstname is the letter a OR whose Total price is greater than 100. (Result: Mike, Kamphol, Pam, and Sanjay)4. Create a report for any one of the above queries by using Report Wizard. (10 pts.) Data for Customers and Orders tablesNOTE: It is OK if your numbers in the autonumber columns are different (e.g. 6 instead of 7).HOW TO SUBMITClick Assignment 1 link in Blackboard, and then on the next screen click “Browse My Computer”.Select the database file of this assignment (.accdb file), and then click Submit.

MGIS 3310: Assignment 1: Create a Business Database using Microsoft Access 2013 (100 points = 10%)FOR HOW-TOs, READ THESE TUTORIALS FIRST:How to use MS Access: http://www.fgcu.edu/support/office2007/access/index.aspTo create tables: https://www.youtube.com/watch?v=p_I54RvlYUUTo create forms: https://www.youtube.com/watch?v=Rj0ZBLlbsRcTo create queries: https://www.youtube.com/watch?v=QRQhBVF-6NgFor query criteria: http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspxTo create a relationship between tables: https://www.youtube.com/watch?v=mEkOWAEF-nQ1. Create the following two tables. (10 pts.)Create fields and their properties as follows. Manually enter the data on page 2 into these tables.Customers TableOrders TableCustomer No (Primary Key) (formatted as autonumber)First Name (shorttext)Last Name (shorttext)City (shorttext)State (shorttext)Number of Purchases (number)Total Amount of Purchases (currency)Date of Last Purchase (date/time)Order No (Primary key) (autonumber)Customer No (number)Total Price (currency)Order Date (date/time)2. Create a form for Customers table by using Form Wizard. Include all the fields. (10 pts.)Using this new Customers form, enter the following two additional customers:ooAmy Adam, Houston, TX, 5, $2500, 8/15/2011John Doe, Austin, TX, 10, $3500, 3/15/20113. Create the following queries. (10 pts. each) ** You need to review the query links listed above. **3.1 Display Last Name, City, State, and Number of Purchases of all customers. Sort the results by State in descendingorder. (Result: all seven customers)3.2 Display First Name and Last Name of all customers whose city is unavailable in the data. (Result: Claudia Julie)3.3 Display Last Name, City, State, and Number of Purchases of all TX customers who have purchased more than 4times between 7/1/2011 and 9/1/2011. (Result: Adam)3.4 Display Last Name, City, State, and Number of Purchases of all customers who EITHER have purchased more than4 times OR made the last purchase after 7/1/2011. (Result: Julie, Adam, and Doe)3.5 Display Last Name, City, State, and Number of Purchases of all TX customers who EITHER have purchased morethan 4 times OR made the last purchase after 7/1/2011. (Result: Adam and Doe)Note: You will need to create a relationship between the two tables in order to create the following queries, because theyinclude columns from both tables (unlike the above queries including only columns from Customers table). Therelationship is One-to-Many based on Customer No (the common column), because one customer can have many orders.3.6 Display Order No, Customer No, First Name, Last Name, City, State, and Total Price of all TX customers. Total priceof the selected order must be greater than or equal to 2000. (Result: no one)3.7 Display Order No, Customer No, First Name, and Total Price of all customers EITHER whose second letter of the firstname is the letter a OR whose Total price is greater than 100. (Result: Mike, Kamphol, Pam, and Sanjay)4. Create a report for any one of the above queries by using Report Wizard. (10 pts.) Data for Customers and Orders tablesNOTE: It is OK if your numbers in the autonumber columns are different (e.g. 6 instead of 7).HOW TO SUBMITClick Assignment 1 link in Blackboard, and then on the next screen click “Browse My Computer”.Select the database file of this assignment (.accdb file), and then click Submit.

MGIS 3310: Assignment 1: Create a Business Database using Microsoft Access 2013 (100 points = 10%)FOR HOW-TOs, READ THESE TUTORIALS FIRST:How to use MS Access: http://www.fgcu.edu/support/office2007/access/index.aspTo create tables: https://www.youtube.com/watch?v=p_I54RvlYUUTo create forms: https://www.youtube.com/watch?v=Rj0ZBLlbsRcTo create queries: https://www.youtube.com/watch?v=QRQhBVF-6NgFor query criteria: http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspxTo create a relationship between tables: https://www.youtube.com/watch?v=mEkOWAEF-nQ1. Create the following two tables. (10 pts.)Create fields and their properties as follows. Manually enter the data on page 2 into these tables.Customers TableOrders TableCustomer No (Primary Key) (formatted as autonumber)First Name (shorttext)Last Name (shorttext)City (shorttext)State (shorttext)Number of Purchases (number)Total Amount of Purchases (currency)Date of Last Purchase (date/time)Order No (Primary key) (autonumber)Customer No (number)Total Price (currency)Order Date (date/time)2. Create a form for Customers table by using Form Wizard. Include all the fields. (10 pts.)Using this new Customers form, enter the following two additional customers:ooAmy Adam, Houston, TX, 5, $2500, 8/15/2011John Doe, Austin, TX, 10, $3500, 3/15/20113. Create the following queries. (10 pts. each) ** You need to review the query links listed above. **3.1 Display Last Name, City, State, and Number of Purchases of all customers. Sort the results by State in descendingorder. (Result: all seven customers)3.2 Display First Name and Last Name of all customers whose city is unavailable in the data. (Result: Claudia Julie)3.3 Display Last Name, City, State, and Number of Purchases of all TX customers who have purchased more than 4times between 7/1/2011 and 9/1/2011. (Result: Adam)3.4 Display Last Name, City, State, and Number of Purchases of all customers who EITHER have purchased more than4 times OR made the last purchase after 7/1/2011. (Result: Julie, Adam, and Doe)3.5 Display Last Name, City, State, and Number of Purchases of all TX customers who EITHER have purchased morethan 4 times OR made the last purchase after 7/1/2011. (Result: Adam and Doe)Note: You will need to create a relationship between the two tables in order to create the following queries, because theyinclude columns from both tables (unlike the above queries including only columns from Customers table). Therelationship is One-to-Many based on Customer No (the common column), because one customer can have many orders.3.6 Display Order No, Customer No, First Name, Last Name, City, State, and Total Price of all TX customers. Total priceof the selected order must be greater than or equal to 2000. (Result: no one)3.7 Display Order No, Customer No, First Name, and Total Price of all customers EITHER whose second letter of the firstname is the letter a OR whose Total price is greater than 100. (Result: Mike, Kamphol, Pam, and Sanjay)4. Create a report for any one of the above queries by using Report Wizard. (10 pts.) Data for Customers and Orders tablesNOTE: It is OK if your numbers in the autonumber columns are different (e.g. 6 instead of 7).HOW TO SUBMITClick Assignment 1 link in Blackboard, and then on the next screen click “Browse My Computer”.Select the database file of this assignment (.accdb file), and then click Submit.

testimonials icon
System’s Attribute and their DefinitionsSoftware interface descriptionMessage Exchange be...
testimonials icon
PART 1: DEVELOPING AN EVALUATION PLAN   Details: Using 800-1,000 words, discuss...
testimonials icon
Modigliani and Miller: A Challenge to Capital Budgeting Strategies Financing corporate purchases and overall capital budgeting usua...
testimonials icon
  Choose an organization according to the following:Current employerMost recent or former em...
testimonials icon
/*! elementor - v3.6.5 - 27-04-2022 */ .elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
testimonials icon
Complete Table-1 (Joseph Farms, Inc., Cost and Revenue Data), either as a Microsoft Excel spreadsheet, or as a Microsoft Word table. Assume that the...
testimonials icon
 Sociology came into existence in the 19th century to explain the enormous changes occasioned by the Industrial Revolution, urbanization, a...
testimonials icon
Prepare a 3-5 page paper on the implications for voting, lotteries, certificate issuance, security auditin...
testimonials icon
Running head: COMPUTER SCIENCE QUESTIONSComputer Science QuestionsStudents NameInstitution1COMPUTER SCIENCE QUESTIONS2Question 1A notebook laptop com...
testimonials icon
The hardest part about growing up is letting go of what you were accustomed to, and moving on. As...
testimonials icon
/*! elementor - v3.6.5 - 27-04-2022 */ .elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
testimonials icon
Darlene Cook Company engaged in the following transactions during the month of July:July 1 Acquired land for $10,000. The company paid cash.8 B...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65