Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

CGS 1060C ACCESS 2025 PRACTICE EXAM 100% SOLVED 2025., Exams of Computer Science

Create a new blank database named Payroll. - ANSWER1. Click the File tab 2. Click New. 3. Click Blank Database. 4. Type Payroll in the File Name box. 5. Click Create. Modify the width of the ServiceName column to best fit the data. - ANSWERDouble-click the column border between the ServiceName field and the Price field. Modify the width of the EmailAddress column to exactly 20. - ANSWER1. On the Home tab, in the Records group, click the More button, and select Field Width to open the Column Width dialog. 2. Type 20 in the Column Width: box. 3. Click OK.

Typology: Exams

2024/2025

Available from 07/14/2025

luckyexams
luckyexams 🇺🇸

3

(2)

2.1K documents

1 / 9

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CGS 1060C ACCESS 2025 PRACTICE
EXAM 100% SOLVED 2025.
pf3
pf4
pf5
pf8
pf9

Partial preview of the text

Download CGS 1060C ACCESS 2025 PRACTICE EXAM 100% SOLVED 2025. and more Exams Computer Science in PDF only on Docsity!

CGS 1060C ACCESS 2025 PRACTICE

EXAM 100% SOLVED 2025.

Create a new blank database named Payroll. - ANSWER1. Click the File tab

  1. Click New.
  2. Click Blank Database.
  3. Type Payroll in the File Name box.
  4. Click Create. Modify the width of the ServiceName column to best fit the data. - ANSWERDouble- click the column border between the ServiceName field and the Price field. Modify the width of the EmailAddress column to exactly 20. - ANSWER1. On the Home tab, in the Records group, click the More button, and select Field Width to open the Column Width dialog.
  5. Type 20 in the Column Width: box.
  6. Click OK. Apply the Zip Code input mask format to the selected field (Zip/Postal Code). Do not change default format or placeholder characters. Store the data without the symbols. - ANSWER1. Click the Input Mask box in the Field Properties pane.
  7. Click the Build... button.
  8. Click Zip Code.
  9. Click Next.
  10. Click Next.
  11. Click Next.
  12. Click Finish. From the current view, change the data type for the LastName field to Short Text. - ANSWEROn the Table Tools Fields tab, in the Formatting group, expand the Data Type list, and select Short Text. Create a new table in Design view. Name the first field: IncreaseID. Make the field date type: AutoNumber. Add the description: Unique ID. Set the field as the primary key. Save the table with the Name: WageIncreases - ANSWER1. On the Create tab, in the Tables group, click the Table Design button.
  13. Type IncreaseID.
  14. Press Tab.
  15. Expand the Data Type list and select AutoNumber.
  16. Press Tab again.
  17. Type Unique ID.
  18. Click the Primary Key button.
  19. Click the Save button on the Quick Access Toolbar.
  20. Type WageIncreases in the Table Name box.
  21. Click OK.
  1. Expand the Data Type list and select Short Text.
  2. Click the Save button on the Quick Access Toolbar. Go to the next record. - ANSWERClick the Next Record button at the bottom of the table. Go to the first record. - ANSWERClick the First Record button at the bottom of the table. Go to record number 14. - ANSWER1. Type 14 in the Current Record box at the bottom of the table.
  3. Press Enter. Start a new query in Design view. - ANSWEROn the Create tab, in the Queries group, click the Query Design button. Create a new query in Design view using the following fields in this order: From the InsurancePlans table, add the InsuranceID, InsuranceType, SubscriptionType, and Premium fields. From the InsuranceProviders table, add the ProviderName field. Run the query. - ANSWER1. On the Create tab, in the Queries group, click the Query Design button.
  4. In the Show Table dialog, double-click InsurancePlans and InsuranceProviders.
  5. Click Close.
  6. Double-click these fields in the InsurancePlans table in this order: InsuranceID, InsuranceType, SubscriptionType, and Premium.
  7. Double-click the ProviderName field in the InsuranceProviders table.
  8. On the Query Tools Design tab, in the Results group, click the Run button. From the current view, rename the ID field to: PlanID. - ANSWER1. On the Table Tools Fields tab, in the Properties group, click the Name & Caption button.
  9. Type PlanID in the Name box.
  10. Click OK. Add the picture StoneRivers to the third record. - ANSWER1. Double-click the Attachment field in the third record. The Attachments dialog opens.
  11. Click the Add... button.
  12. Double-click the StoneRivers file to add it.
  13. Click OK. From Datasheet view, add a new far right of the table to store a picture of each staff member. Add the picture JerryWashington to the fifth record. - ANSWER1. Click the arrow in the Click to Add column to expand the list of available field data types.
  14. Click Attachment.
  15. Double-click the Attachment field in the fifth record. The Attachments dialog opens.
  16. Click the Add... button.
  17. Double-click the JerryWashington file to add it.
  18. Click OK.

Modify this query so the InsuranceType field is hidden in the query results, and then run the query. - ANSWER1. Click the Show box in the InsuranceType column to remove the checkmark.

  1. On the Query Tools Design tab, in the Results group, click the Run button. Set the sort order so the results will display records with the highest Premium first. Run the query and review the results. - ANSWER1. Click in the Sort row under the Premium field.
  2. Click the arrow to expand the sort options list, and select Descending.
  3. On the Query Tools Design tab, in the Results group, click the Run button. Limit the query results to records where the insurance Premium is greater than 250. Run the query to view the results. - ANSWER1. Type >250 in the Criteria row in the Premium column.
  4. On the Query Tools Design tab, in the Results group, click the Run button. Limit the query results to records where the value in the DOB field is greater than or equal to January 1, 1980. Run the query to view the results. - ANSWER1. Type

