modules 1 3 sam capstone project 1a economic development conference

Technology for Success and The Shelly Cashman Series® Microsoft® 365® & Office® 2021 | 1st Edition

Available study tools, lms integrated sam office 365/2021 with mindtap reader, 1 term instant access, mindtap for cable/freund/monk/sebok/starks/vermaat's the shelly cashman series® collection, microsoft® 365® & office® 2021, 2 terms instant access, mindtap for cable/freund/monk/sebok/starks/vermaat's the shelly cashman series® collection, microsoft® 365® & office® 2021, 1 term instant access, sam office 365/2021 assessments, training and projects with access to ebook, instant access, about this product.

TECHNOLOGY FOR SUCCESS AND THE SHELLY CASHMAN SERIES® MICROSOFT® 365® & OFFICE® 2021, 1st edition, delivers up-to-date coverage of Microsoft 365 and Office 2021 features along with enhanced support for Mac users. The series' trademark step-by-step, screen-by-screen, project-based approach encourages students to expand their understanding of Office applications through hands-on experimentation and critical thinking. Module Learning Objectives are mapped to Microsoft Office Specialist certification objectives, reinforcing the critical skills needed for success in college and career. Other Ways boxes help users see alternate click paths to achieve a step, while BTW call-outs offer helpful hints as readers work through projects -- enabling them to make the most of Microsoft Office tools. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study to maximize results.

Provide details on what you need help with along with a budget and time limit. Questions are posted anonymously and can be made 100% private.

Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.

Your matched tutor provides personalized help according to your question details. Payment is made only after you have completed your 1-on-1 session and are satisfied with your session.

• Homework Q&A
• Become a Tutor

All Subjects

Mathematics

Programming

Health & Medical

Engineering

Computer Science

Foreign Languages

Access over 35 million academic & study documents

Economic development conference.

Sign up to view the full document!

24/7 Study Help

Stuck on a study question? Our verified tutors can answer all questions, from basic  math  to advanced rocket science !

Similar Documents

working on a study question?

Studypool is powered by Microtutoring TM

Copyright © 2024. Studypool Inc.

Studypool is not sponsored or endorsed by any college or university.

Ongoing Conversations

Access over 35 million study documents through the notebank

Get on-demand Q&A study help from verified tutors

Read 1000s of rich book guides covering popular titles

Sign up with Google

Sign up with Facebook

Already have an account? Login

Login with Google

Login with Facebook

Don't have an account? Sign Up

Pardon Our Interruption

As you were browsing something about your browser made us think you were a bot. There are a few reasons this might happen:

• You've disabled JavaScript in your web browser.
• You're a power user moving through this website with super-human speed.
• You've disabled cookies in your web browser.
• A third-party browser plugin, such as Ghostery or NoScript, is preventing JavaScript from running. Additional information is available in this support article .

To regain access, please make sure that cookies and JavaScript are enabled before reloading the page.

New User? Register

Fill This Form To Receive Instant Help

Homework answers / question archive / Shelly Cashman Access 2019 | Modules 1-3: SAM Capstone Project 1a Economic Development Conference Creating Tables, Queries, Forms, and Reports in a Database     GETTING STARTED Open the file SC_AC19_CS1-3a_FirstLastName_1

Shelly Cashman Access 2019 | Modules 1-3: SAM Capstone Project 1a Economic Development Conference Creating Tables, Queries, Forms, and Reports in a Database     GETTING STARTED Open the file SC_AC19_CS1-3a_FirstLastName_1

Share With -->

Shelly Cashman Access 2019 | Modules 1-3: SAM Capstone Project 1a

Economic Development Conference

Creating Tables, Queries, Forms, and Reports in a Database

