AulaClic. Access2003 Tutorial. Index


How to use this tutorial.

1. Basic elements of Access2003
2. Create, open, and close a database
3. Creating datatables.
4. Modifying datatables

5. Properties of the fields
6. Relationships
7. Queries
8. Summery queries

9. Cross reference queries
10. Action queries
11. Forms
12. Reports

Detailed index

Unit 1. Basic elements of Access2003

Opening and closing Access2003
The initial screen

The bars
Intelligent menus

Unit 2. Create, open, and close a database

Basic concepts
Creating a database
Closing a database
Opening a database
More ways to open a database

Unit 3. Creating data tables

Creating a datatable
The field builder
Data types
The lookup wizard
The primary key
Saving a table
Closing a table

Unit 4. Modifying data tables

Modifying the design of a table
Introducing and modifying data in a table
Moving within a table
Finding and replacing data

Unit 5. Properties of the fields

Introduction
Field size
Field format
Customizing formats
Decimal places
Input mask
Customizing input masks
Caption
Default value
Validation rule
Validation text
Required
Indexed
Indexes

Unit 6. Relationships

Basic concepts on relationships
Creating the first relationship
Referential integrity
Adding tables to the relationship window
Removing tables from the relationship window
Editing relationships
Deleting relationships
Tidying the relationship window
Showing direct relationships
Visualizing all the relationships

 
Unit 7. Queries

Types of queries
Creating a query
The Design view
Adding fields
Defining calculated fields
Forming expressions
Column headings
Changing the order of the fields
Saving the query
Running the query
Modifying the query design
Ordering rows
Selecting rows
Conditions
Multitable queries
Joining tables
The external join

Unit 8. Summary queries

Definition
The summary functions
Grouping records
Including expressions
Including search criteria

Unit 9. Crosstab queries

Introduction
The Crosstab Query wizard
The design view of a crosstab query

Unit 10. Action queries

Make-table queries
Update queries
Append queries
Delete queries
Unshowing confirmation messages

Unit 11. Forms

Introduction
The form's wizard
Editing the data in a form
The Form design view
The Form design bar
Properties of a form
The Toolbox
Working with controls

Unit 12. Reports

Introduction
The Report's wizard
The Report design view
The Report design bar
The Toolbox
Printing a Report
The Preview window
Grouping and Sorting

Step by step exercises

Create, open, and close a database
Creating a table
Modifying the design of a table
Introducing data
Moving in a table
Searching for data
Properties of the fields
Creating relationships
Modifying relationships
The relationships window
Creating simple queries I
Creating simple queries II
Multitable queries
Summary queries
Crosstab queries
Make-table queries
Update queries
Append queries
Delete queries
Creating a Form using the wizard
Changing a Form's design
Creating Subforms
Aligning Controls
Creating Reports with the wizard
Printing Reports
Reports with groups

Video tutorials

Ejercicios propuestos

Pruebas evaluativas


2. Create a database
3. Create a table
4. The Datasheet view
5. Changing format and input mask
5. The expression generator and indexes
6. Relationships
7. Create a query
7. Create a multitable query
8. Create a Summary query
10. Create an update query
10. Create an Append query
11. Managing controls in Form design
12. Grouping and sorting in Form design

Create, open, and close a database
Create a data table
Modifying a data table
Properties of the fields
Relationships
Queries
Summary queries
Crosstab queries
Action queries
Forms
Reports

Create, open, and close a database
Create a data table
Modifying a data table
Properties of the fields
Relationships
Queries
Summary queries
Crosstab queries
Action queries
Forms
Reports




  
Home
Continue
Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.