Module 5 – Using Databases

In this module you can learn how to accomplish tasks associated with developing, formatting, modifying and using applications Microsoft Access 2010 and OpenOffice.org Base.

.

<<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>

Materials on basic computer e-education published on ITdesk.info

<<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>

Video materials:

1. presentation on Using Databases – OpenOffice Base    >  view presentation

1. presentation on Using Databases – Microsoft Access 2010   >   view presentation

In these presentations you can see how to:

• format table, set row height and column width
• create and format report
• create and format table
• copy report into new database etc.

2. presentation on Using Databases – OpenOffice Base    >  view presentation

2. presentation on Using Databases – Microsoft Access 2010   >   view presentation

In these presentations you can see how to:

• add fields
• create query
• put tables into relationship
• create reports with grouped results
• create forms etc.

.

<<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>

Notes:

Using Databases – Microsoft Access 2010: Link

Handbook:

Using Databases – Microsoft Access 2010: Link

.

Sample exercise and exercise solution:

exercise Using Databases >   Link

Using Databases – exercise solution  >  view presentation

<<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>

Quiz:

Using Databases > start the quiz

<<<<<<<<– @@@@//\\&%&//\\@@@@ –>>>>>>>>