• Open the file SC_AC19_CS1-3a_ FirstLastName _1.accdb , available for download from the SAM website.
• If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• Support_AC19_CS1-3a_Advertisers.xlsx
• Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.
• PROJECT STEPS
• Rename the default primary key ID field to AdvertiserID and change the data type to Short Text . ( Hint: AdvertiserID should remain the primary key.)
• Add a new field with the name AdvertiserName and the Short Text data type.
• Add a third field to the table with the name ContactLName and the Short Text data type.
• Add a fourth field to the table with the name ContactFName and the Short Text data type.
• Add a fifth field to the table with the name Cost and the Currency data type. Save the table with the name Advertisers and close the table.
• Use the Import Spreadsheet Wizard to import the data from the Support_AC19_CS1-3a_Advertisers.xlsx file and append to the Advertisers table. Do not save the import steps.
• Add a field with the name SponsorID and the Short Text data type. Change the field size to 4 .
• Set SponsorID as the primary key for the table.
• Add a field with the name SponsorName and the Short Text data type.
• Add a third field with the name Amount and the Currency data type. Save the table with the name Sponsors and switch to Datasheet View.
• With the Sponsors table open in Datasheet View, add the record shown in Table 1. Resize the SponsorName field so that the field value is completely visible. Save the changes and close the Sponsors table.

