7574 ITQ Databases

---

Database software Level 1 (119) Access 2007 (XP)

Contains 112 pages on the following topics:

Add records to a table, Adjust column widths, Backup, Command tabs, Computer memory, Create a database table structure, Create a table design, Data types, Definition of a table structure, Delete records in a table, Directory/folder, Disk storage, Edit records in a table, Field length, Field number, Field properties, File Handling, Filenames, Filter, Find and replace, Forms, Help, Modify a table structure, Office Button, Print, Query, Quick Access toolbar, Relational operators, Search a table, Shortcut keys, Software applications, Sort fields, Spell check, Tables/records/fields, Validation, Questions, Sample assignment, Answers

Top of Page

Database software Level 2 (219) Access 2007 (XP)

Contains 160 pages on the following topics:

Add records to a table, Adjust column widths for fields, Applications software, Archive, Backup, Calculated fields on reports, Copy a table structure to a new database, Create a new database, Create a table structure, Database table structure, Data entry forms, Data types, Define a database, Delete query, Delete records in a table, Directories/folders, Edit records in a table, Extract selected records from one database to a new database, Field length, File handling, Filter, Find & Replace, Forms, Import a comma delimited file, Indexes, Index fields, Insert image, Locate a record, Logical operators, Lookup field, Merge records from one database to another, Modify a table structure, Orientation, Page Setup, Password, Primary key, Print data entry form, Print table or query, Print the structure of a table, Print a list of files in a directory/folder, Queries, Relational operators, Reports, rtf file, Search, Sort fields, Spell check, Validation, Version control, View & edit a single field, Wildcards, Questions, Sample assignment, Answers

Top of Page

Database softare Level 3 (319) Access 2007 (XP)

Also suitable for Advanced courses for Relational Databases

Contains 242 pages on the following topics:

Attributes, Command buttons, Confidentiality, Create a new database, Create table structures, Create relationships, Crosstab query, Data dictionary, Data integrity, Data Model, Data redundancy, Data types, Domain, Entities, Entity attribute analysis, Entity attribute definition table, Entity-entity matrix, Entity-Relationship (E-R) diagram, Expected results, Filter, Find and amend a record, Forms, Image, Indexes, Keys, Labels, Logical data analysis, Logical operators, Lookup field, Menu form, Normalisation (UNF, 1NF, 2NF, 3NF, Rules), Order system example, Page Break, Page Setup, Passwords, Print structure of a table, Program structure, Queries, Referential integrity, Relational operators, Relationships, Report properties, Reports, Screen input forms, Spell check, SQL, Startup Form, Subforms, Tab Order, Tables, Technical documentation, Test data, Test log, Test plan, Testing, Toolbox (Reports, Forms), User interface form, User Instructions, Validation, Questions, Sample assignment, plus 50 pages of Answers

This is a viewing only non-printable sample chapter from the notes in PDF format - Sample chapter

If you have not used PDF files before then you may first need to download the free PDF reader software.

Top of Page

Publications list for City & Guilds 7574 ITQ

Top of Page

Home Page

Created by J Tench Last Updated 2.1.2012