Which of the following actions will trigger Access to display report data by the 'Departments' table?

Study for the CGS Access Test. Leverage flashcards and multiple choice questions, each with hints and explanations. Be prepared for your exam and excel!

Selecting the appropriate table in the Report Wizard is the correct choice because this action directly informs Access which data source to use when generating the report. When you choose the 'Departments' table in the Report Wizard, Access will pull the relevant fields and records from that table to create a report focused specifically on departmental data.

In contrast, while using the Form Wizard can help create forms based on an underlying table, it does not directly influence report data. Sorting records in the Navigation Pane merely organizes how tables and queries are displayed, without impacting the data retrieved for reports. Running a Select query can filter or organize data but doesn't inherently trigger Access to generate a report focused on a specific table without additional steps involving report creation tools. Thus, the action of selecting the 'Departments' table in the Report Wizard is the most straightforward way to ensure that Access uses that specific data for report generation.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy