Database Fields on Forms and Reports

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Database Fields on Forms and Reports

Based on the way Microsoft Access deals with fields, a field on a table cannot be created as a combination of other fields.
http://www.functionx.com/access/Lesson06.htm
  • Total Hits: 13421

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 143 votes

  • Category: MS Access/Data Fields

  • Submitted on: 2008-04-15 06:57:57

  • Submitted By: Shekhar

  • Set as Favorite

Description:

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.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 37.76%  54
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.49%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.19%  16
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.19%  16
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 29.37%  42

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.






Advertisements