Order ID | 2609131293 |
Subject | |
Topic | Activity: Creating a Table in MS Access |
Type | Essay |
Writer level | High School |
Style | APA |
Sources / references | 1 |
Language | English(U.S.) |
Description / paper instructions
Using Access, create the table that you described for the company you chose for the Module Two discussion. Include a minimum of seven fields.
Be sure to appropriately label the data types and give appropriate titles to the metadata (fields). Input two data records into the table. Create a Word document that contains a description of the completed table. Be sure to include the company name and why the company would use this table, along with the table name, fields, and data types of each field. Submit both the Word document and the Access file (.accdb) as individual files, but include both files in the same submission. |
Spacing | Double |
Pages | 1 |
Order ID | 8125537848 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Subject | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Topic | Final Project milestone one begin work | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Type | Essay | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Writer level | High School | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Style | APA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sources / references | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Language | English(U.S.) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Description / paper instructions
Written components of the project must follow these formatting guidelines when applicable: double spacing, 12-point Times New
Roman font, and one-inch margins. The paper should be 1 to 3 pages in length, not including screen shots, diagrams, cover page and resources, and written in paragraph form. Your milestone draft at a minimum should be at least one page in length that directly addresses the questions. This will ensure your instructor has sufficient information to provide you useful feedback that will help you as you redraft and create your final project. IT 200 Milestone One Guidelines and Rubric
Scenario: A new owner has purchased Swagger Distribution Company, a company that distributes clothing and apparel. She does not have experience with IT-related problem solving, so she is contracting you, as an IT consultant, to help.
For Milestone One, you will submit a document summarizing the human-computer interface (HCI) and information management/database (IMD) using appropriate IT terminology. Take a moment to read the Final Project Guidelines and Rubric, specifically sections I and II, to see how the following information applies to the final project, and then proceed to do the following for Milestone One:
Human-Computer Interface (HCI): On a daily basis, Swagger Distribution’s employees log in to the company’s network and utilize many different types of software and the internet. They use Microsoft Word and Microsoft Visio daily.
For this area of the assignment:
Summary – Summarize the human–computer interactions (HCI) problem the company is experiencing. Be sure to list all aspects of the problem and explain their importance to the usability of the software. For example, you might identify components of Microsoft Office applications such as Word or Visio, discussing all aspects of the HCI and explaining their importance to the usability of this software.
Recommendation – Suggest an enhancement to one of the applications for improving its HCI, providing supporting examples/research for your suggestion.
Illustration – Create a one-page tutorial for Microsoft Visio, including component screenshots, for new employees who are familiar with Microsoft Word but have never used Microsoft Visio. To comprehensively address this element, you should cover at least two basic functions and/or menu options.
Identification – Use fundamental IT terminology to label components in the tutorial and appropriately in the summary. To comprehensively address this element, you would label at least five components in the tutorial.
Databases: Swagger Distribution’s partners/customers include a variety of clothing companies. Swagger Distribution utilizes a database to store information on the partner companies and the orders that are received. You will review the provided database for Swagger Distribution and summarize what the tables contain and what the queries do. Be sure to apply key terms that you have learned such as “metadata.” Based on information provided, you will change one data type in one of the tables.
For this area of the assignment: Open up each table in the database to look at the data and examine its formatting. Be sure to open each table in regular view and design view.
Describe each table, the information it stores, and any data types present other than text.
Open up the table “Clothing Products” in design view. Change the data type of the “Retail Price” field from “text” to “Currency.” Now reopen the table “Clothing Products” in design view and notice the change. Provide a description of your actions and the results.
Open up the table “Retail Stores.” Make selections for each retailer in the “Clothing Item” field. Now close the table. Re-run the query “Retail Purchases.” Describe what these results represent. Add a screenshot of your results to your final submission for this milestone (Note: This screenshot should also reflect the changes you made when changing the “text“ data type to “currency”).
Rubric
Guidelines for Submission: Written components of the project must follow these formatting guidelines when applicable: double spacing, 12-point Times New Roman font, and one-inch margins. The paper should be 1 to 3 pages in length, not including screen shots, diagrams, cover page and resources, and written in paragraph form. Your milestone draft at a minimum should be at least one page in length that directly addresses the questions. This will ensure your instructor has sufficient information to provide you useful feedback that will help you as you redraft and create your final project.
IT 200 Access Activity Guidelines and Rubric
Creating and working with data tables is the foundation for using Microsoft Access. For this activity, you will create a MS Access table that would be appropriate for a real company. Using the company that you discussed in the Module Two discussion, create an example of one table of data that the company might have with seven relevant data fields that it might collect for that table. For example, every bank has a table that contains all customer personal information, including last name, first name, social security number, account number, street address, city, state, and ZIP code.
Specifically, the following critical elements must be addressed:
Create a table in MS Access with a minimum of seven fields and the correct data type for each. Input two rows of data records into the table.
Create a Word document that contains a description of the completed table. Be sure to include the company name and why the company would use this table, along with the table name, fields, and data types of each field.
Submit the completed table (MS Access file) and the Word file as individual files, but in the same submission.
Guidelines for Submission: The Microsoft Access activity should follow these formatting guidelines: A Word document that is one page maximum with 12-point Times New Roman font and one-inch margins.
|
Spacing | Double |
Pages | 1 |