Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need a step by step walk through for how to do these steps, I got stuck : ( Add a label control into the

I need a step by step walk through for how to do these steps, I got stuck :(
Add a label control into the Form Header section and enter Ticket Details by Driver into the label.
Set the following properties for the label: Change the Width property to 2, the Height Property to .25", the Top property to .2", the Left property to 2.5", the Font Size property to 14, and the Font Weight property to Bold.
Change the tab order of the controls to the following: LicenseNumber, Gender, DriverName, BirthDate, Address, City, State, and ZIP.
Remove the record selector from the form.
Save your changes to the form. Your form should look similar to Figure 7-118.
Design view after modifying the DriverTicketDetails main form.
Add a table as a subform in a main form.
Ensure that Use Control Wizards is turned on.
Use the Subform/Subreport button to add a subform onto the main form. Position the subform near the left border at the 2" high mark. The SubForm Wizard launches.
Choose Use existing Tables and Queries, add the TicketNumber, TicketDate, City, PrimaryFactor, and Fine fields from the Tickets table into the Selected Fields area in the SubForm Wizard. Also add the FirstName and LastName field from the Officers table into the Selected Fields area.
Select the Show Tickets for each record in Drivers using LicenseNumber link statement.
Enter the name TicketsSubform instead of the default name and click Finish.
Save the main form.
Switch to Layout view.
Layout view after adding the TicketsSubform onto the DriverTicketDetails main form.
Click the Next record arrow in the Navigation bar of the main form to advance to the next record. Verify that the subform updates to display one ticket for Sandra Johnson.
Switch to Design view.
Increase the width of the main form to 9" to provide space to see and modify the subform.
Set the following properties for the TicketSubform: Enter 8.6" in the Width property and .1" in the Left property.
Save and close the form to ensure that all updates are correctly processed. If prompted, save your changes.
Customize the subform to adjust field widths and remove the border, Navigation bar, and label.
Open the DriverTicketDetails form in Layout view.
Right-click the TicketNumber field name and select Field Width from the context menu.
Enter 15 in the Column Width dialog box and click OK. Recall that the column widths of a subform can only be changed in Layout view.
Change the Column Width of the remaining fields using the values below. You may need to use the scroll bars to see all the fields.
Layout view of the TicketsSubform form after adjusting column widths.
TicketDate: 13
City: 12
PrimaryFactor: 23
Fine: 11
FirstName: 15
LastName: 17
Save your changes.
Switch to Design view. If prompted, save your changes.
Click to select the TicketsSubform and enter 1.2" in the Height property and select Transparent in the Border Style property.
Click the Select All box in the subform to select the subform. The Select All box in the subform updates to display a black square.
Select No in the Navigation Buttons property.
Delete the TicketsSubform label.
Save the form.
Switch to Form view. Verify that the border, Navigation bar, and label have been removed.
Add a calculated control onto the subform and enter an aggregate function.
Switch to Design view.
Click, hold, and drag the vertical scroll bar on the subform to move down to the Form Footer section.
Click the Form Footer section bar and set the Height property to .5".
Add a text box control to the Form Footer section of the subform.
Enter =Sum([Fine]) into the Control Source property and SFTotalFine in the Name property.
Delete the label that was added with the text box.
Save the form.
Add a text box to the main form and reference a control from the subform.
Add a text box control below the subform and make the following changes to these properties: Enter =[TicketsSubform].[Form]![SFTotalFine] into the Control Source property, .8" in the Width property, 3.5" in the Top property, and 5.4" in the Left property. Select Currency in the Format property, Transparent in the Border Style property, Bold in the Font Weight, and No in the Tab Stop property.
Click the label control of that text box and make the following changes to these properties: Enter Total cost of fines in the Caption property, 1.2" in the Width property, 3.5" in the Top property, and 4.1" in the Left property. Select Bold in the Font Weight.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M Kroenke, David J Auer

6th Edition

0132742926, 978-0132742924

More Books

Students also viewed these Databases questions

Question

Define induction and what are its objectives ?

Answered: 1 week ago

Question

Discuss the techniques of job analysis.

Answered: 1 week ago

Question

How do we do subnetting in IPv6?Explain with a suitable example.

Answered: 1 week ago

Question

Explain the guideline for job description.

Answered: 1 week ago

Question

What is job description ? State the uses of job description.

Answered: 1 week ago