1 / 10

Designing Tables and Forms: Creating, Storing, and Modifying Data

Learn how to create tables and design forms in Chapter 2. Understand the basic concepts, including primary keys, field types, and table templates. Explore different views and properties, such as data types, field size, format, and validation rules. Discover how to create and modify forms, using bound, unbound, and calculated controls, as well as drop-down lists and option groups. Complete practice exercises 6 and 7 to solidify your understanding.

jadcock
Download Presentation

Designing Tables and Forms: Creating, Storing, and Modifying Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 2 Design Table and Form

  2. Agenda • Create table • Form design

  3. Create Table • Basic concepts • Include necessary data • Store data in its smallest part as field • Avoid calculated field • Primary key for unique record identification • Field :name and type • Method • Table Wizard • Table template • Views: Datasheet or Design • Property – characteristics of an object

  4. Data Type • Number field • Text field • Memo field • Date/Time field • Currency field • Yes/No field • OLE field • AutoNumber • Hyperlink field

  5. Property - I • Field size • Format • Input Mask • Caption • Default Value • Validation Rule • Validation Text

  6. Property - II • Required • Allow Zero Length • Indexed • Unicode Compression • IME Mode • IME Sentence Mode

  7. Form • Form view • Completed form • Enter or modify data for a related table • Design view • Create or modify the form

  8. Control • Bound control: has data source • Unbound control: no data source • Calculated control: expression as data source • Drop-down list box (using Lookup Wizard) • Check box • Option group • Command button

  9. Points to Remember • Create table • Form design

  10. Assignment • Practice exercises 6 and 7 • Due date

More Related