Microsoft Access project

final project/Notes1.docx

Form Design Guidelines

· Use forms to perform all database updates, because forms provide better readability and control than do table and query recordsets

· Determine the fields and record source needed for each form. A form’s Record Source property specifies the table or query that provides the fields for the form

· Group related fields and position them in a meaningful, logical order

· If users will refer to a source document while working with the form, design the form to match the source document closely

· Identify each field value with a label that names the field, and align field values and labels for readability

· Size the width of each text box to fully display the values it contains and also to provide a visual clue to users about the length of those values

· Display calculated fields in a distinctive way, and prevent users from changing and updating them

· Use default values, list boxes, and other form controls whenever possible to reduce user errors by minimizing keystrokes and limiting entries. A control is item, such as a text box or command button, that you place on a form or report

· Use colors, fonts, and graphics sparingly to keep the form uncluttered and to keep the focus on the data

· Use a consistent style for all forms in a database

Bound Form

Bound Control

Private Sub Command33_Click()

DoCmd.GoToRecord , , acNext

End Sub

Unbound Form Main

ToolBox Controls

Form Properties

F

Person_Add Form

Use a Combo Box for Security Group Code

· In the Controls group on the Design tab, make sure the Use Control Wizards button is selected

· In the Controls group on the Design tab, click the combo box button

· Place the combo box on the form

· Click I want the combo box to look up the values in a table or query, click Next, Click the Table Security Code Reference and then click Next

· Select Security Group Code and Short Desc click Next

· You can choose a sort order

· Click Next

Set the tab order for controls

· In the Navigation Pane, right-click the form and then click Design View.

· On the Design tab, in the Tools group, click Tab Order.

The name of the Command Button may be different. May have a different number

Clone Request Form to add new requests

Combo Box

· In the Controls group on the Design tab, make sure the Use Control Wizards button is selected

· In the Controls group on the Design tab, click the combo box button

· Place the combo box on the form

· Click I want the combo box to look up the values in a table or query, click Next, Click the Table Person and then click Next

· Select Account, Person_Fname, Person_Lname and click Next

· You can choose a sort order

· Click Next

·

Click Next

Initialize the Clone_status_code to be set to ‘I’ Initiated by setting the default property in the table

Clone Request Form For Inserts

Initialize the Clone_status_code to be set to ‘I’ Initiated by setting the default property in the table

Enviornment_DB_Info

If Target Repurpose Is Yes…..Then Target Repurpose Details form will be opened with the Repurpose_Database_id filled in the the Target Source ID

Private Sub Command39_Click()

MsgBox Forms![CLONE_REQUESTS_3]![TARGET_ENVIRONMENT_SID_ID]

DoCmd.OpenForm "Target_Repurpose_details", acNormal, , , acFormAdd

Forms![Target_Repurpose_details]![REPURPOSE_DATABASE_ID] = Forms![CLONE_REQUESTS_3]![TARGET_ENVIRONMENT_SID_ID]

Forms![Target_Repurpose_details]![CLONE_REQUEST_ID] = Forms![CLONE_REQUESTS_3]![CLONE_REQUEST_ID]

End Sub

Target Repurpose Details Form…

Initialize the Repurpose Database Date to Date()

Clone Request Initiate Status to Scheduled Status

Create a Query Clone Status

SELECT CLONE_REQUESTS.CLONE_REQUEST_ID, CLONE_STATUS_REFERENCE.SHORT_DESC, CLONE_REQUESTS.CLONE_STATUS_CODE, PERSON.PERSON_FNAME, PERSON.PERSON_LNAME, CLONE_REQUESTS.REQUESTING_ACCOUNT, CLONE_REQUESTS.SOURCE_ENVIRONMENT_SID_ID, CLONE_REQUESTS.TARGET_ENVIRONMENT_SID_ID, CLONE_REQUESTS.ASSIGNED_DBA_ACCOUNT, CLONE_REQUESTS.SCHEDULED_CLONE_START_DATE, CLONE_REQUESTS.SCHEDULED_CLONE_END_DATE

FROM PERSON INNER JOIN (CLONE_STATUS_REFERENCE INNER JOIN CLONE_REQUESTS ON CLONE_STATUS_REFERENCE.CLONE_STATUS_CODE = CLONE_REQUESTS.CLONE_STATUS_CODE) ON PERSON.ACCOUNT = CLONE_REQUESTS.REQUESTING_ACCOUNT

WHERE (((CLONE_REQUESTS.CLONE_STATUS_CODE)="I"));

Clone Request Scheduled Status to Completed Status

Reports

Scheduled Requests

Create a Query

SELECT CLONE_REQUESTS.CLONE_REQUEST_ID, CLONE_REQUESTS.CLONE_BUSINESS_REASON, CLONE_REQUESTS.SOURCE_ENVIRONMENT_SID_ID, CLONE_REQUESTS.TARGET_ENVIRONMENT_SID_ID, CLONE_REQUESTS.ASSIGNED_DBA_ACCOUNT, PERSON.PERSON_FNAME, PERSON.PERSON_LNAME, CLONE_REQUESTS.CLONE_STATUS_CODE, CLONE_REQUESTS.SCHEDULED_CLONE_START_DATE, CLONE_REQUESTS.SCHEDULED_CLONE_END_DATE

FROM PERSON INNER JOIN CLONE_REQUESTS ON PERSON.ACCOUNT = CLONE_REQUESTS.REQUESTING_ACCOUNT

WHERE (((CLONE_REQUESTS.CLONE_STATUS_CODE)="S"));

Create Report and use this query as the record source

Sample Data