Advance form controls

1. Change a lookup field to a text field.
2. View and print database documentation
3. Create datasheet, multiple items, and split forms
4. Modify a form and anchor form controls in Layout view
5. Plan, design, and create a custom form in Design view and in Layout view. 
6. Select, move, alilgn, resize, delete, and rename controls in a form.
7. Add a combo box to a form.
8. Add form headers and footers to a form.
9. Add a combo box to a form to fine records.
10. Add a subform to a form
11. Add calculated controls to a form and a subform
12. change the tab order in a form
13. Improve the apearance of a form

Important points.


1. To create a custom form you can modify an existing form or design and create a form from scratch.
2. The record source property specifies the table or query that provides the fields for the form
3. A bound control is linked, or bound, to a field in the underlying table or query.
4. An unbound control is not linked to a field in the underlying table or query.
5. An unbound control that displays text is called a label.
6. A combo box is a contrl that provides the features of a text box and a list box.
7
. The row source property specifies the data source for a control in a form or report or for a field in a table or query.
8. The Documenter is use to create detailed documentation of all, or selected, objects in a database. - In tools group, on the design tab click Relationship Report or click database tools, click database documenter, select what you want to document.
9. The datasheet tool creates a form in a datasheet format that contain all the field in the source table or query. double-click Create tab on the rigon, click more forms, click datasheet. 
10 The multiple items tool crates a customizable form tht display multiple records from a source table or query. click create, in forms group click multiple items.
11. The split form tool creates a customizable form that displays the data in a form in both form view and datasheet view at the same time.  Click create, in forms group click Split form.
12. Layout view options on the format tab for a form and datasheet.

Group Form is Active Datasheet is Active
Font Selected option applied to the selected labels and text boxes Selected option applied to every field value in the datasheet.
Formatting Selected option applied to the selected text box, which must b a currency, data, or number field Selected option applied to ever field value in the active column, which must be a currency, date, or number field
Gridlines Selected options applied only to the form, except for the add existing fields button, which applies to both the form and the datasheet. Only the options in the gridlines list apply to the entire datasheet.
Controls All options applied only to the form, except for the add exiwting fields button, which appliess to both the form and the datasheet. Options do not apply in t datasheet, except for the add existing fields button, which applies to both the form and the datasheet.
Autoformat Selected choice applied only to the form not available

13. The anchor property for a control automatically resizes the control and places the control in the same relative position on the screen as the screen size and resolution change. The anchor galley offers top left, Sretch down,bottom left, stretch across top, stretch down and across, stretch across bottom, top right, stretch down and right, bottom right.
14. a bound control is connected to a field in the database or query.
15. a unbound control is not connected to a field in the database.
16. a unbound control that displays text is called a label
17 A calculated control display a value calculated using data from one or more fields.
18. The toolbox is a specialized toolbar containing buttons that represent the tools you use to place controls on a form or report.
19. To create a bound control, you use the Field List button.
20. In the Detail section of the form is where the fields, labels and values are placed.
21. The grids are the dots in the detail section that help you place objects on the pallet. 
22 The Rulers at the top and left edge define the horizontal and vertical dimensions of the form.
23. Move handles allow ou to move a control
24. Sizing handles are used to resize the controls.
25. To delete a control, right click, click delete.
26. The form header and form footer sections let you add titles, instructions, command buttons, and other information to the top and bottom of your form.
27. The visible property determines if access displays a control or section.
28. The form selector is clicked when want to select the form and its properties.
29. the section selector is clicked when you want to select the section and its properties.
30. The count functtion determines the number of occurrences of an expression =count(experssion)
31. The sum function calculates the total of an experssion =sum(experession)
32. The tab stop property specifies whether users can use the tab key to move to a contro on a form.
33. the controltip text property sepcifies the text that appears in  a screen tip.
34. The line tool can be used to put a line in the form or report. click the design tab in the controls group, click line button.
35. Add a rectangle to the form or report - click the disign tab in the control group, click rectangle buttton.