I need this ASAP please

Tester_123

Main
Similar Questions

Home >Homework Answsers >Computer Science homework help

cis cs

Can someone complete this for me ?

2 years ago
09.09.2024
10

Report issue

files (4)

_Access_1A_Advising1.accdb
GO19_AC_CH01_GRADER_1A_HW_Instructions1.docx
a01A_Students.xlsx
a01A_Faculty_Advisors1.xlsx

_Access_1A_Advising1.accdb

                    ID	
                    mSysRowId
                
                    1	
                    ua06Ftxxo5DT29FEtU6s2GsIH4WBra7Vmm9mzoDmd4hFWmgWHD2q19Uh6gZgjcdYJD5KAfiSoqJNYPVYozboMdrWC5/boC+GqAv6ldlKwK76KrWnq6AoA9zoHkqnmH8kRWOuUZ6tXLQ=-~LyErwg/RbqxliP9sRDATWA==

ID	mSysRowId
1	ua06Ftxxo5DT29FEtU6s2GsIH4WBra7Vmm9mzoDmd4hFWmgWHD2q19Uh6gZgjcdYJD5KAfiSoqJNYPVYozboMdrWC5/boC+GqAv6ldlKwK76KrWnq6AoA9zoHkqnmH8kRWOuUZ6tXLQ=-~LyErwg/RbqxliP9sRDATWA==

GO19_AC_CH01_GRADER_1A_HW_Instructions1.docx

Grader - Instructions Access 2019 Project

GO19_AC_CH01_GRADER_1A_HW - Advising 1.0

Project Description:

Instructional project 1A Advising Database with Two Tables. This project will be completed by following the Activities in the Project A of your GO! textbook. You can use the print or eText version to locate and read the Activity instructions. For the purpose of grading the project you are required to perform the following tasks:

Steps to Perform:

Step	Instructions	Points Possible
1	Start Access. Open the file Student_Access_1A_Advising.accdb downloaded with this project. Then, in your textbook, turn to Project 1A and complete all of the steps in Activities 1.01-1.17.	0
2	Complete Activity 1.01 Using Good Design Techniques to Plan a Database	0
3	Complete Activity 1.02 Starting with a Blank Desktop Database.	0
4	Complete Activity 1.03 Assigning the Data Type and Name to Fields.	10
5	Complete Activity 1.04 Renaming Fields, Changing Data Types, and Setting Field Size in a Table.	4
6	Complete Activity 1.05 Adding a Record to a Table.	10
7	Complete Activity 1.06 Adding Additional Records to a Table.	10
8	Complete Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table.	10
9	Complete Activity 1.08 Deleting a Table Field in Design View.	5
10	Complete Activity 1.09 Adding Field Descriptions and Changing Field Size	9
11	Complete Activity 1.10 Viewing the Primary Key in Design View.	1
12	Complete Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet.	9
13	Complete Activity 1.12 Adjusting Column Widths and Viewing a Table in Print Preview.	0
14	Complete Activity 1.13 Viewing a Table in Print Preview.	0
15	Complete Activity 1.14 Creating a Query by Using the Simple Query Wizard.	10
16	Complete Activity 1.15 Creating a Form.	9
17	Complete Activity 1.16 Creating and Modifying a Report.	11
18	Complete Activity 1.17 Closing a Database and Close Access.	2
19	Save and close the file, and then submit the Access_1A_Advising.accdb database for grading.	0

Total Points

100

Created On: 07/11/2019 1 GO19_AC_CH01_GRADER_1A_HW - Advising 1.0

a01A_Students.xlsx

Sheet1