• Open the Attendees table in Datasheet View and delete the record for the attendee with an AttendeeID of TL001 .
• Change the name of the Street field using Address as the new field name.
• Add a new field to the end of the table with the name CellPhone and the Short Text data type. Save the changes and close the table.
• Include the AttendeeID , FirstName , LastName , and CellPhone fields in that order.
• Save the query using AttendeeContactInfo as the query name. View the query results and then close the query.
• Include the AdvertiserID , AdvertiserName , and Cost fields.
• Select the Columnar layout.
• Assign the title AdvertiserCostData to the form. View the form and then close it.
• Include the LastName , FirstName , City , and State fields.
• Do not add any grouping levels.
• Sort the records in ascending order by LastName .
• Select the Tabular layout and the Portrait orientation.
• Assign the title AttendeeLocations to the report. View the report and then close it.
• Include the LastName , FirstName , City , and State fields in the query design grid.
• Add criteria to select only those records where Philadelphia is the City.
• Save the query using PhiladelphiaAttendees as the query name. Open the query in Datasheet View and then close it.
• Add the RegistrationFee field to the query design grid immediately following the AttendeeID field.
• Add criteria to select only those records where the GuestFee field value equal 0 and the WorkshopFee equal 0 . Open the query in Datasheet View and confirm that 16 records appear in the GuestAndWorkshop query results. Close the query, saving if necessary.
• Add the Attendees table and the Registration table to the Design window. The tables should be automatically joined by the common field AttendeeID .
• Add the FirstName and LastName fields from the Attendees table to the query design grid
• Add the RegistrationID , RegistrationFee , and WorkshopFee fields from the Registration table.
• Save the query using AttendeeRegistration as the query name. Open the query in Datasheet View and then close it.
• Move the State field so that it is the first field in the query design grid.
• Add criteria to select only those records where the value in the State field is NY or NJ .
• Sort the records in ascending order by State and then by LastName . Open the query in Datasheet View and confirm that it matches Figure 1. Close the query, saving if necessary.
• Use the State field for the row headings.
• Use the City field for the column headings.
• Use a Count of AttendeeID as the calculated value for each row and column intersection.
• Save the query using State_CityCrosstab as the query name. View the query and then close it.
• Open the AttendeeFirstName query in Design View and add criteria to select only those records where the FirstName field value begins with Lau followed by any other letters. Save the changes to the query. Open the query in Datasheet View, confirm that two records appear in the query results, and then close it.
• Open the StateAttendees query in Design View. Add parameter criteria to the State field to replace the current "PA" criteria. The new parameter criteria should prompt the user with Enter desired state as the text. Save the query, then view it in Datasheet View. Enter IL when prompted. Confirm that three records appear in the query results and then close it.
• Open the TotalFees query in Design View. Modify the query by creating a calculated field that sums the total of RegistrationFee , GuestFee , and WorkshopFee . Use TotalFees as the name of the calculated field. Save the query. Open the query in Datasheet View and then close it.
• Open the ConferenceFees query in Design View. Modify the query by sorting the records in descending order by the calculated field ConferenceFees and display only the top 5% of the records. Save the query. Open the query in Datasheet View and then close it.
• Open the SortedStates query in Design View. Modify the query to sort the State field in ascending order. Each state should appear only once. Save the query. Open the query in Datasheet View and then close it.
• Add the RegistrationFee , GuestFee , and WorkshopFee fields to the query design grid.
• Add the Total row to the query design grid.
• Calculate the sum of each of the three fields.
• Save the query using AggregateFees as the query name. Open the query in Datasheet View, confirm that it matches Figure 2, and then close it.
• Make ExhibitorID the primary key of the table.
• Change the field size of the ExhibitorID field to 4 .
• Change the data type for the BoothCost field to Currency with 0 decimal places.
• Add the text Basic cost to rent a 10 x 10 booth as the description for the BoothCost field. Save the changes to the table and close it. (Hint: Because a field size was reduced, a warning message appears asking if you want to test the data, The data is valid, so ignore this message and continue saving the table.)
• Add a field with the name Status to the end of the table.
• Select LookupWizard at the data type.
• Select the option to type in your own values.
• Type in the following three values (in the order shown) as the list of possible values for the field: Member , NonMember , and Student . Limit the field values to only the items in the list and do not allow multiple values for the field. Save the changes to the table and close it.
• Most of the attendees are members of the Economic Development Professional Organization. Use an Update query to update the values in the Status field of the Attendees table to Member for all records. Run the query and save it using UpdateStatus as the name of the query.  
• Open the Attendees table in Datasheet View and change the Status value for the attendee with an AttendeeID of CB001 (Cynthia Brown) to Student . Add the caption PostalCode to the ZIP field. Close the table.
• Create a split form for the Registration table. Save the form using Registration Split Form as the form name. Close the form.
• Select all the fields from the PotentialDonors table in the same order that they are listed in the field list.
• Select Sponsors as the destination table in the Append dialog box.
• Save the query using AppendPotentialDonors as the name, run it, and then close it. The query should append 10 records.
• Open the Relationships window and add the Attendees table and the Registration table to the Relationships window. Create a relationship between the AttendeeID field in the Attendees table and the AttendeeID field in the Registration table. Make the relationship enforce referential integrity . Save the relationship and close the window.
• Select the Attendees table as the table to display in the query results.
• Select the Registration table as the related table.
• Select the AttendeeID as the common field in both tables.
• Display all fields in the query result.
• Save the query using UnmatchedRegistration as the query name. View the query results, confirm there is one record, and then close it.
• Add criteria to select only those records where the RegistrationFee field value equals 175 .
• In the Make Table dialog box, assign the name EarlyRegistration to the new table.
• Save the query using MakeEarlyRegistration as the query name, run it, and then close the query. The new EarlyRegistration table should contain 13 records.
• Enter a validation rule for the RegistrationFee field to ensure that values in the field are greater than or equal to 100 .
• Enter the text, Must be greater than or equal to $100 in the Validation Text property box. Save the changes to the Registration table and close it. ( Hint: Because a validation rule was added, a warning message appears asking if you want to test the data. The data is valid, so ignore this message and continue saving the table.)
• Select the SponsorName field from the Sponsors table.
• Add criteria to delete only those records where Comor is the SponsorName.
• Save the query using DeleteSponsor as the query name, run it, and then close it. The query should delete one record.
• Sort the records in ascending order by SponsorName .
• Add the Total row to the datasheet and calculate the sum for the Amount field. Save the changes to the table and close it.

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.

Fill The Details Below To Receive Instant

Homework help, low cost option, download this past answer in few clicks, purchase solution.

Already member? Sign In

Custom new solution created by our subject matter experts

Get a quote.

GET ANSWER TO THIS QUESTION

100% UNIQUE SOLUTION WITHIN FEW HOURS

rated 5 stars

Purchased 39 times

View Answer

Sitejabber (5.0)

Trustpilot (4.9)

Google (5.0)

Related questions.

