CGS Access Exam Questions Correctly Answered.

CGS Access Exam Questions Correctly Answered. Add the Services table to the Relationships window - CORRECT ANSWER Relationship Tools Design tab, Relationships group, show table, double click services, close From the current view, change the data type for the LastName field to Short Text - CORRECT ANSWER Table Tools Fields tab, formatting group, expand data type list, short text Switch this report to Design view - CORRECT ANSWER Home tab, views group, view arrow, design view Create a parameter query where the user will enter a value to use as the criterion for the InsuranceType field. Use the prompt Enter Insurance Type. Run the query using the insurance type dental - CORRECT ANSWER Click criteria row under InsuranceType column, type [Enter Insurance Type], click Query Tools Design tab, results group, click Run, type dental in Enter Insurance Type dental, click ok From Design view, modify the IncreaseType field to use a lookup list with Merit and COLA in a single column, Limit the field to values in the list only - CORRECT ANSWER Expand the Data Type list for the IncreaseType field, and select Lookup Wizard... Click the I will type in the values that I want. radio button. Click Next. In the first cell under Col 1, type Merit. Press Tab. Type COLA. Click Next. Click the Limit to List check box. Click Finish. Create a new table in Datasheet view. Save it with the name: InsurancePlans - CORRECT ANSWER Create tab, tables group, click table, click Table from the left, click save at the top left of the screen, type InsurancePlans in the Table Name Import all of the fields from the Staff worksheet in the Staff Excel file to a new table. Use the first row as column headings. Do not change any field information. Use the StaffID field as the primary key. Accept the new table Staff. Do not save the import steps - CORRECT ANSWER On the External Data tab, in the Import & Link group, click the New Data Source button, select From File, and click Excel. Click the Browse button. Click the Staff file. Click Open. Click OK. Click Next. Click the First Row Contains Column Headings check box. Click Next. Click Next. Click the Choose my own primary key radio button. Click Next. Click Finish. Click Close.