![]() A sub-form is a form-within-a-form and allows you to add more specific data to the original form. At this point, you can choose to add a sub-form. Once you’ve selected all the necessary fields, click Next. Select the table to be used and then add the fields from the Available fields section to the Fields in the form section (Figure 3). If your database has more than one table, you can select between the tables in the Tables or queries drop-down (NOTE: You can only select fields from one table in the database at this point). You can select them all or you can select as few as one. You do not have to select all fields from the database. When the database opens in the Form Wizard, your first step is to select the fields available to the form. Here (Figure 2) you can manage tables, run queries, create/edit forms, and view reports of the opened database.Ĭlick the Forms button in the left-side navigation and then double-click Use Wizard to Create Form under Tasks. The next window to appear is the heart and soul of LibreOffice Base. When the Database Wizard window appears (Figure 1), select Open an existing database file, click the Open button, navigate to the database to be used, and click Finish The first step is to open LibreOffice Base. Let’s create a data entry form for this database. I’ve created a very simple database with two tables to be used for this process. This database can either be created with LibreOffice and reside on the local system or be a remote database of the format:įor purposes of simplicity, we’ll go with a local LibreOffice Base-generated database. I will assume you already have a database created and ready for data entry. Although the Wizard isn’t nearly as powerful as the Design View ─ it will get the job done quickly and doesn’t require any form design experience.įor this entry, I will address the Form Wizard (in a later post, I will walk you through the more challenging Design View). The Form Wizard is a very simple step-by-step wizard that walks the user through the process of creating a form. There are two ways to create LibreOffice Base forms:ĭesign view is a versatile drag and drop form creator that is quite powerful and allows you to add elements and assign those elements to database tables. These forms are very simple to create and can be attached to existing databases or you can create both a database and a form in one fell swoop. These databases can be managed/edited by any user and data can be entered by anyone using a LibreOffice-generated form. The LibreOffice suite of tools includes a very powerful database application ─ one that happens to be incredibly user-friendly. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |