Complete the steps for creating a crosstab query. 1. Click the tab.
2. In the
group, click Query Design.
3. Click the table you wish to use, and add the field needed. Name and save the query.
4. Once saved, go to Query Type and select
5. In the Design view, you will select from the drop-down menus in the Crosstab row how the information should be
presented. Then, select Save.
6. Select the crosstab query and
to run the query quickly.

You have been supporting csm tech publishing's windows server 2016 server network for over a year. the office has two windows server 2016 servers running active directory and a number of other roles. management has informed you that a small sales office is opening in the same building three floors up. the sales manager wants to install a sales application on a server located in the sales office. this server will have limited physical security because there's no special room dedicated for it, which means it will be accessible to non-it personnel and visitors. you're considering installing windows server 2016 server core on the new server because accessing its console regularly probably won't be necessary, and this server will be managed from one of the other csm tech publishing servers. what are the benefits and drawbacks of using server core for this branch office? what are some things you should do to set up this server management environment?