Pages

Friday 30 March 2018

Designing With A List Details View Access 2013

A view in a Web App is similar to a form in a desktop database. There are four types of views; List Details, Datasheet, Summary, and Blank. The List Details view is a powerful feature. In its simplest form, it has a vertical tabulation of the available records on the left side of the view, and when a record is selected, the record details are displayed on the right side of the view. 

The layout capabilities of this view mean that as you delete, add, or move fields, the layout automatically moves other fields to accommodate the position of the new fields, simplifying the process of altering the view. The Record Source field (where the view gets the data) allows you to choose from the table or any queries that include the table. 

Create a List Details view:

1. Locate the object in the Table Selector. 
2. Click the plus sign. 
3. Type a name for the view, select List Details as the view type, and select the record source. 
4. Click Add New View. 
5. When the new view is displayed, click Edit. 

TIP: In the lower part of a view, you may have a related item control (Orders in our example). To resize the control, click to select it (it will change color when selected); you can then grab the top edge of the control (the mouse shape will change when hovering over the edge) and resize the control. 

Remove fields:

1. Click a field. 
2. Hold down the Ctrl key to select multiple fields and labels. Press the Delete key to remove the fields. 
3. Select any other fields to be repositioned, and drag the fields to close up white space. 

TIP: By using the Ctrl key, you can select multiple controls and move them around the layout. After selecting the controls, move the mouse over the area until a crossing arrows symbol is displayed, and then click the left mouse button and drag the controls to a new position. As you move the controls around, other controls will change position, opening up a gap into which you can position the new controls.

Add fields:

Select a field from the Field List on the right side. 
Drag the field to a new position on the display area. 
As you move over other fields, they will make space to allow the new control to be positioned. 

CAUTION: Although you can select multiple fields in the Field List, when you use the dragging action to add the fields, only the first field will be added.

No comments:

Post a Comment