• Shelly Cashman Access 2019 Module 1End of Module Project 1 Competitive Swim Clubs Inc
• Microsoft Access Database questions If you received a sales report of sales by particular insurance agents 1
• Shelly Cashman Access 2019 Module 4 SAM Project 1a Personal Insurance Inc
• Access chapter 10grader project EX16ACCH10GRADERCAPHW Specialty Foods Ltd
• Illustrated Access 2016 Module 1 SAM Project 1b Scholarships Database CREATING A TABLE AND BUILDING A RELATIONSHIP GETTING STARTED Open the file ILAC161b FirstLastName 1
• Shelly Cashman Access 2016 Module 8 SAM Project 1b All Around Outside Maintenance MACROS NAVIGATION FORMS CONTROL LAYOUTS GETTING STARTED Open the file SCAC168b FirstLastName 1
• CS 120 Part 1 Exercise 1 Chapter 2 Start Access
• New Perspectives Access 2019 Module 6 SAM Critical Thinking Project 1c Global Human Resources Consultants Working With Form and Report Controls GETTING STARTED Open the file NPAC19CT6cFirstLastName1
• New Perspectives Access 2019 Module 4 SAM Project 1b Ridgedale College CREATING FORMS AND REPORTS GETTING STARTED Open the file NPAC194bFirstLastName1
• New Perspectives Access 2019 Module 7 End of Module project 1 Homestead Partners Creating and modifying reports GETTING STARTED Open the file NPAC19EOM71FirstLastName1

Help in Homework

• Don't have an account. Register Now
• Forgot Password?. Reset Password

Please enter your email address and we'll send you instructions on how to reset your password

• Already have an account? Log In

• Bahasa Indonesia
• Eastern Europe
• Moscow Oblast

Elektrostal

Elektrostal Localisation : Country Russia , Oblast Moscow Oblast . Available Information : Geographical coordinates , Population, Area, Altitude, Weather and Hotel . Nearby cities and villages : Noginsk , Pavlovsky Posad and Staraya Kupavna .

Information

Find all the information of Elektrostal or click on the section of your choice in the left menu.

• Update data

Elektrostal Demography

Information on the people and the population of Elektrostal.

Elektrostal Geography

Geographic Information regarding City of Elektrostal .

Elektrostal Distance

Distance (in kilometers) between Elektrostal and the biggest cities of Russia.

Elektrostal Map

Locate simply the city of Elektrostal through the card, map and satellite image of the city.

Elektrostal Nearby cities and villages

Elektrostal Weather

Weather forecast for the next coming days and current time of Elektrostal.

Elektrostal Sunrise and sunset

Find below the times of sunrise and sunset calculated 7 days to Elektrostal.

Elektrostal Hotel

Our team has selected for you a list of hotel in Elektrostal classified by value for money. Book your hotel room at the best price.

Elektrostal Nearby

Below is a list of activities and point of interest in Elektrostal and its surroundings.

Elektrostal Page

• Information /Russian-Federation--Moscow-Oblast--Elektrostal#info
• Demography /Russian-Federation--Moscow-Oblast--Elektrostal#demo
• Geography /Russian-Federation--Moscow-Oblast--Elektrostal#geo
• Distance /Russian-Federation--Moscow-Oblast--Elektrostal#dist1
• Map /Russian-Federation--Moscow-Oblast--Elektrostal#map
• Nearby cities and villages /Russian-Federation--Moscow-Oblast--Elektrostal#dist2
• Weather /Russian-Federation--Moscow-Oblast--Elektrostal#weather
• Sunrise and sunset /Russian-Federation--Moscow-Oblast--Elektrostal#sun
• Hotel /Russian-Federation--Moscow-Oblast--Elektrostal#hotel
• Nearby /Russian-Federation--Moscow-Oblast--Elektrostal#around
• Page /Russian-Federation--Moscow-Oblast--Elektrostal#page
• Terms of Use
• Copyright © 2024 DB-City - All rights reserved
• Change Ad Consent Do not sell my data

Notable Places in the Area

Elektrostal Satellite Map

Popular Destinations in Moscow Oblast

Escape to a random place.

• Yekaterinburg
• Novosibirsk
• Vladivostok

• Tours to Russia
• Practicalities
• Russia in Lists

Rusmania • Deep into Russia

Out of the Centre

Savvino-storozhevsky monastery and museum.

