Description
Unformatted Attachment Preview
LAB 8_ Assignment
Part 1 Creating a FORM:
(1) Open the Access Database “Bright Lights Inc. Sales Information”
(2) Create a FORM over the “Sales Reps” table.
(3) Save the FORM and name it “Sales Reps Form”
(4) Change the Form Header Section to “Sales Reps Information”.
(5) Add a Label in the Footer Section that says “All Rights Reserved Bright Lights Inc.”
(6) Open the Properties on each Label in the Form and change the Fore Color to Black.
(7) Advance the Form to Rep ID 2, and change the First Name to Maryann.
(8) Close the FORM and open the “Sales Reps” table and verify that Rep ID 2 has the First Name of
Maryann in the “Sales Reps” table.
Part 2 Creating a Table with a Composite Key:
(9) In Design View, create the following FIELD NAMES in the “Sales Managers” table, using the
following Data Types and Descriptions:
Field Name:
Data Type:
Description:
Record ID
AutoNumber
Record ID Number
Manager ID
Text
Manager ID
Last Name
Text
Manager’s Last Name
First Name
Text
Manager’s First Name
Date Hired
Date/Time
Manager's Hire Date
Region
Text
Sales Region
Note: The RECORD ID Field should be a Primary Key Field and the Index should say “Yes (No Duplicates).
Page 1 of 2
Note: The Manager ID Field should be a Primary Key Field and the Index should say “Yes (No
Duplicates). Also the Field Size should be 5.
Note: The Field Size for Last Name should be 30.
Note: The Field Size for First Name should be 30.
Note: The Field Size for Region should be 30.
(10) In the Datasheet View, key the following records into the “Sales Managers” table.
Sales Managers
Record ID Manager ID
1 11123
2 11124
3 11125
Last Name First Name
Franklin
Thomas
Brown
Judith
Johnson
Calvin
Date Hired
Region
8/8/2011 West
9/5/2011 East
5/16/2011 South
Page 2 of 2
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Just what I needed. Studypool is a lifesaver!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Royal Holloway University MathLab Worksheet
This assignment, exercises 1, 2, 3, 4 and 6 require you to write functions, exercise 6 also requires you to write a script ...
Royal Holloway University MathLab Worksheet
This assignment, exercises 1, 2, 3, 4 and 6 require you to write functions, exercise 6 also requires you to write a script. For this assignment you will have to submit:o A file containing function myplotarea required for exercise 1. o A file containing function membersplot required for exercise 2. o A file containing function plottrigs required for exercise 3. o A file containing function myplot required for exercise 4. o A file containing script docdistances required for exercise 5. o A file containing script PCAEx6 required for exercise 6. o A file containing function subtractMean required for exercise 6. o A file containing function myPCA required for exercise 6. o A file containing function projectData required for exercise 6. The following files are provided for the exercises: o A file pointsEx1.txt required for exercise 1.o A file plot_properties.mat required for exercise 4.o A file pcadata.mat required for exercise 6.o A file pcafaces.mat required for exercise 6.o A file containing a function recoverData.mat required for exercise 6.o A file containing a function displayData.mat required for exercise 6.o Six files containing text of RedRidingHood.txt, PrincessPea.txt, Cinderella.txt, CAFA1.txt, CAFA2.txt and CAFA3.txt required for exercise 6.
HFCC Conduct a Network Traffic Analysis Lab Manual Deliverables
Assignment Instructions
For this Assignment, complete Lab 7 (Deliverables 1–2: 1- to 3-page text file) and write a 2- to ...
HFCC Conduct a Network Traffic Analysis Lab Manual Deliverables
Assignment Instructions
For this Assignment, complete Lab 7 (Deliverables 1–2: 1- to 3-page text file) and write a 2- to 3-page memo that answers Lab Assessment Questions and Answers numbers 3, 7, 8, and 9.
By Day 7
Submit a zip file containing your memo and lab manual Deliverables 1–2.
Javascript application , assignment help
I am really confused about Javascript coding . What is the best software that I can to code using Javascript ? I need ...
Javascript application , assignment help
I am really confused about Javascript coding . What is the best software that I can to code using Javascript ? I need a serious tutor to handle this.
9 pages
Automobile Java Solution
Pseudo code and flowcharts and finished code for Automobile class To complete the code given, some of which is valid code ...
Automobile Java Solution
Pseudo code and flowcharts and finished code for Automobile class To complete the code given, some of which is valid code and some pseudo code that ...
For Prof_Baron
Specific Instructions for Assignment 4:For this assignment, you will add a third page to your website named "table.html" a ...
For Prof_Baron
Specific Instructions for Assignment 4:For this assignment, you will add a third page to your website named "table.html" and code a table on that page. You will also add code to your CSS file to format your table.1) Create a new HTML file in your text editor and name the file "table.html". Just like last week, your new file should contain all of the same basic code that is in the head section of your home page. The body section will contain your new table, which you will create by following the remaining steps of this assignment. After coding all of the basic required HTML tags in your new file, save your new file and validate it using the HTML validator: https://validator.w3.org/#validate_by_upload. Debug and fix any errors identified by the validator until your file passes validation.2) Make sure the external CSS style sheet you created in Assignment 2 is linked into your new "table.html" file with the <link> tag in the head section of the file. Your website should only have 1 CSS file, and that same file should be linked into all HTML pages of your website.3) Modify your navigation menu on your home page and your "about.html" page by adding a link to this new page. Then add your navigation menu to your new "table.html" file, so that users can navigate to your other pages from this new page.4) In your table.html file, add the following code:Create a table using the <table> tag. Your table must have a row of headings and at least three rows and three columns of data. Use the <tr>, <th>, and <td> tags appropriately. You can see examples of the code for HTML tables here: https://www.w3schools.com/html/html_tables.asp5) In your HTML file, give your table a caption, using the <caption> tag. You can read about adding a caption to your table here: https://www.w3schools.com/html/html_tables.aspOpen your CSS file in your text editor and complete the following steps:6) In your CSS file, set the "width" property for the <table> element, using percentage rather than pixels. You can read about setting table width here: https://www.w3schools.com/css/css_table.asp7) In your CSS file, give your table a background color that is different from the background color of the body of your webpage. Use the "background-color" property. You can read about table colors here: https://www.w3schools.com/css/css_table.asp8) In your CSS file, set the "border-style", "border-width", and "border-color" properties for the <table>, <th>, and <td> elements. Remember that all three of these properties can be set in the same line of code using the "border" shorthand property. You can read about the CSS border properties here: https://www.w3schools.com/css/css_border.asp9) To avoid double borders, set the "border-collapse" property to indicate that table borders should be collapsed into a single border. You can read more about collapsing table borders here: https://www.w3schools.com/css/css_table.asp10) Set the CSS "padding" property for your table header <th> and table data <td> cells. You can read about adding cell padding here: https://www.w3schools.com/html/html_tables.asp11) Set the horizontal alignment of your table header <th> and table data <td> cells, using the "text-align" property. Set the vertical alignment of your table header <th> and table data <td> cells, using the "vertical-align" property. Even if you like the default settings of these properties, make sure you explicitly set each of these properties for both your table header <th> and table data <td> cells in your CSS file, to demonstrate your understanding of how to set these properties. You can read about horizontal alignment and vertical alignment here: https://www.w3schools.com/css/css_table.aspHint: You can find examples of all of the HTML elements and CSS properties required for this assignment in the Week 4 module in the Lessons area of the classroom.Before submitting your web site:Validate all HTML files at https://validator.w3.org/#validate_by_upload, using the "Validate by File Upload" option, and fix any errors that the validator identifies before submitting your web site for grading.Validate your CSS file at https://jigsaw.w3.org/css-validator/#validate_by_upload, using the "Validate by File Upload" option, and fix any errors that the validator identifies before submitting your web site for grading.Note: It is critical that you debug and fix ALL errors identified by these two code validators before submitting your assignments. Contact your instructor for assistance if you are having difficulty debugging and fixing your errors because it is imperative that your code files pass validation.Submission Instructions: Create a zip file containing all files related to your web page (.html files, .css file, image files, and/or multimedia files). Make sure you maintain the necessary directory structure in your zip file so that your webpages will view correctly when unzipped. In other words, if your images are in a sub-folder on your computer, in relation to the folder containing your .html file, then you need to maintain that same directory structure in your zip file, too. Submit only the zip file for grading.Rubric for Grading AssignmentPointsWebpages (HTML files) validate without errors at https://validator.w3.org/#validate_by_upload10Style sheet (CSS file) validates without errors at https://jigsaw.w3.org/css-validator/#validate_by_upload10Website contains well-written, well-thought-out, creative, attractive, and well-organized content (uses paragraph, line break, heading tags, and horizontal rules appropriately to organize content)5Correct use of all basic elements in a webpage document (Ex: DOCTYPE, html, head, body, meta, title, link, etc.) on every HTML page5Consistent navigation menu on all pages of your website, using local hyperlinks (coded with relative paths)5CSS style sheet containing appropriate formatting for your website, linked into all HTML pages on your website5Table contains data or information appropriate for display with a table and is logically organized in the table10Correct use and correct embedding of table, table row, table header, and table data tags10Table contains appropriate caption, correctly specified with table caption tag5Table contains appropriate column and/or row headings, correctly specified with table header tags5Table, table headers, and table data cells contains appropriate border, specified with the border shorthand property in CSS, and the border-collapse property5Table header and table data cells contain an appropriate horizontal and vertical alignment, specified in CSS5CSS correctly used to specify an appropriate amount of padding around the content in your table header and table data cells5Table contains an appropriate background color, specified in CSS5Table width is specified in CSS (using percentage instead of pixels)5Correctly created zip file that contains all files for webpage (maintaining original folder structure)5Total100***Note: Your website must include the required table, as specified in the instructions above, to receive any credit for this assignment. Websites submitted without a table will not receive credit.
Similar Content
RE: JavaScript Front-End Web Application
The results pages for the past elections need to be separated so each can have unique titles, descriptions, and candidate ...
Harvard University Programming Asymptotic Notation Questions
Please find attached ...
CS 110 West Virginia University Towers of Hanoi Java Program
I need help with this homework, it shouldn't take long time, all the info are in the pdf, be sure to send me a zip file an...
ISOL 634 UCumberlands Physical Security in a Small Community Bank Branch Report
Subject : physical security (ISOL - 634)Discussion(Due TODAY Thursday 7pm EST): The focus of your time this week is on the...
MySQL Question
Week 1 Questions
EmployeeInfo Table:
EmpID
EmpFname
EmpLname
Department
Project
Address
DOB
Gender
1
Sanjay
Mehr...
IT Code Repositories and Version Control Tools
Research and define code repositories and version control tools. Answer the following point:What are they used for? What...
Python Work
Yes, we can clearly see the time difference. The iteration is much faster than the The next number is found by adding up t...
Report
The system composed of mass, spring and damper can be shown by the following mathematical This is a system with no input a...
First Part
First, we made a transition matrix, as given below A12 = 1 * max(pr-pd,0) represents the switching behavior from Repub...
Related Tags
Book Guides
Girl in Translation
by Jean Kwok
A Portrait of the Artist as a Young Man
by James Joyce
Heart of Darkness
by Joseph Conrad
Breakfast at Tiffanys
by Truman Capote
Little Fires Everywhere
by Celeste Ng
Death Of A Salesmen
by Arthur Miller
The Second Sex
by Simone de Beauvoir
The Lost Man
by Jane Harper
To Kill a Mockingbird
by Harper Lee
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Royal Holloway University MathLab Worksheet
This assignment, exercises 1, 2, 3, 4 and 6 require you to write functions, exercise 6 also requires you to write a script ...
Royal Holloway University MathLab Worksheet
This assignment, exercises 1, 2, 3, 4 and 6 require you to write functions, exercise 6 also requires you to write a script. For this assignment you will have to submit:o A file containing function myplotarea required for exercise 1. o A file containing function membersplot required for exercise 2. o A file containing function plottrigs required for exercise 3. o A file containing function myplot required for exercise 4. o A file containing script docdistances required for exercise 5. o A file containing script PCAEx6 required for exercise 6. o A file containing function subtractMean required for exercise 6. o A file containing function myPCA required for exercise 6. o A file containing function projectData required for exercise 6. The following files are provided for the exercises: o A file pointsEx1.txt required for exercise 1.o A file plot_properties.mat required for exercise 4.o A file pcadata.mat required for exercise 6.o A file pcafaces.mat required for exercise 6.o A file containing a function recoverData.mat required for exercise 6.o A file containing a function displayData.mat required for exercise 6.o Six files containing text of RedRidingHood.txt, PrincessPea.txt, Cinderella.txt, CAFA1.txt, CAFA2.txt and CAFA3.txt required for exercise 6.
HFCC Conduct a Network Traffic Analysis Lab Manual Deliverables
Assignment Instructions
For this Assignment, complete Lab 7 (Deliverables 1–2: 1- to 3-page text file) and write a 2- to ...
HFCC Conduct a Network Traffic Analysis Lab Manual Deliverables
Assignment Instructions
For this Assignment, complete Lab 7 (Deliverables 1–2: 1- to 3-page text file) and write a 2- to 3-page memo that answers Lab Assessment Questions and Answers numbers 3, 7, 8, and 9.
By Day 7
Submit a zip file containing your memo and lab manual Deliverables 1–2.
Javascript application , assignment help
I am really confused about Javascript coding . What is the best software that I can to code using Javascript ? I need ...
Javascript application , assignment help
I am really confused about Javascript coding . What is the best software that I can to code using Javascript ? I need a serious tutor to handle this.
9 pages
Automobile Java Solution
Pseudo code and flowcharts and finished code for Automobile class To complete the code given, some of which is valid code ...
Automobile Java Solution
Pseudo code and flowcharts and finished code for Automobile class To complete the code given, some of which is valid code and some pseudo code that ...
For Prof_Baron
Specific Instructions for Assignment 4:For this assignment, you will add a third page to your website named "table.html" a ...
For Prof_Baron
Specific Instructions for Assignment 4:For this assignment, you will add a third page to your website named "table.html" and code a table on that page. You will also add code to your CSS file to format your table.1) Create a new HTML file in your text editor and name the file "table.html". Just like last week, your new file should contain all of the same basic code that is in the head section of your home page. The body section will contain your new table, which you will create by following the remaining steps of this assignment. After coding all of the basic required HTML tags in your new file, save your new file and validate it using the HTML validator: https://validator.w3.org/#validate_by_upload. Debug and fix any errors identified by the validator until your file passes validation.2) Make sure the external CSS style sheet you created in Assignment 2 is linked into your new "table.html" file with the <link> tag in the head section of the file. Your website should only have 1 CSS file, and that same file should be linked into all HTML pages of your website.3) Modify your navigation menu on your home page and your "about.html" page by adding a link to this new page. Then add your navigation menu to your new "table.html" file, so that users can navigate to your other pages from this new page.4) In your table.html file, add the following code:Create a table using the <table> tag. Your table must have a row of headings and at least three rows and three columns of data. Use the <tr>, <th>, and <td> tags appropriately. You can see examples of the code for HTML tables here: https://www.w3schools.com/html/html_tables.asp5) In your HTML file, give your table a caption, using the <caption> tag. You can read about adding a caption to your table here: https://www.w3schools.com/html/html_tables.aspOpen your CSS file in your text editor and complete the following steps:6) In your CSS file, set the "width" property for the <table> element, using percentage rather than pixels. You can read about setting table width here: https://www.w3schools.com/css/css_table.asp7) In your CSS file, give your table a background color that is different from the background color of the body of your webpage. Use the "background-color" property. You can read about table colors here: https://www.w3schools.com/css/css_table.asp8) In your CSS file, set the "border-style", "border-width", and "border-color" properties for the <table>, <th>, and <td> elements. Remember that all three of these properties can be set in the same line of code using the "border" shorthand property. You can read about the CSS border properties here: https://www.w3schools.com/css/css_border.asp9) To avoid double borders, set the "border-collapse" property to indicate that table borders should be collapsed into a single border. You can read more about collapsing table borders here: https://www.w3schools.com/css/css_table.asp10) Set the CSS "padding" property for your table header <th> and table data <td> cells. You can read about adding cell padding here: https://www.w3schools.com/html/html_tables.asp11) Set the horizontal alignment of your table header <th> and table data <td> cells, using the "text-align" property. Set the vertical alignment of your table header <th> and table data <td> cells, using the "vertical-align" property. Even if you like the default settings of these properties, make sure you explicitly set each of these properties for both your table header <th> and table data <td> cells in your CSS file, to demonstrate your understanding of how to set these properties. You can read about horizontal alignment and vertical alignment here: https://www.w3schools.com/css/css_table.aspHint: You can find examples of all of the HTML elements and CSS properties required for this assignment in the Week 4 module in the Lessons area of the classroom.Before submitting your web site:Validate all HTML files at https://validator.w3.org/#validate_by_upload, using the "Validate by File Upload" option, and fix any errors that the validator identifies before submitting your web site for grading.Validate your CSS file at https://jigsaw.w3.org/css-validator/#validate_by_upload, using the "Validate by File Upload" option, and fix any errors that the validator identifies before submitting your web site for grading.Note: It is critical that you debug and fix ALL errors identified by these two code validators before submitting your assignments. Contact your instructor for assistance if you are having difficulty debugging and fixing your errors because it is imperative that your code files pass validation.Submission Instructions: Create a zip file containing all files related to your web page (.html files, .css file, image files, and/or multimedia files). Make sure you maintain the necessary directory structure in your zip file so that your webpages will view correctly when unzipped. In other words, if your images are in a sub-folder on your computer, in relation to the folder containing your .html file, then you need to maintain that same directory structure in your zip file, too. Submit only the zip file for grading.Rubric for Grading AssignmentPointsWebpages (HTML files) validate without errors at https://validator.w3.org/#validate_by_upload10Style sheet (CSS file) validates without errors at https://jigsaw.w3.org/css-validator/#validate_by_upload10Website contains well-written, well-thought-out, creative, attractive, and well-organized content (uses paragraph, line break, heading tags, and horizontal rules appropriately to organize content)5Correct use of all basic elements in a webpage document (Ex: DOCTYPE, html, head, body, meta, title, link, etc.) on every HTML page5Consistent navigation menu on all pages of your website, using local hyperlinks (coded with relative paths)5CSS style sheet containing appropriate formatting for your website, linked into all HTML pages on your website5Table contains data or information appropriate for display with a table and is logically organized in the table10Correct use and correct embedding of table, table row, table header, and table data tags10Table contains appropriate caption, correctly specified with table caption tag5Table contains appropriate column and/or row headings, correctly specified with table header tags5Table, table headers, and table data cells contains appropriate border, specified with the border shorthand property in CSS, and the border-collapse property5Table header and table data cells contain an appropriate horizontal and vertical alignment, specified in CSS5CSS correctly used to specify an appropriate amount of padding around the content in your table header and table data cells5Table contains an appropriate background color, specified in CSS5Table width is specified in CSS (using percentage instead of pixels)5Correctly created zip file that contains all files for webpage (maintaining original folder structure)5Total100***Note: Your website must include the required table, as specified in the instructions above, to receive any credit for this assignment. Websites submitted without a table will not receive credit.
Earn money selling
your Study Documents