Student ID	Last Name	First Name	Middle Initial	Address	City	State	Postal Code	Phone	Email	Faculty Advisor ID	Amount Owed
2034834	Telfer	Larry	J	162 Rattlesnake Ln	Red Rock	TX	78662	(512) 555-2017	[email protected]	FAC-2245	402.50
2349535	Vohra	Ashwin	M	316 Lost Cove Dr	Spicewood	TX	78669	(512) 555-0302	[email protected]	FAC-2289	0.00
2583697	McElaney	Cleta	E	13273 Copperfield Dr	Austin	TX	78753	(512) 555-0305	[email protected]	FAC-6543	15.15
3128456	Wall	WenLi	Z	14380 Ceylon Tea Cir	Pflugerville	TX	78660	(512) 555-2329	[email protected]	FAC-2245	0.00
3458632	Caputo	Stephanie	G	1731 Primrose Trl	Round Rock	TX	78665	(512) 555-2330	[email protected]	FAC-8223	0.00
3569325	Thomas	Carlis	A	28A 4th Ave	Smithville	TX	78657	(512) 555-0301	[email protected]	FAC-8223	0.00
3572184	Reid	Carla	N	715 Pampas Ricas Dr	Leander	TX	78641	(512) 555-2026	[email protected]	FAC-6543	1232.00
3586943	Stavish	Joseph	C	660 Bayou Bend Dr	Buda	TX	78610	(512) 555-9360	[email protected]	FAC-2234	26.25
3593653	Hernandez	Anna	R	2132 Mesquite Ln	Georgetown	TX	78626	(512) 555-0301	[email protected]	FAC-6543	896.25
3768532	Alexander	Rebekah	A	218 Chapparral Trl	Dale	TX	78616	(512) 555-1017	[email protected]	FAC-8223	0.00
3852938	Morris	Atonye	O	1172 Buttonwood St	Bastrop	TX	78602	(512) 555-1018	[email protected]	FAC-2289	0.00
3856930	Nguyen	Cong	L	444 E Alamo St	Elgin	TX	78621	(512) 555-1004	[email protected]	FAC-6543	3210.00
4352863	Bradley	Christine	Y	2708 Kickapoo Cavern Dr	Pflugerville	TX	78660	(512) 555-2013	[email protected]	FAC-2245	0.00
4719238	DiAntonio	Avelina	A	1008 Sunset Canyon Dr	Dripping Springs	TX	78620	(512) 555-2319	[email protected]	FAC-6543	0.00
4739502	Alvarez	Eliza	J	3590 Longhorn Trl	Round Rock	TX	78681	(512) 555-2025	[email protected]	FAC-2234	0.00
4769304	Furfy	Jana	E	2107 Edenwood Dr	Austin	TX	78745	(512) 555-2064	[email protected]	FAC-2289	0.00
4852384	Parkhill	James	A	105 E Myrtle St	Liberty Hill	TX	78642	(512) 555-2323	[email protected]	FAC-2245	112.00
5820384	Rose	Edward	N	555 S Blanco St	Lockhart	TX	78644	(512) 555-2019	[email protected]	FAC-8223	16.67
5834924	Kakaulian	Anastasia	B	4822 Turtle Mound Bnd	Austin	TX	78748	(512) 555-2031	[email protected]	FAC-2289	2345.75
5835035	Poon	Laurence	F	263 Caddis Cv	Kyle	TX	78640	(512) 555-0304	[email protected]	FAC-2234	1182.50
5849320	Soltan	Reza	H	5498 Wild Foxglove Rd	Spicewood	TX	78669	(512) 555-9362	[email protected]	FAC-6543	0.00
5860300	Campbell	Daria	I	162 Rockwood Dr	Wimberley	TX	78674	(512) 555-1016	[email protected]	FAC-2289	0.00

_Access_1A_Advising1.accdb

                    ID	
                    mSysRowId
                
                    1	
                    ua06Ftxxo5DT29FEtU6s2GsIH4WBra7Vmm9mzoDmd4hFWmgWHD2q19Uh6gZgjcdYJD5KAfiSoqJNYPVYozboMdrWC5/boC+GqAv6ldlKwK76KrWnq6AoA9zoHkqnmH8kRWOuUZ6tXLQ=-~LyErwg/RbqxliP9sRDATWA==

ID	mSysRowId
1	ua06Ftxxo5DT29FEtU6s2GsIH4WBra7Vmm9mzoDmd4hFWmgWHD2q19Uh6gZgjcdYJD5KAfiSoqJNYPVYozboMdrWC5/boC+GqAv6ldlKwK76KrWnq6AoA9zoHkqnmH8kRWOuUZ6tXLQ=-~LyErwg/RbqxliP9sRDATWA==

