forked from eprofessor/MIS342
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Summative10.html
491 lines (371 loc) · 18.7 KB
/
Summative10.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
<!doctype html>
<html lang="en">
<head>
<title>MIS342Summative10</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- PgP 6/15/2019 update page, added integral check web db submissions, split constants into two files, one for students, one for course -->
<!-- Bootstrap -->
<link href="../../ReadOnly/bootstrap.css" rel="stylesheet">
<!-- constant file for student firstname, lastname, starid on students' pages -->
<script src="../constants.js"></script>
<!-- course constant file that contains semester, class, section pages -->
<script src="../../ReadOnly/CourseConstants.js"></script>
<!-- model assignment file, version 1 released 2018/02/18 PgP -->
</head>
<body onload="setVariables()">
<form class="container-fluid" action="https://eprofessor.azurewebsites.net/code/ProcessFormData.asp" method="post" name="frmAssignment" id="frmAssignment">
<input name="InstID" id="InstID" value="00617282" type="hidden">
<h1 class=" text-center">Database Applications</h1>
<!-- -start-Student, class and assignment information. Assignment hard-coded, other values from constants.js file-start -->
<div class="row col-lg-12">
<div class="col-lg-3">
<label class="text-primary" for="FirstName">First Name:</label>
<input class="form-control" name="FirstName" id="FirstName" type="text" value="default first name" readonly="readonly">
</div>
<div class="col-lg-3">
<label class="text-primary" for="LastName">Last Name:</label>
<input class="form-control" name="LastName" id="LastName" type="text" value="default last name" readonly="readonly">
</div>
<div class="col-lg-3">
<label class="text-primary" for="pin">StarID:</label>
<input class="form-control" name="pin" id="pin" type="text" value="default StarID" readonly="readonly">
</div>
<div class="col-lg-3">
<label class="text-primary" for="email">Email:</label>
<input class="form-control" name="email" id="email" type="email" value="default email address" readonly="readonly">
</div>
</div>
<div class="row col-lg-12">
<div class="col-lg-3">
<label class="text-primary" for="semester">Semester:</label>
<input class="form-control" name="semester" id="semester" type="text" value="default" readonly="readonly">
</div>
<div class="col-lg-3">
<label class="text-primary" for="class">Class:</label>
<input class="form-control" name="class" id="class" value="xClass" type="text" readonly="readonly">
</div>
<div class="col-lg-3">
<label class="text-primary" for="section">Section:</label>
<input class="form-control" name="section" id="section" value="default" type="text" readonly="readonly">
</div>
<div class="col-lg-3">
<label class="text-primary" for="assignment">Assignment:</label>
<input class="form-control" name="assignment" id="assignment" value="Summative10" type="text" readonly="readonly">
</div>
</div>
<!-- -end-Student, class and assignment information-end -->
<!-- Calculate the correct path for saving the files -->
<script>Path = "\OneDrive - MNSCU\" + xClass + "\" + document.getElementById("assignment").value + "\"; </script>
<div class="col-lg-12">
<br />
<input class="text-danger btn-block btn-lg" name="Submit" value="Submit" type="submit">
<br />
</div>
<div class="col-lg-12 h3 text-danger">
700 Points
<hr />
</div>
<!-- -start-objectives-start -->
<div class="col-lg-12"><a href="#Objectives" class="btn btn-info" data-toggle="collapse">Learning Objectives</a></div>
<div id="Objectives" class=" collapse in col-lg-12">
<!--Above this line similar except for Assignment number and title -->
<h2 >Learning Objectives</h2>
<ol start="1" type="1">
<li ><b>Develop macros and modules to automate database tasks.</b>
<ul type="circle">
<li ><i>Example</i>: A retail business creates a macro to automatically generate daily sales reports, saving time and reducing errors. </li>
</ul>
</li>
<li ><b>Use VBA code and command button macros for form navigation and event handling.</b>
<ul type="circle">
<li ><i>Example</i>: A hotel management system employs VBA to handle check-in and check-out events, updating room availability in real-time. </li>
</ul>
</li>
<li ><b>Apply filters and subqueries to refine data views.</b>
<ul type="circle">
<li ><i>Example</i>: A market researcher uses filters and subqueries to extract and analyze specific demographic data from survey responses. </li>
</ul>
</li>
<li ><b>Enhance database performance and security using the database splitter and security features.</b>
<ul type="circle">
<li ><i>Example</i>: An insurance company splits their database to improve performance and implements role-based security to protect sensitive customer data. </li>
</ul>
</li>
</ol>
<hr />
<h2>Concepts</h2>
<hr />
<p>Sample focus question: In what ways can macros and code be used to manage a relational database?</p>
<p>Sample concept list (not exclusive-refer to the chapter introduction for additional concepts):</p>
<ul>
<li>Macros</li>
<li>Actions</li>
<li>Command button macros</li>
<li>Form navigation</li>
<li>VBA code</li>
<li>Events</li>
<li>Modules</li>
<li>Functions</li>
<li>Immediate window</li>
<li>Filters</li>
<li>Subqueries</li>
<li>Autonumbers</li>
<li>Database performance</li>
<li>Database splitter</li>
<li>Security</li>
</ul>
<hr />
</div>
<!--Exercise 1-->
<div class=" col-lg-12"><a href="#Exercise01" class="btn btn-info" data-toggle="collapse">Exercise 1-Menus</a></div>
<div id="Exercise01" class="collapse in col-lg-12">
<br />
<p>
Data Files needed for the Tutorial Project:<br />
<a href="LuckyTire10.accdb" class="bg-info text-white" target="_blank">LuckyTire10.accdb</a>
<br />
Answer the following questions using a copy of the<a href="LuckyTire_10.accdb"> <strong>LuckyTire10.accdb</strong></a> database file also located on the class network drive at: \\store\classes\ YearTerm & courseid & "\ReadOnly\" )
<br />
</p>
<p>
Hint: turning on '<a href="SysObjects/SysObjects.html">System Objects</a>' can make working with List data sources much easier.<br />
</p>
<hr />
<h2>Part 10</h2>
<p>
Len Phan wants the LuckyTire database to include an easy-to-use switchboard interface.<br />
You’ll create the interface by completing the following:
</p>
<ol start="1" type="1">
<li>Open the <strong>LuckyTire </strong>database.</li>
</ol>
<ol start="2" type="1">
<li>Design and create a form named <strong>frmQueriesDialogBox</strong>.<br />
Use the figure below and the following descriptions as a guide to create the form.</li>
</ol>
<p> </p>
<p class="text-center">
<img src="Form_menu.jpg" alt="Form menu" class="img-responsive" />
</p>
<ol start="1" type="a">
<li>Place the text <strong>Queries </strong>in the form’s title bar.<br />
Set the following properties for the form:<br />
set Record Selectors to No;<br />
Navigation Buttons to No;<br />
Auto Resize to No;<br />
Close Button to No;<br />
Modal to yes;<br />
and Shortcut Menu to No.</li>
</ol>
<ol start="2" type="a">
<li>Use a list box with a Name property value of <strong>lstQueryList </strong>to display all the query names contained in the LuckyTire database, excluding those queries that start with a “~” character.<br />
To place the query names in the list box, use an SQL SELECT statement to retrieve the query names from the MSysObjects table.
<br />
Display the queries in query name order.<br />
Delete the label attached to the list box, and widen the list box to approximately 2.5 inches.<br />
<hr />
<p>(50) 1. Remove line breaks and copy the SQL statement for the lstQueryList SQL statement below:</p>
<!-- Enter your answer in the VALUE field below GROK -->
<input name="q1" id="q1" size="120" maxlength="120" class="form-control" value="SQL: " type="text">
<br />
<hr />
</li>
</ol>
<ol start="3" type="a">
<li>Use the heading <strong>Available Queries</strong>, formatted with a 14-point, bold font, above the list box.</li>
</ol>
<ol start="4" type="a">
<li>Three command buttons appear below the list box.<br />
The left command button displays the Preview icon above the word <strong>Preview</strong>, the middle command button displays the MS Access Query icon above the word <strong>Display</strong>, and the right command button displays the CloseWindow icon above the word <strong>Close</strong>.
<br />
Double-clicking a query name has the same effect as selecting a query name in the list box and clicking the middle command button.<br />
Both events cause Access to display the query datasheet for the selected query.<br />
Clicking the left command button opens the selected query in Print Preview.<br />
(You will add the VBA code for these events in the tutorial project for Part 11.<br />
For now, double-clicking or clicking should cause no action to occur.<br />
Clicking the Close command button causes Access to close the dialog box.</li>
</ol>
<ol start="5" type="a">
<li>Resize the form’s Detail section in Design view, and then resize the form in Form view.<br />
Set the form’s Border Style to Dialog, with the following properties:<br />
Auto Center is Yes;<br />
Fit to Screen is No;<br />
and Scroll Bars is Neither.<br />
Set the background color to any shade of Red in the Standard Colors gallery.<br />
Set the background color of the list box to a lighter shade of red or equivalent.</li>
</ol>
<p>
Use the Snipping Tool to provide a screen shot of your form, showing all of the controls that you created.<br />
<!-- PgP 2/4/2018 create path using constants and current document assignment -->
(100) 2. Save the screen shot as "Ex2" in your '
<code><span id="aaPath"></span></code>
<script>document.getElementById("aaPath").innerHTML = Path; </script>
' folder.<br />
<br />
</p>
</div>
<div class="col-lg-12 text-danger">
<h2>Screen Shot Ex2</h2>
<hr />
</div>
<hr />
<h2>Part 11</h2>
<p>
Len Phan wants you to continue to work on the user interface of the Lucky Tire database.
<br />
You’ll do so by completing the following:
</p>
<ol start="1" type="1">
<li>Open the <strong>LuckyTire </strong>database.</li>
</ol>
<ol start="2" type="1">
<li>Create a Form Current event procedure for the <strong>frmCustomer </strong>form to do the following:</li>
</ol>
<ol start="1" type="a">
<li>Display the Year field value in a bold, blue text when the value is greater than 2005 and in normal, black text for all other values. </li>
<li>Display the message <strong>New </strong>to the right of the Year text box in a bold, blue text only when the Year field value greater than 2005.</li>
<li>Test the procedure, and then save your form changes.</li>
</ol>
<p>
<!-- PgP 2/4/2018 create path using constants and current document assignment -->
(100) 3. Print all pages of the form as a .pdf file.<br />
Save the report as "Ex3" in your '
<code><span id="acPath"></span></code>
<script>document.getElementById("acPath").innerHTML = Path; </script>
' folder.<br />
<br />
</p>
</div>
<div class="col-lg-12 text-danger">
<h2>Ex3.pdf</h2>
<hr />
</div>
<div class="col-lg-12">
<ol start="4" type="1">
<li>Complete the <strong>frmQueriesDialogBox </strong>by doing the following: </li>
</ol>
<ol start="1" type="a">
<li>Create a Form Open event procedure that moves the focus to the first query name in the list box when the frmQueriesDialogBox form opens.</li>
<li>Create a <strong>basPreviewQuery </strong>function to open the selected query in the list box in Print Preview and a <strong>basDisplayQuery </strong>function to open the selected query in the list box in Datasheet view.</li>
<li>Attach the basPreviewQuery function to the On Click property for the Preview command button in the form.</li>
<li>Attach the basDisplayQuery function to the On Click property for the Display command button in the form and to the On Dbl Click property for the form list box.</li>
<li>Switch to Form view, and then test all the form’s procedures and functions. Save and close the form.</li>
</ol>
<p>
<!-- PgP 2/4/2018 create path using constants and current document assignment -->
(100) 4. Use the Snipping tool to make a screen shot showing your database window after you have clicked the Preview and Display Command Buttons, so that the queries are visible.<br />
Save the screen shot as "Ex4" in your '
<code><span id="adPath"></span></code>
<script>document.getElementById("adPath").innerHTML = Path; </script>
' folder.<br />
<br />
</p>
</div>
<div class="col-lg-12 text-danger">
<h2>Ex4.pdf</h2>
<hr />
</div>
<!-- Upload Access Database -->
<div class=" col-lg-12"><a href="#ExerciseUpload" class="btn btn-info" data-toggle="collapse">Exercise-Upload Database</a></div>
<div id="ExerciseUpload" class="collapse in col-lg-12">
<p>
(100) 5. <a href="https://support.office.com/en-us/article/Compact-and-repair-a-database-6EE60F16-AED0-40AC-BF22-85FA9F4005B2" class="bg-info text-white" target="_blank">Compact & Repair</a>, and then upload a copy of your LuckyTire10.accdb file, containing all your linked table settings, to the D2L Assignment Folder 'Summative10_ACCDB'.<br />
Note: failing to compact and repair will result in a loss of points, because you will be uploading a larger .mdb file than necessary.
</p>
<hr />
</div>
<div class="text-danger">
<h2>Summative10_ACCDB</h2>
<hr />
</div>
<!-- From here to end difference question numbers and Summative numbering for PDF of file uploaded to D2L -->
<div class="col-lg-12"><a href="#ExercisePDF" class="btn btn-info" data-toggle="collapse">Exercise-PDF File Creation</a></div>
<div id="ExercisePDF" class="collapse in col-lg-12">
<p>
Use a web browser to verify that you have published your website to https://classes.winona.edu/...
<br />
Check that your name, StarID, email, class, semester, section and all of your answers are correct and visible.
<br />
From the menu choose File>Print... and using "Microsoft Print to PDF" save a copy of this assignment as a .pdf file in your '
<code><span id="dPath"></span></code>
<script>document.getElementById("dPath").innerHTML = Path; </script>
' folder.<br />
</p>
<br />
<p>
(50) 6. Save your file 'WebPage.pdf' in your '
<code><span id="ePath"></span></code>
<script>document.getElementById("ePath").innerHTML = Path; </script>
' folder.<br />
</p>
<div class="text-danger">
<h2>WebPage.pdf</h2>
<hr />
</div>
<p>Create one .pdf (portable document format) file from the screen shots that you have taken by following these steps.</p>
<ol>
<li>Open File Explorer, make sure the screen shot files are properly named(Ex1, Ex2 , Ex3.. ) </li>
<li>Select all of the screen shots to be combined. </li>
<li>Right Click and select 'Print' from the short-cut menu. </li>
<li>In the bottom center of the 'Print Pictures' dialog box uncheck the box "Fit picture to frame"</li>
<li>Click on 'Print' and save the file with the name "ScreenShots.pdf" in your '
<code><span id="fPath"></span></code>
<script>document.getElementById("fPath").innerHTML = Path; </script>
' folder.<br />
</li>
</ol>
<p>
(50) 7. Save your file 'ScreenShots.pdf' in your '
<code><span id="gPath"></span></code>
<script>document.getElementById("gPath").innerHTML = Path; </script>
' folder.<br />
</p>
<div class="text-danger">
<h2>ScreenShots.pdf</h2>
<hr />
</div>
<p> </p>
<p>
Use PDFill to merge the <strong>WebPage.pdf</strong> file with the <strong>ScreenShots.pdf </strong>file, and save it as '<strong>Summative10.pdf</strong>' in your '
<code><span id="hPath"></span></code>
<script>document.getElementById("hPath").innerHTML = Path; </script>
' folder.<br />
</p>
<p>(50) 8. Upload your file 'Summative10.pdf' to the D2L 'Summative10' Assignment folder.</p>
<div class="text-danger">
<h2>Summative10.pdf</h2>
</div>
<hr />
</div>
<div class="col-lg-12"><a href="#ExerciseAssignmentSubmission" class="btn btn-info" data-toggle="collapse">Exercise-Assignment Submission</a></div>
<div id="ExerciseAssignmentSubmission" class="collapse in col-lg-12">
<p>
Use a browser to view your completed and published website at: https://classes.winona.edu/...
<br />
Ensure that you have linked this assignment on your home page.
Note that your screen shots do not have to be completed to perform this step.<br>
</p>
(50) 9. Home Page Hyperlink<br />
Check and verify that this assignment is hyperlinked on your home page.<br />
<br />
(50) 10. Assignment submission<br />
Press the Submit button at the top or bottom of this page.
Read and follow instructions on the confirmation page. Correct any errors.
</div>
<hr />
<div class="col-lg-12">
<br />
<input class="text-danger btn-block btn-lg" name="Submit" value="Submit" type="submit">
<br />
</div>
</form>
<!-- Creative Commons License Info -->
<div id="xLicense" class=" col-lg-12 text-muted"></div>
<div id="xfooter" class=" col-lg-12 text-muted"></div>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="../../ReadOnly/jquery-1.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="../../ReadOnly/bootstrap.js"></script>
</body>
</html>