Advanced databases – Microsoft Access 2010, handbook

Download (PDF, 3.9MB)

CONTENT

Foreword

1. BASIC CONCEPTS

1.1   Development and use of databases

Database models

The life cycle of the database

Business applications databases

SQL – structured query language

2. TABLES AND RELATIONSHIPS

1.2   Fields/columns

Create, modify and delete search field/column

Creating, changing and deleting masks for entering data in the field/column

Setting mandatory input data values to the field/column: necessary, not necessary

1.3   Relationships and joinings

Create, modify and delete relationships between tables: one-to-one, one-to-many

1.4   Creating and changing relationships between tables: many-to-many using the connecting tables

The use of referential integrity between tables

The use of automatic updates on related fields

The use of automatic deletion of related records

Application and changes in internal and external connection

Creating and changing the type of connection

3. QUERIES

3.1  Query types

Create and run a query to update the data in the table

Create and run a query to add records to the table

Create and run a query to clear the table

3.2   Create and run A query to save selected data as a new table

Creating and running a crosstab query

Create and run queries to display the records that are repeated in the table

Create and run queries to display unmatched records in related tables

3.3   Refining query

Create, modify and run parameter queries with one, two variables

Using wildcards in the query: [ ], !, -, #

4. TERMS OF SERVICES

____________________

RELATED PAGES:

Advanced databases – handbooks and quizzes: link

Module 5 – Using Databases – LibreOffice Base: Link

Module 5 – Using Databases – Microsoft Access 2010: Link

Advanced databases – LibreOffice Base: Link

Advanced databases: table design – fields and columns – quiz

Advanced databases: query design – quiz

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