Free E-Books

The table can be a local table
(stored in the database itself) or it can be linked to another Access database or an outside
data source such as SQL Server.
n Query: The name of a query that references one or more tables from the current
database file.
n SQL Statement: A SQL SELECT Statement that contains the name of a table or query.
If a form is unbound??”the Record Source property is blank??”you can??™t have any bound controls
on the form (bound controls have their Control Source property set to a field in a table). If
you add fields from the Field List and the Record Source property is blank, Access will set the
Record Source property based on the fields you add.
For more information on adding bound controls with the Field List, see Chapter 7.
Specifying how to view the form
Access 2007 uses several properties to determine how a form is viewed. The most common one is
the Default View. The Default View property determines how the data is displayed when the
form is first opened in Form View.


Pages:
654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678