programming4us
 
Office
 

Microsoft Acecss 2010 : Power Control Techniques (part 1) - Add Fields to a Form, Add Multiple Fields to a Form at the Same Time

3/12/2015 9:14:56 PM

To work with a form effectively, you must initially learn how how to operate its controls. The sections which follow the cover the processes to be adding controls to a form, and then selecting, moving, sizing, deleting, and aligning those controls. The text also includes the process to change properties of control and to change the order of label of controls on a form.

Add Fields to a Form

You can use the Field List window to easily add controls to a form. The Field List window contains all the fields that are part of the form’s record source. The record source for a form is the table, query, or embedded SQL (Structured Query Language) statement that produces the data for the form. For example, in Figure 1, the form’s record source is the Customers table. The fields listed in the Field List window are the fields that make up the Customers table. To add controls to a form, you drag and drop fields from the Field List onto the form. Each field becomes a control on the form with the control type appropriate for that field. For example, whereas a Text field appears as a text box, a Yes/No field appears as a check box. Follow these two steps to add a control to your form:

Figure 1. A form based on the Customers table.

1.
Make sure the Field List window is visible. If it isn’t, click the Add Existing Fields button in the Tools group on the Design tab of the Ribbon.

2.
Locate the field you want to add to the form; then click and drag the field from the field list to the place on the form where you want it to appear. The location you select becomes the upper-left corner of the text box, and the attached label appears to the left of where you dropped the control.

A control is an object that you add to a form or report. Types of controls include text boxes, combo boxes, list boxes, and check boxes.

Add Multiple Fields to a Form at the Same Time

To add multiple fields to a form at the same time, complete the following steps:

1.
Select several fields from the field list.

2.
Hold down the Ctrl key to select noncontiguous (not together) fields or the Shift key to select contiguous (together) fields. For example, if you hold down the Ctrl key and click three noncontiguous fields, each of these three fields is selected. If you click a field, hold down the Shift key, and click another field, all fields between the two selected fields are selected. If you want to select all the fields in a list, you double-click the field list title bar, and then click and drag any one of the selected fields to the form; all the fields are then added to the form simultaneously.
 
Others
 
- Microsoft Project 2010 : Strategies for Analyzing Costs
- Microsoft Project 2010 : Reviewing the Project-Level Statistics
- Microsoft Project 2010 : Reviewing the Big Picture (Critical Path Analysis)
- Microsoft Project 2010 : Performing a Schedule Reality Check (part 2) - Looking for Technique Errors
- Microsoft Project 2010 : Performing a Schedule Reality Check (part 1) - Looking for Logic Errors, Schedule Estimation Methods
- Microsoft PowerPoint 2010 : Grouping and Changing the Order of Objects - Group and Ungroup Objects
- Microsoft PowerPoint 2010 : Rotating and Flipping Objects
- Microsoft PowerPoint 2010 : Resizing Objects
- Microsoft PowerPoint 2010 : Formatting Objects (part 2) - Change the Shape Outline, Apply a Shape Effect
- Microsoft PowerPoint 2010 : Formatting Objects (part 1) - Apply a Fill Color or Effect
 
 
REVIEW
 
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox

- Sigma 24mm f/1.4 DG HSM Art

- Canon EF11-24mm f/4L USM

- Creative Sound Blaster Roar 2

- Alienware 17 - Dell's Alienware laptops

- Smartwatch : Wellograph

- Xiaomi Redmi 2
 
VIDEO TUTORIAL
 
- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 1)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 2)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
 
Popular tags
 
Video Tutorail Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
 
Top 10
 
- How To Add A New Account in MS Outlook 2013
- Get Android & Mac OS X Style Gadgets For Windows 7 & Windows 8 With XWidget
- How To Activate Microsoft Office 2013
- How To Install Actual Facebook App On Kindle Fire
- How To Create, View And Edit Microsoft Office Files On Kindle Fire
- Download Attractive Business PowerPoint Templates For Free At SlideHunter
- How To Use And Enable Hibernate & Sleep Mode In Windows 8
- How To Get Microsoft Office 2013 Trial Product Key From Microsoft
- Complete List Of Windows 8 Keyboard Shortcuts [Hotkeys]
- How To Bypass Torrent Connection Blocking By Your ISP