Скачать или смотреть Shelly Cashman Access 2019 | Modules 8-10: SAM Capstone Project 1a | Help in Homework |

24 / 7 Live Support
[email protected]
+44-7309655268
+91-9828671065

Shelly Cashman Access 2019 | Modules 8-10: SAM Capstone Project 1a
Economic Development Conference
Macros, Navigation Forms, Database Administration, Using SQL.
GETTING STARTED
• Open the file SC_AC19_CS8-10a_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as SC_AC19_CS8-10a_FirstLastName_2.accdb by changing the “1” to a “2”.
• 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.
• 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
• The Economic Development Professional Organization hosts an annual conference for its members, college students, and other interested persons to share new ideas, discuss problems, and brainstorm solutions. You are a conference coordinator responsible for tracking registrations and for recording income based on advertisers, exhibitors, and sponsors.

Open the Preview Advertisers Contact Report macro in Design View. Change the View argument to Print Preview. Save the change to the macro, and then close the Preview Advertisers Contact Report macro.
• Create a new macro with two submacros by following the directions below:


• When the Macro design window opens, display the Action Catalog.
• Add the first submacro to the macro, using Open Attendees Table as the name for the submacro.
• In the first submacro, use the OpenTable action to open the Attendees table in Datasheet View and in Edit data mode.
• Add a second submacro to the macro, using Open Registration Table as the name for the macro.
• In the second submacro, use the OpenTable action to open the Registration table in Datasheet View and in Edit data mode.