Candidates find MS Access a bit harder compared to other Office package software. It must be because their exposure to Databases is not as much to that of spreadsheets or word processing.
This video is created to give some idea about the basic operation of Access forms such as sizing form controls, naming them, setting their alignment and applying Captions in a quicker way.
Controls let you view and work with data in your database application. The most frequently used control is the text box, but other controls include command buttons, labels, check boxes, and subform/subreport controls.
Controls can be bound, unbound, or calculated:
Bound control A control whose source of data is a field in a table or query is called a bound control. You use bound controls to display values that come from fields in your database. The values can be text, dates, numbers, Yes/No values, pictures, or graphs. For example, a text box that displays an employee's last name might get this information from the Last Name field in the Employees table.
Unbound control A control that doesn't have a source of data (such as a field or expression) is called an unbound control. You use unbound controls to display information, pictures, lines or rectangles. For example, a label that displays the title of a form is an unbound control.
Calculated control A control whose source of data is an expression, rather than a field, is called a calculated control. You specify the value that you want to use as the source of data in the control by defining an expression. An expression can be a combination of operators (such as = and + ), control names, field names, functions that return a single value, and constant values. For example, the following expression calculates the price of an item with a 25 percent discount by multiplying the value in the Unit Price field by a constant value (0.75).
=[Unit Price] * 0.75
An expression can use data from a field in the form or report's underlying table or query, or data from another control on the form or report. [Source]
Show your love! Share this page!
Please like and share the post if you find it useful. Your comments and feedback are highly appreciated.