ACCESS 2003

Course Objectives:
To learn the Access 2003 program to Microsoft Office Specialist Level

Course Content:

  • Terminology used in connection with a database, loading the Microsoft Office Access program, opening an existing database, navigating around different objects in a database, using datasheet and design view, entering a new record, finding records, sorting records 

  • Planning and design of a database, recognising relationships between tables, defining fields, data types and properties using design view, entering data into tables using datasheet view, re-sizing columns, using the Lookup Wizard 

  • Defining relationships, sing the Table Wizard to create a table, modifying the table design, sing the Input Mask Wizard, sing the Database Wizard to create a new database 

  • Editing data in form and datasheet views, adding new records, using print preview, changing page orientation, printing a datasheet, enforcing referential integrity in a relationship, using the Form Wizard, working with controls in form design 

  • Using advanced sort, using filter by form, importing a table from an external database, using a junction table to resolve a many to many relationship, adding a new field to a form, using a calculated control on a form, creating a query, using criteria to retrieve selected data, creating and naming a calculated field in a query 

  • Adding a field with data validation in a table, creating a form with subform, entering data using a form/subform combination, creating and modifying the design of a report, adding a subreport to an existing report 

  • Exporting an HTML file, editing an existing web page, creating a data access page, adding a hyperlink, object dependencies, importing an Excel spreadsheet as a table, importing a comma delimited text file as a table, creating a switchboard, backing up a database



Benefits

  • A personal workbook to use as a reference guide on completion of the course

  • The opportunity to gain the widely recognised Pitman Training Certificate


    Duration
    : 20 hours





( 020 7256 6668

     



  HOME   INVEST IN YOUR TEAM   INVEST IN YOUR CAREER   ABOUT US   COURSES   CONTACT US  

MICROSOFT   SHORTHAND   KEYBOARD SKILLS   DIPLOMAS   BOOKKEEPING   SEMINARS   QUALIFICATIONS   COURSE DATES  

PITMAN TRAINING LONDON
CITY WEST END BANK OXFORD CIRCUS
MICROSOFT OFFICE SKILLS KEYBOARD TYPING IT SHORTHAND ACCOUNTS BOOKKEEPING SECRETARIAL DIPLOMAS
ECDL MOS EXAMS MICROSOFT WORD EXCEL POWERPOINT ACCESS OUTLOOK FRONTPAGE 2003 2007
WARNFORD COURT 29 THROGMORTON STREET LONDON EC2N 2LT
WALMAR HOUSE 288 REGENT STREET LONDON W1B 3AL