Making Forms More Usable With Controls In Microsoft Access 2007

Introduction

 

Access 2007

You’ve just perceived how a combo box control can make a frame more easy to understand. In Microsoft Access 2007, there are a few extra ways you can change structures to make them less demanding to utilize while likewise expanding the uprightness of the database. In this lesson, we’ll disclose how to utilize frame properties to restrain the activities your shape clients can take. We’ll additionally walk you through concealing fields on a frame and adding summon catches to the shape.

Making shapes more usable

You definitely realize that structures can enable you to expand the honesty of your information by restricting what you see and how you can enter information. You saw that utilizing a drop-down rundown can make information section simple. Presently it’s an ideal opportunity to consider the outline of your structures from a shape client’s viewpoint.

How about we take a gander at the Orders shape in our book shop situation. The essential frame, which was made with the Form charge, resembles this:

Orders Form

This frame is the place we would need our client—the store worker—to match a client with a book to finish a request. How about we take a gander at the frame from the client’s perspective:

  • The representative would include new requests, not altering existing ones, so we’ll set frame properties to restrain this activity.
  • The client will likewise never need to enter the Order ID number since this is the number the database allots each request record to separate it from different requests. We’ll shroud this field.
  • The Customer ID field and the Book ID field are not very helpful as they are on account of the representative would need to know every client’s ID number and each Book ID number to have the capacity to enter the information in the arrangement we require. We’ll make these fields more useable by making combo boxes that assistance clients select the right client and book.
  • Our client won’t have to enter the Order Date since we need the database to auto-populate this field in the database utilizing the present date. We’ll set field properties to get this going.

Setting structure properties

Access 2007 enables you to set a few shape properties. Shape properties are choices that are set in Design see on the Property Sheet, similar to the one demonstrated as follows. These alternatives control how the shape looks, functions, and associates with whatever is left of the database.

Property Sheet

To set frame properties:

  • View the frame in Design see.
  • Select the Property Sheet charge from the Tools gather on the Ribbon, as observed previously.

Note: The frame Property Sheet is likewise available by right-clicking anyplace on the shape in Design see and choosing Properties from the menu.

  • At the point when the property sheet opens:
  • Ensure Form is chosen in the Selection compose drop-down rundown.
  • Set the coveted shape properties.

Property Sheet

Tip: Use the tabs to locate the particular property you need to set. Utilize the assistance accessible to you in the base left corner of the Access window to realize what every property setting does.

Concealing fields on a frame

There will be times when a field won’t be required on a shape. Access 2007 enables you to conceal fields by setting the Visible field property in Design see.

To shroud a field on a shape:

  • In Design see, open the Property Sheet.
  • Change the Visible property setting to No, as observed underneath.

Visible Property

  • Change to Form view to check that the field is covered up.

Making combo boxes

For the New Orders shape in our book shop case, we made easy to understand drop-down records utilizing the Combo Box charge. These drop-down records enable our clients to recognize a particular client and particular book utilizing more helpful data than the Customer ID and Book ID numbers, as observed beneath.

New Orders Form

For more data on making combo boxes, visit this lesson.

Setting field properties

In some cases it might be important to set handle properties from the frame itself. For instance, on the New Orders frame for our book shop demonstrated as follows, we need to set up the Order Date field to auto-load with the present date each time a request is entered. Along these lines, our workers won’t need to stress over entering a date on the frame in light of the fact that the shape will do it for them.

New Orders Form

To set handle properties from a frame in Design see:

  • Feature the suitable field on the frame.
  • Open the Property Sheet.
  • Confirm that the Field Name shows up in the Selection write drop-down rundown.
  • Set the coveted field property.

In our case, we need to set the Order Date field to auto-load with the present date. Allude to the photo beneath. Notice that we have the Order Date field featured on the shape itself. On the Property Sheet, we have Order Date appearing in the Selection compose drop-down rundown.

Setting Order Date on New Orders Form

Since we need the Order Date to auto-fill, we should set the default an incentive to dependably enter the present date.

To set a field to auto-load with the present date:

  • Open the Data tab on the field’s Property Sheet.

Order Date Properties on New Orders Form

  • Set the Default Value property by tapping on the Expression Builder catch.
  • Utilize Expression Builder to enter the articulation for the present date. It would seem that the picture beneath.

Expression Builder

The Expression Builder contains numerous generally utilized articulations for database capacities. Investigate them by tapping the different records in the lefthand section.

Making order catches

Another approach to make a shape more easy to use is by adding summon catches to the frame. Charge catches are a speedy route for shape clients to make a particular move. These charge catches are assembled into classifications of activities, including:

  • Record Navigation charge catches, which effortlessly enable clients to move among the records in your database
  • Record Operation summon catches, which let clients do things like spare and print records
  • Frame Operation charge catches, which let clients immediately open or close a shape, print the present shape, and perform different activities
  • Report Operation summon catches, which offer clients a fast method to do things, for example, review or mail a report

To add a summon catch to a shape:

  • Tap the Button summon in the Controls aggregate on the Ribbon.

Button Command

  • At the point when the Command Button Wizard opens:
  • Select the kind of order you need from the Categories list.
  • Select the particular activity you need the charge catch to perform from the Actions list.
  • Snap Next.

Command Button Wizard

  • In the following wizard step:
  • On the off chance that you need content to show up on the catch, enter it in the Text box.
  • In the event that you need a photo to show up on the catch, select one utilizing the Browse catch.
  • Snap Next.

Command Button Wizard

  • In the following wizard step:
  • Give the catch an important name. Note: Access will give your catch a default name. Renaming it with a more valuable name may enable later on the off chance that you to have a few catches on a frame and need to change the properties of one.

Command Button Wizard

  • Snap Finish.

The charge catch ought to be operational and show up on the shape in Form see.

To know about more Articles to visit :  office com.setup

Leave a Reply

Your email address will not be published. Required fields are marked *