GO19_AC_CH01_GRADER_1A_HW_Instructions1.docx

Grader - Instructions Access 2019 Project

GO19_AC_CH01_GRADER_1A_HW - Advising 1.0

Project Description:

Steps to Perform:

Step	Instructions	Points Possible
1	Start Access. Open the file Student_Access_1A_Advising.accdb downloaded with this project. Then, in your textbook, turn to Project 1A and complete all of the steps in Activities 1.01-1.17.	0
2	Complete Activity 1.01 Using Good Design Techniques to Plan a Database	0
3	Complete Activity 1.02 Starting with a Blank Desktop Database.	0
4	Complete Activity 1.03 Assigning the Data Type and Name to Fields.	10
5	Complete Activity 1.04 Renaming Fields, Changing Data Types, and Setting Field Size in a Table.	4
6	Complete Activity 1.05 Adding a Record to a Table.	10
7	Complete Activity 1.06 Adding Additional Records to a Table.	10
8	Complete Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table.	10
9	Complete Activity 1.08 Deleting a Table Field in Design View.	5
10	Complete Activity 1.09 Adding Field Descriptions and Changing Field Size	9
11	Complete Activity 1.10 Viewing the Primary Key in Design View.	1
12	Complete Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet.	9
13	Complete Activity 1.12 Adjusting Column Widths and Viewing a Table in Print Preview.	0
14	Complete Activity 1.13 Viewing a Table in Print Preview.	0
15	Complete Activity 1.14 Creating a Query by Using the Simple Query Wizard.	10
16	Complete Activity 1.15 Creating a Form.	9
17	Complete Activity 1.16 Creating and Modifying a Report.	11
18	Complete Activity 1.17 Closing a Database and Close Access.	2
19	Save and close the file, and then submit the Access_1A_Advising.accdb database for grading.	0

Total Points

100

Created On: 07/11/2019 1 GO19_AC_CH01_GRADER_1A_HW - Advising 1.0

a01A_Students.xlsx

Sheet1

Student ID	Last Name	First Name	Middle Initial	Address	City	State	Postal Code	Phone	Email	Faculty Advisor ID	Amount Owed
2034834	Telfer	Larry	J	162 Rattlesnake Ln	Red Rock	TX	78662	(512) 555-2017	[email protected]	FAC-2245	402.50
2349535	Vohra	Ashwin	M	316 Lost Cove Dr	Spicewood	TX	78669	(512) 555-0302	[email protected]	FAC-2289	0.00
2583697	McElaney	Cleta	E	13273 Copperfield Dr	Austin	TX	78753	(512) 555-0305	[email protected]	FAC-6543	15.15
3128456	Wall	WenLi	Z	14380 Ceylon Tea Cir	Pflugerville	TX	78660	(512) 555-2329	[email protected]	FAC-2245	0.00
3458632	Caputo	Stephanie	G	1731 Primrose Trl	Round Rock	TX	78665	(512) 555-2330	[email protected]	FAC-8223	0.00
3569325	Thomas	Carlis	A	28A 4th Ave	Smithville	TX	78657	(512) 555-0301	[email protected]	FAC-8223	0.00
3572184	Reid	Carla	N	715 Pampas Ricas Dr	Leander	TX	78641	(512) 555-2026	[email protected]	FAC-6543	1232.00
3586943	Stavish	Joseph	C	660 Bayou Bend Dr	Buda	TX	78610	(512) 555-9360	[email protected]	FAC-2234	26.25
3593653	Hernandez	Anna	R	2132 Mesquite Ln	Georgetown	TX	78626	(512) 555-0301	[email protected]	FAC-6543	896.25
3768532	Alexander	Rebekah	A	218 Chapparral Trl	Dale	TX	78616	(512) 555-1017	[email protected]	FAC-8223	0.00
3852938	Morris	Atonye	O	1172 Buttonwood St	Bastrop	TX	78602	(512) 555-1018	[email protected]	FAC-2289	0.00
3856930	Nguyen	Cong	L	444 E Alamo St	Elgin	TX	78621	(512) 555-1004	[email protected]	FAC-6543	3210.00
4352863	Bradley	Christine	Y	2708 Kickapoo Cavern Dr	Pflugerville	TX	78660	(512) 555-2013	[email protected]	FAC-2245	0.00
4719238	DiAntonio	Avelina	A	1008 Sunset Canyon Dr	Dripping Springs	TX	78620	(512) 555-2319	[email protected]	FAC-6543	0.00
4739502	Alvarez	Eliza	J	3590 Longhorn Trl	Round Rock	TX	78681	(512) 555-2025	[email protected]	FAC-2234	0.00
4769304	Furfy	Jana	E	2107 Edenwood Dr	Austin	TX	78745	(512) 555-2064	[email protected]	FAC-2289	0.00
4852384	Parkhill	James	A	105 E Myrtle St	Liberty Hill	TX	78642	(512) 555-2323	[email protected]	FAC-2245	112.00
5820384	Rose	Edward	N	555 S Blanco St	Lockhart	TX	78644	(512) 555-2019	[email protected]	FAC-8223	16.67
5834924	Kakaulian	Anastasia	B	4822 Turtle Mound Bnd	Austin	TX	78748	(512) 555-2031	[email protected]	FAC-2289	2345.75
5835035	Poon	Laurence	F	263 Caddis Cv	Kyle	TX	78640	(512) 555-0304	[email protected]	FAC-2234	1182.50
5849320	Soltan	Reza	H	5498 Wild Foxglove Rd	Spicewood	TX	78669	(512) 555-9362	[email protected]	FAC-6543	0.00
5860300	Campbell	Daria	I	162 Rockwood Dr	Wimberley	TX	78674	(512) 555-1016	[email protected]	FAC-2289	0.00

