Microsoft access 2002 : comprehensive concepts and techniques / Gary B. Shelly . . . [et al].
Series: Shelly Cashman seriesPublication details: Australia ; South Africa ; Singapore : Course technology, c2002.Description: xvi, various pages : col. ill. ; 28 cmISBN:- 9780789562821
- 0789562820
- 22 005.53 MIC
Item type | Current library | Call number | Copy number | Status | Date due | Barcode |
---|---|---|---|---|---|---|
Book Open Access | Engineering Library | 005.53 MIC 1 (Browse shelf(Opens below)) | 1 | Available | BUML23111756 |
CONTENTS
1. Project one: Creating a database using design and datasheet views
Objectives
What is Microsoft access ?
Project one - Alisa vending services
Starting access
Speech recognition
Creating a new database
The access desktop and the database window
Creating a table
etc.
2. Project two: Querying a database using the select query window
Objectives
Introduction
Project two - Querying the Alisa vending services database
Creating a new query
Including all fields in a query
etc.
3. Project three: Maintaining a database using the design and update features of access
Objectives
Introduction
Project three - Maintaining the Alisa vending services database
Opening the database
Adding, changing and deleting
Changing the structure
Using an update query
etc.
4. Project four: Reports, forms and combo boxes
Objectives
Introduction
Project four - Creating reports and forms for Alisa vending services
Report creation
Grouping in a report
Reviewing the report design
Report design considerations
etc.
5. Project five: Enhancing forms with OLE Fields, hyperlinks and sub forms
Objectives
Introduction
Project five - Enhancing the Alisa vending services form
Opening the database
Date, Memo OLE and Hyperlink fields
Adding fields to a table
Updating the new fields
etc.
Project six: Creating an application system using macros, wizards, and the switchboard manager
Objectives
Introduction
Project six- creating an application system for Alisa vending services
Lookup and input mask wizards
Modifying a report
etc.
Project seven: Creating a report using design view
Objectives
Introduction
Opening the database
Creating the additional tables
Relating several tables
etc.
Project eight: Using visual basic for applications and advanced form techniques
Objectives
Introduction
Project eight- using advanced from techniques and visual basic applications
Opening the database
Enhancing the form
Visual basic for applications
etc.
Project nine: Administering a database system
Objectives
Introduction
Project nine- administering the Alisa vending services database system
Using microsoft access tools
Using the analyse tool
Integrity features
etc.
Index : p. I.01-I.13
There are no comments on this title.