Exam (elaborations)
BUSI Final, Microsoft Access NEWEST(201 Q&As)
- Course
- Institution
BUSI Final, Microsoft Access NEWEST(201 Q&As)/BUSI Final, Microsoft Access NEWEST(201 Q&As)/BUSI Final, Microsoft Access NEWEST(201 Q&As)
[Show more]
Content preview
BUSI Final, Microsoft Access NEWESTAdd a new Date/Time field to the far right side of the table. Name the field:
StartDate - correct answer On the Table Tools Fields tab, in the Add & Delete
group, click the Date/Time button. Type StartDate and press Enter.
Add a new calculated field named EmployeeCost in the first empty column to the
right of the ProviderName field. The new field should calculate the value in the
Premium field multiplied by .25. Run the query to view the results. - correct
answer Click in the first empty cell in the Field row in the query grid to the right
of the ProviderName column. On the Query Tools Design tab, in the Query Setup
group, click the Builder button to open the Expression Builder. Double-click the
Premium field and type *.25 to finish the expression. Click OK. Click in the new
field and replace Expr1 with EmployeeCost as the name for the field. On the
Query Tools Design tab, in the Results group, click the Run button.
Add a new record to the table with the staff ID 10-9999 and advance to the
second field. - correct answer Click the New (blank) record button at the bottom
of the table. Type 10-9999 in the StudentID field and press Tab.
Add a new record to this form. - correct answer Click the New (blank) record
button at the bottom of the form.
Add a new table in Design view. - correct answer On the Create tab, in the
Tables group, click the Table Design 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. - correct answer Type >200 and <250 in the
Criteria row in the Premium column. 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
Premium field is greater than 200 and less than 250. Run the query to view the
results. - correct answer Add criteria to this query to return only the records
where the value in the Premium field is greater than 200 and less than 250. Run
the query to view the results.
,BUSI Final, Microsoft Access NEWEST
Add criteria to this query to return only the records where the value in the
InsuranceType field is Dental or Vision. Run the query to view the results. -
correct answer Type Dental in the Criteria row in the InsuranceType column.
Type Vision in the or row in the InsuranceType column (below the Criteria row).
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 Family or the value in the Premium field is >200. Run the
query to view the results. - correct answer Type Family in the Criteria row in the
SubscriptionType column. Type >200 in the or row in the Premium column. Be
careful to enter >200 in the or row not the Criteria row. 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. - correct answer Type Like "Self*" in
the Criteria row in the SubscriptionType column. On the Query Tools Design tab,
in the Results group, click the Run button.
Add the Services table to the Relationships window. - correct answer On the
Relationship Tools Design tab, in the Relationships group, click the Show Table
button. Double-click Services. Click Close.
Add the image MedicalInsurance to the form header as a logo. Do not switch
views. - correct answer On the Form Layout Tools Design tab, in the
Header/Footer group, click the Logo button. In the Insert Picture dialog, click
MedicalInsurance to select the file, and then click the Open button.
From Layout view, apply bold formatting to the selected controls. Do not switch
views. - correct answer On the Form Layout Tools Format tab, in the Font group,
click the Bold button.
Apply the Currency format to the Premium bound text box controls. Do not switch
views. - correct answer Click the control that displays the Premium value. On the
Form Layout Tools Format tab, in the Number group, click the Currency Format
button.
,BUSI Final, Microsoft Access NEWEST
Apply the Short Date format to the DOB bound text box controls. Do not switch
views. - correct answer Click any value in the DOB column. On the Report Layout
Tools Format tab, in the Number group, expand the Format list and select Short
Date.
Apply the Blue-Gray, Text 2 font color to the selected controls. Do not switch
views. - correct answer On the Form Layout Tools Format tab, in the Font group,
click the Font Color button arrow to expand the font color palette. Click Blue-
Gray, Text 2 (the fourth color from the left in the top row of theme colors).
Change the Field Size property for the StaffID field to 7. - correct answer On the
Table Tools Fields tab, in the Properties group, type 7 in the Field Size box and
press Enter. Click Yes.
Change the data type for the LastName field to Short Text. - correct answer On
the Table Tools Fields tab, in the Formatting group, expand the Data Type list, and
select Short Text.
Create a backup of the database. You do not need to change the backup location.
- correct answer Click the File tab. Click Save As. Click Back Up Database in the
Save Database As section at the right side of the screen. Click the Save As button.
Click Save.
Create a Multiple Items form from the InsurancePlans table. - correct answer On
the Create tab, in the Forms group, click the More Forms button, and select
Multiple Items.
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. - correct answer On the Create tab, in the Queries group,
click the Query Design button. In the Show Table dialog, double-click
InsurancePlans and InsuranceProviders. Click Close. Double-click these fields in
the InsurancePlans table in this order: InsuranceID, InsuranceType,
SubscriptionType, and Premium. Double-click the ProviderName field in the
, BUSI Final, Microsoft Access NEWEST
InsuranceProviders table. On the Query Tools Design tab, in the Results group,
click the Run button.
Create a new relationship between the StaffID field in the Staff table and the
Reviewer field in the Reviews table. Enforce data integrity between the two
tables. - correct answer On the Database Tools tab, in the Relationships group,
click the Relationships button. Click StaffID in the Staff table and drag to Reviewer
in the Reviews table. In the Edit Relationships dialog, click the Enforce Referential
Integrity check box. Click Create.
Create a new table in Datasheet view. Save it with the name: InsurancePlans -
correct answer On the Create tab, in the Tables group, click the Table button.
Click the Save button on the Quick Access Toolbar. Type InsurancePlans in the
Table Name box. Click OK.
Create a new table in Design view. Name the first field: IncreaseID Make the field
data type: AutoNumber Add the description: Unique ID Set the field as the
primary key. Save the table with the Name: WageIncreases - correct answer On
the Create tab, in the Tables group, click the Table Design button. Type IncreaseID
Press Tab. Expand the Data Type list and select AutoNumber. Press Tab again.
Type Unique ID. Click the Primary Key button. Click the Save button on the Quick
Access Toolbar. Type WageIncreases in the Table Name box. Click OK.
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 in the Criteria row in the
InsuranceType column and type [Enter Insurance Type]. Click the Run button.
Type dental when prompted. Click OK.
Create a Split form from the InsurancePlans table. - correct answer On the
Create tab, in the Forms group, click the More Forms button, and select Split
Form.
Delete the Copy of Staff table. - correct answer Right-click Copy of Staff. Click
Delete. Click Yes.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller atiexpert. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79751 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now