_Access_1A_Advising1.accdb

                    ID	
                    mSysRowId
                
                    1	
                    ua06Ftxxo5DT29FEtU6s2GsIH4WBra7Vmm9mzoDmd4hFWmgWHD2q19Uh6gZgjcdYJD5KAfiSoqJNYPVYozboMdrWC5/boC+GqAv6ldlKwK76KrWnq6AoA9zoHkqnmH8kRWOuUZ6tXLQ=-~LyErwg/RbqxliP9sRDATWA==

ID	mSysRowId
1	ua06Ftxxo5DT29FEtU6s2GsIH4WBra7Vmm9mzoDmd4hFWmgWHD2q19Uh6gZgjcdYJD5KAfiSoqJNYPVYozboMdrWC5/boC+GqAv6ldlKwK76KrWnq6AoA9zoHkqnmH8kRWOuUZ6tXLQ=-~LyErwg/RbqxliP9sRDATWA==

GO19_AC_CH01_GRADER_1A_HW_Instructions1.docx

Grader - Instructions Access 2019 Project

GO19_AC_CH01_GRADER_1A_HW - Advising 1.0

Project Description:

Steps to Perform:

Step	Instructions	Points Possible
1	Start Access. Open the file Student_Access_1A_Advising.accdb downloaded with this project. Then, in your textbook, turn to Project 1A and complete all of the steps in Activities 1.01-1.17.	0
2	Complete Activity 1.01 Using Good Design Techniques to Plan a Database	0
3	Complete Activity 1.02 Starting with a Blank Desktop Database.	0
4	Complete Activity 1.03 Assigning the Data Type and Name to Fields.	10
5	Complete Activity 1.04 Renaming Fields, Changing Data Types, and Setting Field Size in a Table.	4
6	Complete Activity 1.05 Adding a Record to a Table.	10
7	Complete Activity 1.06 Adding Additional Records to a Table.	10
8	Complete Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table.	10
9	Complete Activity 1.08 Deleting a Table Field in Design View.	5
10	Complete Activity 1.09 Adding Field Descriptions and Changing Field Size	9
11	Complete Activity 1.10 Viewing the Primary Key in Design View.	1
12	Complete Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet.	9
13	Complete Activity 1.12 Adjusting Column Widths and Viewing a Table in Print Preview.	0
14	Complete Activity 1.13 Viewing a Table in Print Preview.	0
15	Complete Activity 1.14 Creating a Query by Using the Simple Query Wizard.	10
16	Complete Activity 1.15 Creating a Form.	9
17	Complete Activity 1.16 Creating and Modifying a Report.	11
18	Complete Activity 1.17 Closing a Database and Close Access.	2
19	Save and close the file, and then submit the Access_1A_Advising.accdb database for grading.	0

