In this lesson, you will learn what calculated fields are, how to create them, and how to use aliases to refer to them from within your application.
Data stored within a database’s tables is often not available in the exact format needed by your applications. Here are some examples:
• You need to display a field containing the name of a company along with the company’s location, but that information is stored in separated table columns.
• City, State, and ZIP codes are stored in separate columns (as they should be), but your mailing label printing program needs them retrieved as one correctly formatted field.
• Column data is in mixed upper and lowercase, and your report needs ...