Zvenigorod's most famous sight is the Savvino-Storozhevsky Monastery, which was founded in 1398 by the monk Savva from the Troitse-Sergieva Lavra, at the invitation and with the support of Prince Yury Dmitrievich of Zvenigorod. Savva was later canonised as St Sabbas (Savva) of Storozhev. The monastery late flourished under the reign of Tsar Alexis, who chose the monastery as his family church and often went on pilgrimage there and made lots of donations to it. Most of the monastery’s buildings date from this time. The monastery is heavily fortified with thick walls and six towers, the most impressive of which is the Krasny Tower which also serves as the eastern entrance. The monastery was closed in 1918 and only reopened in 1995. In 1998 Patriarch Alexius II took part in a service to return the relics of St Sabbas to the monastery. Today the monastery has the status of a stauropegic monastery, which is second in status to a lavra. In addition to being a working monastery, it also holds the Zvenigorod Historical, Architectural and Art Museum.

Belfry and Neighbouring Churches

Located near the main entrance is the monastery's belfry which is perhaps the calling card of the monastery due to its uniqueness. It was built in the 1650s and the St Sergius of Radonezh’s Church was opened on the middle tier in the mid-17th century, although it was originally dedicated to the Trinity. The belfry's 35-tonne Great Bladgovestny Bell fell in 1941 and was only restored and returned in 2003. Attached to the belfry is a large refectory and the Transfiguration Church, both of which were built on the orders of Tsar Alexis in the 1650s.  

To the left of the belfry is another, smaller, refectory which is attached to the Trinity Gate-Church, which was also constructed in the 1650s on the orders of Tsar Alexis who made it his own family church. The church is elaborately decorated with colourful trims and underneath the archway is a beautiful 19th century fresco.

Nativity of Virgin Mary Cathedral

The Nativity of Virgin Mary Cathedral is the oldest building in the monastery and among the oldest buildings in the Moscow Region. It was built between 1404 and 1405 during the lifetime of St Sabbas and using the funds of Prince Yury of Zvenigorod. The white-stone cathedral is a standard four-pillar design with a single golden dome. After the death of St Sabbas he was interred in the cathedral and a new altar dedicated to him was added.

Under the reign of Tsar Alexis the cathedral was decorated with frescoes by Stepan Ryazanets, some of which remain today. Tsar Alexis also presented the cathedral with a five-tier iconostasis, the top row of icons have been preserved.

Tsaritsa's Chambers

The Nativity of Virgin Mary Cathedral is located between the Tsaritsa's Chambers of the left and the Palace of Tsar Alexis on the right. The Tsaritsa's Chambers were built in the mid-17th century for the wife of Tsar Alexey - Tsaritsa Maria Ilinichna Miloskavskaya. The design of the building is influenced by the ancient Russian architectural style. Is prettier than the Tsar's chambers opposite, being red in colour with elaborately decorated window frames and entrance.

At present the Tsaritsa's Chambers houses the Zvenigorod Historical, Architectural and Art Museum. Among its displays is an accurate recreation of the interior of a noble lady's chambers including furniture, decorations and a decorated tiled oven, and an exhibition on the history of Zvenigorod and the monastery.

Palace of Tsar Alexis

The Palace of Tsar Alexis was built in the 1650s and is now one of the best surviving examples of non-religious architecture of that era. It was built especially for Tsar Alexis who often visited the monastery on religious pilgrimages. Its most striking feature is its pretty row of nine chimney spouts which resemble towers.

Plan your next trip to Russia

Ready-to-book tours.

Your holiday in Russia starts here. Choose and book your tour to Russia.

REQUEST A CUSTOMISED TRIP

Looking for something unique? Create the trip of your dreams with the help of our experts.

Pardon Our Interruption

As you were browsing something about your browser made us think you were a bot. There are a few reasons this might happen:

• You've disabled JavaScript in your web browser.
• You're a power user moving through this website with super-human speed.
• You've disabled cookies in your web browser.
• A third-party browser plugin, such as Ghostery or NoScript, is preventing JavaScript from running. Additional information is available in this support article .

To regain access, please make sure that cookies and JavaScript are enabled before reloading the page.