=1/1/1980 in the Criteria row in the DOB column.

  1. On the Query Tools Design tab, in the Results group, click the Run button. Modify the query to show only medical insurance plans. Add the criteria to the InsuranceType field to return only records where the classification is Medical. Run the query. - ANSWER1. Type Medical in the Criteria row in the InsuranceType column.
  2. On the Query Tools Design tab, in the Results group, click the Run button. Add criteria to this query to return records where the SubscriptionType field begins with the letters Self. Run the query. - ANSWER1. Type Like "Self*" in the Criteria row in the SubscriptionType column.
  3. On the Query Tools Design tab, in the Results group, click the Run button. Add criteria to this query to return only the records where the value in the SubscriptionType field is Self or Family and the value in the Premium field is <200. Run the query to view the results. - ANSWER1. Type Self in the Criteria row in the SubscriptionType column.
  4. Type Family in the or row in the SubscriptionType column.
  5. Type <200 in the Criteria row in the Premium column.
  6. Type <200 in the or row in the Premium column.
  7. On the Query Tools Design tab, in the Results group, click the Run button 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. - ANSWER1. Click in the Criteria row in the InsuranceType column and type [Enter Insurance Type].
  8. Click the Run button.
  9. Type dental when prompted.
  10. Click OK.
  1. Click Finish. Add criteria to this query to return only the records where the value in the SubscriptionType field is Family or the value in the Premium field is >200. Run the query to view the results. - ANSWER1. Type Family in the Criteria row in the SubscriptionType column.
  2. Type >200 in the or row in the Premium column.
  3. On the Query Tools Design tab, in the Results group, click the Run button. Create an automatic basic report from the InsurancePlans table. - ANSWEROn the Create tab, in the Reports group, click the Report button. Add a new record to this form. - ANSWERClick the New (blank) record button at the bottom of the form. Enter the following information in the form. Enter 10-9915 in the StaffID field. Enter Finley in the LastName field. Enter Devon in the FirstName field. Enter 8/12/82 in the DOB field. When you are done entering data in the last field, start a new blank record. - ANSWER1. Click in the StaffID box and type 10-9915.
  4. Press Tab.
  5. Type Finley in the LastName box.
  6. Press Tab.
  7. Type Devon in the FirstName box.
  8. Press Tab.
  9. Type 8/12/82 in the DOB box.
  10. Press Tab. Add a new record to the table with the staff ID 10-9999 and advance to the second field.
  • ANSWER1. Click the New (blank) record button at the bottom of the table.
  1. Type 10-9999 in the StudentID field and press Tab. Rename the table Work Logs to: Time Sheets. - ANSWER1. Right-click Work Logs.
  2. Click Rename.
  3. Type Time Sheets.
  4. Press Enter. Use AutoFilter to filter the query results to show only records where the value of the StaffID field is Mo or Shannon. - ANSWER1. Click the arrow at the top of the StaffID column and click the (Select All) check box to remove all checkmarks.
  5. Click the Mo check box to add a checkmark.
  6. Click the Shannon check box to add a checkmark.
  7. Click OK. Use the Report Wizard to create a new report. Include fields in this order: DepartmentName from the Departments table, LastName, FirstName, and DateOfHire from the Staff table. View the report data by the Departments table. Add grouping by DateOfHire. Sort records by DateOfHire. Use the Stepped layout and Portrait

orientation. Name the report StaffByDepartment and allow Access to display the report in Print Preview view when you finish. - ANSWER1. Expand the Tables/Queries list and select Table: Departments.

  1. Double-click DepartmentName.
  2. Expand the Tables/Queries list and select Table: Staff.
  3. Double-click LastName, FirstName and then DateOfHire.
  4. Click Next.
  5. Click By Departments.
  6. Click Next.
  7. Click DateOfHire and then click the > button.
  8. Click Next.
  9. Expand the 1 box and select DateOfHire.
  10. Click Next.
  11. Click Next.
  12. Type StaffByDepartment in the box and click Finish. From the current view (Layout view), add automatic totals to the Premium column to calculate the average premium. - ANSWER1. Click any value in the Premium column.
  13. On the Report Layout Tools Design tab, in the Grouping & Totals group, click the Totals button.
  14. Select Average. Use the Form Wizard to create a new form. Include these fields in this order from the Staff table: StaffID, LastName, FirstName, and MedicalInsurance and then add these fields from the InsurancePlans table: InsuranceID and Premium. Organize the form by InsurancePlans with data from the Staff table as a datasheet subform. Accept the suggested names for the form and subform. Allow Access to open the form in the Form view when you are finished. - ANSWER1. On the Create tab, in the Forms group, click the Form Wizard button.
  15. Expand the Tables/Queries list and select Table: Staff.
  16. Double-click these fields in order: StaffID, LastName, FirstName, and MedicalInsurance.
  17. Expand the Tables/Queries list again and select Table: InsurancePlans.
  18. Double-click InsuranceID and Premium.
  19. Click Next.
  20. Click by InsurancePlans.
  21. Click Next.
  22. Click Next.
  23. Click Finish. Delete the Copy of Staff table. - ANSWER1. Right-click Copy of Staff.
  24. Click Delete.
  25. Click Yes.