EMAGISTER CUM LAUDE
Pitman Training London

Microsoft Access 2003

Pitman Training London
Blended a London (England)

Prezzo da consultare

Informazioni importanti

Tipologia Training
Metodologia Blended
Luogo London (England)
Ore di lezione 20h
Inizio Scegli data
  • Training
  • Blended
  • London (England)
  • 20h
  • Inizio:
    Scegli data
Descrizione


Suitable for: Those who wish to learn this popular database program.

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
London
London, England
Visualizza mappa
Inizio Scegli data
Luogo
London
London, England
Visualizza mappa

Cosa impari in questo corso?

Microsoft Access

Programma

Course Objective:

To teach 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