EX16_AC_CH01_GRADER_CAP_AS - National Conference [PDF]

My Account Gift Certificates Wish Lists Sign in or Create an account

Search

Home

EX16_AC_CH01_GRADER_CAP_AS - National Conference (completed solution)

$15.00 Quantity: 1



EX16_AC_CH01_GRADER_CAP_AS - National Conference Project Description: In this project, you will open a database containing information about a national conference that you are helping organize. You modify the record for a speaker, apply a filter to find sessions for specific speakers, and add a new session. Instructions: For the purpose of grading the project you are required to perform the following tasks:

Step

1

Points

Instructions

Possible

Start Access. Open the downloaded Access file named

0

exploring_a01_grader_a1.

Open the Speakers table in Datasheet view and use Search to locate the speaker with P014 as the SpeakerID. Change the 2

first name from Mary to Mirijana and the last name from Miller

10

to Hinek. Sort the table in ascending order by SpeakerID. Save and close the table.

Open the Speaker – Session Query and apply a filter to identify 3

the sessions for which Cynthia Ahsley or Holly Davis are the

15

speakers (Hint: Use Filter by Form and the Or tab).

4

Sort the filtered results in ascending order by the SessionID

15

field and then save and close the query.

Open the Sessions Form and add a new session using the following information:

SessionID: S13 5

Session Title: University Collaboration

15

RoomID: 104 Date: 11/28/2017 Starting Time: 2:00PM

Save and close the form.

Open the SessionSpeaker table and enter a new (blank) record 6

using SpeakerID 010 and SessionID 09. Sort the table by SpeakerID in descending order. Save the changes and close

15

the table.

Open the Master List – Sessions and Speakers report in 7

Layout view. Switch to Print Preview and change the margins

15

to Wide. Close Print Preview.

Switch to Report View. Apply a filter that limits the report to 8

sessions in Room 101 only. Save the filter and close the

15

report.

9

Close all database objects. Close the database and then exit Access. Submit the database as directed.

Total Points



0

100



This product hasn't received any reviews yet. Be the first to review this product!

EX16_AC_CH04_GRADER _CAP_AS - National Farm and Agriculture Conference (completed solution)

YO16_XL_CH03_GRADER _PS1_HW - Renovations 1.1 (completed solution) $15.00

$15.00

EX16_AC_CH04_GRADER _CAP_AS - National Farm and Agriculture Conference (completed solution)

EX16_AC_CH06_GRADER _CAP_AS - Drivers and Insurance (completed solution)

e02ch03_grader_hw_Reno vation (completed solution) $15.00

CPMGT 304 Week 2 Organizational Structure $10.00

$15.00

ConferenceRegistrationFor m-02 (completed solution)

SC_EX16_9b (completed solution)

Emerge_Access2013_P1a (completed solution)

$10.00

$20.00

$20.00

$15.00

CRJ 560 Module 5 Written Assignment DemocraticRepublican National Convention Stakeholders (Saint Leo, completed solutions) $12.00

Name

Custom original work

Order a paper

Welcome!

TAMUC

Contact Us

UoP

All prices are in USD. © 2018 Homework Number One. Sitemap

Email

View all brands

Powered by