Module 5 Databases - OpenOffice and Microsoft Access
Create a Table in OpenOffice (3.2 2010) - as below
Next
Clcick Next and next again - then finish - this will give the screen below - now enter your contacts details
Table Data Entry - Below
Now Close the database and re-open it - click on the table in the left column - the RIGHT CLICK on the table itself to the right - the box opens up giving all the options, take note of all these options - now click on EDIT - as below
Each field can be edited to your needs - example click on title and enter the default value of Mr - the length can also be changed from the default of 50 to much less - as below
This ends basic table creation with Openoffice - Now we will look at the Microsoft version called Access.
Microsoft access Database Tables
To open a table - In the Access Database Window click once on the Tables icon. In the list of tables, double click on the name of the table you want to open OR click on the name of the table you want to open and click on the Open button. A Datasheet view of the table you have selected will be displayed.
The Table window A table opened from the Database Window appears as a
Datasheet. The menu bar and toolbar change to include options relevant
to working with tables. Column headings, immediately beneath the title
bar, denote field names. Each row contains a separate record. The table
might have more columns than can be displayed in the window in which case
only the left most ones are visible. The shaded boxes to the left of the
records are known as record selectors. An arrow symbol in the selector
indicates the record currently selected. An asterisk occupies the selector
of the next available empty record.At the bottom of the window, immediately
above the status line, a scroll bar provides navigation buttons and boxes
showing the number of the current record and the total number of records
in the table. When opening a file, this would normally indicate the first
record.
To save a table ยท Choose Save from the File menu OR click on the Save
icon located on the toolbar.
Save a database onto the hard disk or a USB stick.
To save a database Choose Save from the File menu OR click on the Save
icon located on the toolbar.
To save a database file to a USB stick There is no easy way within the
Access program to save a database opened from the hard disk to a memory
stick. However you may use the Windows Explorer to copy a file to your
memory stick. Start the Windows Explorer program. Select the database
file on your hard disk that you wish to copy to a memory stick. Right
click on the file and select Send To 3 1/2" USB drive command.
Close the database.
To close a database -Choose Close from the File menu OR click in the Control
menu box in the database window and choose
Close OR double click in the Control box OR press Ctrl+F4.
