100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.6 TrustPilot
logo-home
Exam (elaborations)

CGS Access Exam Questions Correctly Answered.

Rating
-
Sold
-
Pages
6
Grade
A+
Uploaded on
20-06-2024
Written in
2023/2024

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.

Show more Read less
Institution
ACCESS.
Module
ACCESS.









Whoops! We can’t load your doc right now. Try again or contact support.

Written for

Institution
ACCESS.
Module
ACCESS.

Document information

Uploaded on
June 20, 2024
Number of pages
6
Written in
2023/2024
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

  • access

Get to know the seller

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
ROSEGRADES Nursing
View profile
Follow You need to be logged in order to follow users or courses
Sold
224
Member since
2 year
Number of followers
87
Documents
12133
Last sold
2 days ago
TOPGRADE

I HELP STUDENTS WITH REVISION MATERIALS WITH BETTER GRADES GUARANTEED. BEST OF LUCK.

3.5

34 reviews

5
12
4
4
3
11
2
2
1
5

Trending documents

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their exams and reviewed by others who've used these revision notes.

Didn't get what you expected? Choose another document

No problem! You can straightaway pick a different document that better suits what you're after.

Pay as you like, start learning straight away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and smashed it. It really can be that simple.”

Alisha Student

Frequently asked questions