![Download youtube video cc](https://cdn3.cdnme.se/5447227/9-3/screenshot_3_64e629479606ee7f889a24a8.jpg)
Select your table and press > to include all fields.Under Forms, Use Wizard to Create Form.Once you can insert records in Table view, it's time to create the form: Make sure that your connection to the database allows editing. If Insert -> Record is disabled, then you need to set up the table for editing. Insert -> Record, or enter data in the last new row.Double-click on your table under Tables.Inserting new row data in a form is easier than altering the table. My guess is it could be done with a macro as well, similar to but using ALTER TABLE.
![open access database in libreoffice base open access database in libreoffice base](https://i.ytimg.com/vi/QDgZPItbnHo/hqdefault.jpg)
![open access database in libreoffice base open access database in libreoffice base](https://i.pinimg.com/736x/14/a4/04/14a40483307a5335a2650e1aac1d0813.jpg)
![open access database in libreoffice base open access database in libreoffice base](http://2.bp.blogspot.com/-zury-XUB1d0/Tzif8s03JEI/AAAAAAAAALA/pJpU0m-r2ds/s1600/ListOfNumbersInAccess.jpg)
Then I searched in the official wiki and found that one can import a MSA Database with the option ODBC, so i tried that and clicked the Next button. The problem is that my version of Libre doesn't have that "Microsoft Access 2007" option. First I saw in a forum that someone had the same issue and the solution was to open the Database Wizard and choose Microsoft Access 2007 in the option "Connect to an existing Database".
![Download youtube video cc](https://cdn3.cdnme.se/5447227/9-3/screenshot_3_64e629479606ee7f889a24a8.jpg)