![]() Sometimes we need to change a query each time it is run, for that we will use an input parameter or input box - shown in video 28. ![]() We also create queries and review our "Design View" queries in SQL view: We learn how to create queries using the LibreOffice " Design View" also know as QBE or Query By Example: Videos 15 and 16 show us how to embed a picture in a databbase and link a picture to a database. In videos 11 and 12 we look at how to add radio buttons and a date dropdown box to a form. In video #10 we show how to customize our background and add pictures on a form. In Video #9 We see how to add buttons on our form (like first record, next record, previous record, and last record): In video tutorial #6 we learn how to create a simple form: This just means making the database available to other LibreOffice modules (like Writer and Calc) - This is explained in Video Tutorial #5 When creating a LibreOffice Base database, LibreOffice asks us if we want to register the database. LibreOffice Base is just the front end allowing us to tie into the actual database. ![]() This makes LibreOffice Base appear as if it were a database manager and the database, but it is not. ![]() LibreoOffice Base can be used to create small embedded databases when used with Java-based HSQLDB as its storage engine (The LibreOfice Base default database). LibreOffice Base is a front end database manager that can be used to create forms and reports from a variety of databases including MySql as well as others. LibreOffice Base is a database management program, similar to Microsoft Access.
0 Comments
Leave a Reply. |