DatabaseTutorials

=**OpenOffice / NeoOffice Database Tutorials**=

Try the following links for tutorials on Open Office Base

=Atomic Learning= @http://www.atomiclearning.com/uk/en_GB/oo2base_intro

Contact your IT co-ordinator for your school's login and password to Atomic Learning. The first two tutorials are previews that do not require a password. The contents of the Atomic Learning OpenOffice Tutorials are as follows:

**A. Databases and Tables**

 * ~  ||~ Key # ||~ Length ||
 * 1. || [[image:http://static.atomiclearning.com/eastwood/images/icon_preview.gif width="16" height="10" caption="preview"]] || [|What is Base?] || 26908 || 1:56 ||
 * 2. || [[image:http://static.atomiclearning.com/eastwood/images/icon_preview.gif width="16" height="10" caption="preview"]] || [|Creating a new database using the wizard] || 26909 || 1:55 ||
 * 3. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating a table using a wizard || 26910 || 3:42 ||
 * 4. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Setting field types in the wizard || 26911 || 2:15 ||
 * 5. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Specifying a primary key and completing the wizard || 26912 || 2:45 ||
 * 6. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating a new table in design view || 26913 || 3:41 ||
 * 7. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Viewing and editing tables || 26914 || 4:09 ||
 * 8. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Changing an existing table's design || 26915 || 3:16 ||
 * 9. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating a table view || 26916 || 2:36 ||
 * 10. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Connecting to a Microsoft® Access database || 26917 || 3:34 ||

B. Forms for Data Entry and Display

 * ~  ||~ Key # ||~ Length ||
 * 1. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating a form using the wizard || 26918 || 3:03 ||
 * 2. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Using a form to add, modify and delete records || 26919 || 1:55 ||
 * 3. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Working in form design view || 26920 || 4:06 ||
 * 4. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Using the Form Design toolbar || 26921 || 3:01 ||
 * 5. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Using the form navigator || 26922 || 1:24 ||
 * 6. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Adding a field to a form || 26923 || 1:09 ||
 * 7. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Setting the tab order || 26924 || 1:49 ||
 * 8. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Aligning and arranging objects || 26925 || 2:17 ||

C. Reports

 * ~  ||~ Key # ||~ Length ||
 * 1. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating reports using the wizard pt. 1 || 26926 || 2:16 ||
 * 2. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating reports using the wizard pt. 2 || 26927 || 2:26 ||
 * 3. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Viewing, saving and printing a report || 26928 || 2:51 ||
 * 4. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Changing the design of a report || 26929 || 1:57 ||

D. Queries

 * ~  ||~ Key # ||~ Length ||
 * 1. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating a query using a wizard pt. 1 || 26930 || 2:48 ||
 * 2. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating a query using a wizard pt. 2 || 26931 || 2:04 ||
 * 3. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Editing the design of a query pt. 1 || 26932 || 2:46 ||
 * 4. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Editing the design of a query pt. 2 || 26933 || 3:21 ||
 * 5. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Changing the sort and display order || 26934 || 1:44 ||
 * 6. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating a query in design view || 26935 || 1:42 ||
 * 7. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Editing and creating a query in SQL view || 26936 || 2:48 ||
 * 8. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Creating a multiple table query || 26937 || 4:28 ||

E. Common Tasks

 * ~  ||~ Key # ||~ Length ||
 * 1. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Finding records || 26938 || 2:57 ||
 * 2. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Sorting records || 26939 || 2:44 ||
 * 3. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Selecting records using a filter || 26940 || 3:13 ||  ||~   ||
 * 3. || [[image:http://static.atomiclearning.com/eastwood/icons/platform/lock.png width="11" height="15" caption="locked"]] || Selecting records using a filter || 26940 || 3:13 ||  ||~   ||

=Digital Distribution= http://www.digitaldistribution.com/about/lessons/

This site has free lessons on Writer, Calc and Base. The documents are downloadable for off-line browsing.