Access 2003 Introduction (2 days)

 

This course is designed to help you to obtain the skills required to update records in a database and to use Access to create a simple database. You will learn to design tables and queries and to create forms and reports using built-in tools..
Course overview:

Basic Database Concepts – Understand what a database is

            · Recognise the advantages of using a computer database
· Know the function of the main database objects (table, query, form, report)

 What is Access?

· Recognise the different dlemants of the Access screen
· Create a new blank databse
· Select a database object using the Objects Bar
· Open and close an existing database
· Make a backup copy of a database file

The Database and Table Wizards

· Create a database using the Database Wizard
· Create a table using the Table Wizard

 

Adding and Editing Records Enter records using a datasheet

· Undo changes to a field or record
· Navigate through records in a datasheet
· Find a record
· Check spelling in a datasheet
· Replace data
· Delete records from a table

Using a Datasheet Modify the layout and formatting of a datasheet

· Sort records by a single field or by more than one field
· Apply and remove a filter
· Use Filter by Selection or Filter by Form
· Use basic operators to construct simple criteria expressions

 

Designing a Table Determine data inputs and outputs for a database

· Create a table in design view
· Use multiple data types
· Set a primary key
· Switch between design and datasheet views and different object windows
· Modify basic field properties (size, format)
· Delete a table

 Using a Form Understand the differences between a form and a datasheet

· Use AutoForm to generate a simple form
· Save and close a form
· Create a form with the Form Wizard
· Open an existing form
· Enter and edit records using a form
· Navigate through records in a form
· Add, delete, and modify records using a form
· Find, sort, and filter records using a form
· Delete a form
· Add a label to a form header or footer

Using a Select Query Understand the differences between a query and a sort or filter

· Create a query using the Simple Query Wizard
· Add, remove, and hide query fields
· Sort query results
· Run, save, close, open and delete a query

 Using Criteria Expressions Select records by a single criterion

· Create an expression
· Select records using multiple criteria

Using a Report Preview output from an object

· Print output from database objects (table, query, form, or report)
· Use AutoReport to generate a basic report
· Save, close, open and delete a report
· Change the Page Setup of database objects

 Creating a Report Create a report using the Report Wizard

· Create a label report
· Use report sections
· Move, resize, and delete controls
· Add and modify a label control
· Undo and redo design changes

 Modifying a Table Set table field properties (size, caption, format)

· Set up an index
· Use the Hyperlink data type
· Modify a table by adding and removing fields and changing field properties


 

 

Access 2003 Advanced (2 days)

 

Overview and objectives

This course will help students to customise and manage a database application using Microsoft Access.  Students will learn to use macros and command bars, link to external data sources and update data using action queries.  Students will also learn the basics of managing a shared database.  Students will learn how to use the User Level Security Wizard to secure the application and create a split-end database for use on a network.

 

Course prerequisites

Students should have completed the course "Microsoft Access 2003 Intermediate" or have equivalent knowledge or experience.  You should be able to use Microsoft Access to create a relational database and be confident using the query, form, and report design tools.

 

Course overview:

Normalisation

·Understand the theory of normal forms
·Understand de-normalisation

 

Using a Sub form or Sub report

·Use the Form/Report Wizard to create a form or report based on multiple tables
·Use the Subform control and synchronise forms
·Modify the layout of a subform
·Use the Subreport control

 

Creating Chart Reports

·Create a chart report
·Insert a chart control
·Modify a chart control

 

Creating PivotTable Reports

·Create and use a PivotTable or PivotChart

 

Using an Action Query

·Transfer data to other tables with Make Table and Append queries
·Change data with an Update query
·Delete data with a Delete query

Linking to an External Data Table

·Create a link to data stored in a spreadsheet
·Create a link to a table in another Access database
·Split a database into a front-end and back-end
·Manage linked tables

 

Optimising Database Performance

·Optimise queries using indexes
·Use the Performance Analyzer

 

Managing Shared Access

·Understand the issues involved in sharing a database
·Set record locking on shared objects
·Secure an Access database with user level security
·Configure user and group accounts
·Configure account permissions
·Transfer ownership of database objects

 

Managing Database Replication

·Replicate a database
·Synchronise replica sets

 

Designing a Macro

·Understand what a macro is and how it works
·Create a new macro
·Run a macro
·Add a macro to an event handler

 

Designing an Application

·Create and delete toolbars and menu bars
·Add and delete toolbar buttons and menu items 
·Create a switchboard form
·Customise startup settings
·Add help screen to an application