Access_1B_Student_Workshops

jobe_GO19_AC_CH01_GRADER_1B_HW.zip

Home >Computer Science homework help >Access_1B_Student_Workshops

jobe_Access_1B_Student_Workshops.accdb

ID	Title	Start Time	End Time	Location	Description	Attachments

ID	Object Type	Object Name	Filter Name	Filter String	Sort String	Default	Description	mSysRowId
1	2	Event List	Start Time = Today	(Year([Current Events].[Start Time])=Year(Date()) AND Month([Current Events].[Start Time])=Month(Date()) AND Day([Current Events].[Start Time])=Day(Date()))		false		ac/mFxRIYPt39yoOhUB1aSyYK5tg9iEo2MohDqvqBx0=-~jOL5SzKP69uBfpbP+fpd7A==
2	2	Event List	Start Time = This Week	(Year([Current Events].[Start Time])=Year(Date()) AND DatePart("ww",[Current Events].[Start Time],0)=DatePart("ww",Date(),0))		false		ac/mFxRIYPt39yoOhUB1aSyYK5tg9iEo2MohDqvqBx0=-~jOL5SzKP69uBfpbP+fpd7A==

ID	mSysRowId
1	CZtWbP9j4i0yTBQAoLng21gkcwXN8UztLsiDRxCmkjw=-~y5qrlbNTZ4C5rpsofgeR9Q==

ID	ShowWelcome	mSysRowId
1	false

SELECT "-1" as [ID], "(Manage Filters)" as [Filter Name] FROM Filters UNION SELECT "0" as [ID], "(Clear Filter)" as [Filter Name] FROM Filters UNION SELECT ID, [Filter Name] FROM Filters WHERE ((([Object Name])=[Application].[CurrentObjectName])) ORDER BY [Filter Name];

SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Not Like "*Subreport*") AND ((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name;

SELECT DISTINCTROW * FROM Settings;

SELECT * FROM Events WHERE (((Events.[End Time])>=(DateAdd("h",-24,Now())) Or (Events.[End Time]) Is Null));

GO19_AC_CH01_GRADER_1B_HW_Instructions.docx

Grader - Instructions Access 2019 Project

GO19_AC_CH01_GRADER_1B_HW - Student Workshops 1.1

Project Description:

Instructional project 1B Student Workshops Database

Steps to Perform:

Step	Instructions	Points Possible
1	Start Access. Open the file Student_Access_1B_Student_Workshops.accdb downloaded with this project. Then, in your textbook, turn to Project 1B and complete all of the steps in Activities 1.19-1.25.	0
2	Complete Activity 1.19 Building a Table by Entering Records in a Multiple-Items Form and a Single-Record Form.	24
3	Complete Activity 1.20 Appending Records by Importing from an Excel Spreadsheet.	14
4	Complete Activity 1.21 Grouping Database Objects in the Navigation Pane.	10
5	Complete Activity 1.22 Using the Table Tool to Create a New Table.	18
6	Complete Activity 1.23 Entering Records into a New Table. Save the table as 1B Workshop Locations without including your own name.	30
7	Complete Activity 1.24 Viewing a Report	4
8	Save and close the database, and then submit for grading.	0

Total Points

100

Created On: 07/11/2019 1 GO19_AC_CH01_GRADER_1B_HW - Student Workshops 1.1

a01B_Workshops.xlsx

Student Workshops

Title	Start Time	End Time	Location	Description
Transferring to a 4-Year University	4/8/23 11:00 AM	4/8/23 12:30 PM	Northeast Campus	Transfer
Financial Aid	4/14/23 7:00 PM	4/14/23 8:30 PM	Southeast Campus	CC Info
Sensitivity Training	4/15/23 8:00 AM	4/15/23 9:00 AM	Northwest Campus	Human Behavior
Preparing for the Job Interview	4/15/23 12:30 PM	4/15/23 2:00 PM	Northwest Campus	Job Skills
Class Note Taking	4/18/23 12:30 PM	4/18/23 1:30 PM	Southeast Campus	Study Skills
Managing Time and Stress	4/18/23 6:00 PM	4/18/23 7:30 PM	Southwest Campus	Study Skills
Work Smart at Your Computer	4/20/23 10:00 AM	4/20/23 11:00 AM	Northeast Campus	Computer Skills
Preparing for Tests	4/20/23 4:00 PM	4/20/23 5:00 PM	Southeast Campus	Study Skills