Database Fields on Forms and Reports
Tutorials Shared by the Internet Community
Database Fields on Forms and ReportsBased on the way Microsoft Access deals with fields, a field on a table cannot be created as a combination of other fields.
Total Hits - 34031
Total Votes - 98 votes
Vote Up - 43 votes
Vote Down - 55 votes
Domain - www.functionx.com
Category - MS Access/Data Fields
Submitted By - Shekhar
Submitted on - 2008-04-15 06:57:57
As we saw in previous lessons, fields are created on a table, then they can be added to a query. Based on the way Microsoft Access deals with fields, a field on a table cannot be created as a combination of other fields, as if it were an expression (unless the field is created as "lookup")(We know that other database environments, including Microsoft SQL Server and MySQL, allow using an expression as the value of a column of a table but MS Access doesn't). Instead, the fields on a table are primarily created to store data. On the other hand, as we will see in the next few lessons, a new field can be added to a query as a combination, through an expression, of other fields. Forms and reports present this same solution. Besides using the fields of a table or a query, a new field can be added to a form or report. This is because forms and reports use objects called Windows controls.
Please use the following link to visit the site. There is a possibility that this content has been removed from the given URL or may be this site has been shut down completely.http://www.functionx.com/access/Lesson06.htm