Total Points

100

Created On: 07/11/2019 1 GO19_AC_CH01_GRADER_1A_HW - Advising 1.0

a01A_Students.xlsx

Sheet1

Student ID	Last Name	First Name	Middle Initial	Address	City	State	Postal Code	Phone	Email	Faculty Advisor ID	Amount Owed
2034834	Telfer	Larry	J	162 Rattlesnake Ln	Red Rock	TX	78662	(512) 555-2017	[email protected]	FAC-2245	402.50
2349535	Vohra	Ashwin	M	316 Lost Cove Dr	Spicewood	TX	78669	(512) 555-0302	[email protected]	FAC-2289	0.00
2583697	McElaney	Cleta	E	13273 Copperfield Dr	Austin	TX	78753	(512) 555-0305	[email protected]	FAC-6543	15.15
3128456	Wall	WenLi	Z	14380 Ceylon Tea Cir	Pflugerville	TX	78660	(512) 555-2329	[email protected]	FAC-2245	0.00
3458632	Caputo	Stephanie	G	1731 Primrose Trl	Round Rock	TX	78665	(512) 555-2330	[email protected]	FAC-8223	0.00
3569325	Thomas	Carlis	A	28A 4th Ave	Smithville	TX	78657	(512) 555-0301	[email protected]	FAC-8223	0.00
3572184	Reid	Carla	N	715 Pampas Ricas Dr	Leander	TX	78641	(512) 555-2026	[email protected]	FAC-6543	1232.00
3586943	Stavish	Joseph	C	660 Bayou Bend Dr	Buda	TX	78610	(512) 555-9360	[email protected]	FAC-2234	26.25
3593653	Hernandez	Anna	R	2132 Mesquite Ln	Georgetown	TX	78626	(512) 555-0301	[email protected]	FAC-6543	896.25
3768532	Alexander	Rebekah	A	218 Chapparral Trl	Dale	TX	78616	(512) 555-1017	[email protected]	FAC-8223	0.00
3852938	Morris	Atonye	O	1172 Buttonwood St	Bastrop	TX	78602	(512) 555-1018	[email protected]	FAC-2289	0.00
3856930	Nguyen	Cong	L	444 E Alamo St	Elgin	TX	78621	(512) 555-1004	[email protected]	FAC-6543	3210.00
4352863	Bradley	Christine	Y	2708 Kickapoo Cavern Dr	Pflugerville	TX	78660	(512) 555-2013	[email protected]	FAC-2245	0.00
4719238	DiAntonio	Avelina	A	1008 Sunset Canyon Dr	Dripping Springs	TX	78620	(512) 555-2319	[email protected]	FAC-6543	0.00
4739502	Alvarez	Eliza	J	3590 Longhorn Trl	Round Rock	TX	78681	(512) 555-2025	[email protected]	FAC-2234	0.00
4769304	Furfy	Jana	E	2107 Edenwood Dr	Austin	TX	78745	(512) 555-2064	[email protected]	FAC-2289	0.00
4852384	Parkhill	James	A	105 E Myrtle St	Liberty Hill	TX	78642	(512) 555-2323	[email protected]	FAC-2245	112.00
5820384	Rose	Edward	N	555 S Blanco St	Lockhart	TX	78644	(512) 555-2019	[email protected]	FAC-8223	16.67
5834924	Kakaulian	Anastasia	B	4822 Turtle Mound Bnd	Austin	TX	78748	(512) 555-2031	[email protected]	FAC-2289	2345.75
5835035	Poon	Laurence	F	263 Caddis Cv	Kyle	TX	78640	(512) 555-0304	[email protected]	FAC-2234	1182.50
5849320	Soltan	Reza	H	5498 Wild Foxglove Rd	Spicewood	TX	78669	(512) 555-9362	[email protected]	FAC-6543	0.00
5860300	Campbell	Daria	I	162 Rockwood Dr	Wimberley	TX	78674	(512) 555-1016	[email protected]	FAC-2289	0.00

other Questions(10)