(JavaScript element disabled)

ciatraining.co.uk Visit us on Facebook Visit us on Twitter  

This web site uses cookies to enhance your visit. By browsing this site you agree to our use of cookies. Find out more. Close Notification
 
Browse Products by Title: Products & Store buttonNews Feed buttonData Files buttonContact Us buttonProduct Search button
 
Functional Skills
OCR Cambridge Nationals
I.LEARN
ECDL
ECDL Essentials
ECDL Extra
ECDL Advanced
ECDL for Schools 
Flexible ECDL
ECDL/ICDL (7 Units)
Revision Series
ITQ (IT User Skills)
OCR ITQ
BCS ITQ
BTEC ITQ
City & Guilds ITQ
EDI ITQ
CLAIT
New CLAIT
CLAIT Plus
CLAIT Advanced
Open Learning Guides
Trainer Packs
Start IT
CourseNotes
Additional Services:  
Partner Solutions:  

Bank Safe
Apprentice Range: Staff Roster
 
Custom Services:

Bespoke Products
Product Customisation
e-Mailing List:  
Sign up for CiA resource updates...
Twitter News Feed:  
Quick Links:  
Legal Statements:
Privacy Statement
Terms of Use
Conditions of Sale
Other Links:
Data Files
Purchasing Options
Order Form
Site Map
20% off discount code
Sharing buttons are not available on this page.

Your shopping cart is empty

Shopping Cart Button


Product Information

Thumbnail of cover - click to enlarge

CLAIT Plus Unit 3 Creating and using a Database

15.00 (Print A4) | 200.00 (Site Licence)

Buy Now Button



Description

The 3rd guide in the CLAIT Plus 2006 series will teach you how to design, create and save a database, to add, amend and delete fields and records. You will learn how to import data and how to interrogate a database using complex criteria. Additionally, you will be able to create and format reports and to present data professionally.




Versions

This product is available in 5 different versions. Click the Buy Now button at the top or bottom of the page to select the version you would like to add to your shopping cart.
 

1.
2.
3.
4.
5.

Access 2003 (ISBN: 9781860053207)
Access 2007 (ISBN: 9781860054679)
Access 2010 (ISBN: 9781860058608)
Access 2013 (ISBN: 9780857411747)
Access 2016 (ISBN: 9780857412621)




Contents

This product contains approximately 112 pages and covers the following topics:

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.

Opening and Closing Databases
Creating Databases
Setting Field Properties
Defining Field Types
Entering Records
Importing Data
Inserting and Deleting Records
Adding and Deleting Fields
Using Ranges of Values in Queries
Using Pattern Searches and Non Matches
Using Dates in Queries
Using AND and OR in Queries
Creating Reports
Using Calculated Fields
Creating Grouped Reports
Controlling Page Setup
Printing Reports




Purchasing Options

All CiA Training resources are available in individual printed book format or as digital site licences in Microsoft Word or PDF format. Site licences are only suitable for organisations and allow unlimited editing, customisation, printing and VLE uploads.

Please refer to our Purchasing Options page if you have any queries regarding our ordering process.




Buy Now

Click the Buy Now button at the top or bottom of the page to purchase this title. For help, please Contact Us.
Buy Now Button

Tel: 0191 549 5002   |   Fax: 0191 549 9005   |   Email:  info@ciatraining.co.uk

Accepted Payment Methods: Visa, Visa Delta, Visa Electron, MasterCard, Switch/Solo/Maestro, American Express