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 applications.

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

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 a table, set the row height and column width
• create and format a report
• create and format a table
• copy the report into a 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 a query
• put tables into relationship
• create reports with grouped results
• create forms etc.

.

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

Notes:

Module 5 – Using Databases – Microsoft Access 2010: Link

 

Handbook:

Module 5 – Using Databases – LibreOffice Base: Link

Module 5 – Using Databases – Microsoft Access 2010: Link

Advanced databases – LibreOffice Base: Link

Advanced databases – Microsoft Access 2010: Link

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

Sample exerciseand exercise solution:

exercise Using Databases  > Link

Using Databases – exercise solution  > view presentation

Quiz:

Module 5 – Using Databases – quiz 1  > start the quiz

Module 5 – Using Databases – quiz 2  > start the quiz

 

Quizzes that cover advanced knowledge of this module:

Advanced databases: table design – fields and columns – quiz

Advanced databases: query design – quiz

Advanced databases: forms design, macros, import data – quiz

 

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

Proofreading: Ana Kedves

ISBN: 978-953-7908-16-4