Organizer Advantage is powerful yet easy to use database manager for Windows.
Advantage Designer lets you modify our solutions or easily create new ones.
Take control of your data with our simple or buinsess database software solutions.


 |  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 


easy-to-use database designer

Now you are ready to design data entry/view pages

After creating a table you have to design data entry and view forms. The layout section of the Designer allows you to: choose the data entry control type for the selected data field, insert the data entry controls on one or many data pages, define the position of the data entry controls, and define attributes for the data entry controls.

  • Click on the Layout tab. The Fields section displays all of your created data fields.
  • The fields will be unchecked initially.
  • To turn on all the design functions and to record the changes click on the Design Mode.
build database sample: home inventory, step 5
  • This is optional.
  • You can click on the ID field and include it on the form.
  • This field is created automatically by the program. The application generates unique record numbers and stores them in this field.
build database sample: home inventory, step 6
  • Next you should select the data entry control for each of the fields.
  • Do this by clicking on a check box in front of the Field name.
  • This will automatically open a screen with different types of Data Entry Controls.
  • Select the Data Entry Control as in the printed table that was created in the previous topic.
build database sample: home inventory, step 7
  • For CATEGORY, LOCATION, and CONDITION select Combo-Box.
build database sample: home inventory, step 8
  • For ITEMVALUE select Numerical.
build database sample: home inventory, step 9
  • For WEBSUPPORT select Web Browser.
build database sample: home inventory, step 10
  • We would like to have the NOTES field on a separate data page.
  • In order to do that click on the Add Page button.
  • A new data entry page is created with the Part 2 title.
  • Enter Notes into the Page Name box and click the Update Page button to save it.
  • Select the NOTES field and choose Plain Memo.
build database sample: home inventory, step 11
build database sample: home inventory, step 12
  • Repeat the last instructions with the PICTURE data field.
  • Create the new page with the Image name, insert the PICTURE and select GRAPHIC.
build database sample: home inventory, step 13
  • You are now almost done. All data fields are placed on three pages.
  • You can click Save Layout to save all the changes you have done up to now.
build database sample: home inventory, step 14
  • You also have other options, that is, whether you would like to change the position of controls or modify some attributes for the selected controls.
  • Click on the Design Mode again.
  • To change the position of the control click on it, hold the mouse, move the control to a new position, release the mouse button.
build database sample: home inventory, step 15
  • The final Item Details page will look like this.
build database sample: home inventory, step 16
  • For the Notes and Picture data controls we will set the auto stretch attributes, so the control box will adjust to the page size.
  • We want the control to stretch in both directions, in this case set the option to VH, it means it will stretch vertically and horizontally.
  • NOTE: the auto-stretching option is not active in Designer; the resizing is active in the Organizer Advantage application.
build database sample: home inventory, step 17
  • Now press Save Layout and your template is done!
  • Close Designer start Organizer Advantage.

 

Copyright © 2022 · All Rights Reserved · PrimaSoft PC