Access 2007 Specialised

2e2 Training
In London

Want to speak to an Advisor about this course?

Important information

Typology Training
Location London
Duration 2 Days
  • Training
  • London
  • Duration:
    2 Days

Please refer to the enclosed course outline.
Suitable for: Microsoft Access 2007 Fundamentals is designed for users who are keen to extend their understanding and knowledge of the software.

Important information Venues
Where and when
Starts Location
On request
Gillingham House, 38-44 Gillingham Street, SW1V 1HU, London, England
See map
Starts On request
Gillingham House, 38-44 Gillingham Street, SW1V 1HU, London, England
See map

Frequent Asked Questions

· Requirements

This course is designed for students who have completed the Access 2007 Fundamentals course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.

Course programme

Access 2007 Orientation

Starting Access 2007Opening An Existing DatabaseThe Access 2007 Database ScreenThe Database WindowWorking With Database ObjectsExiting From Access 2007

Database Theory

Understanding DatabasesHow Access Stores DataSpreadsheets Versus Databases

Creating a New Database

Creating A New Database FileHow Access Stores DataAccess 2007 Data TypesCommonly Used Field PropertiesDesigning A Database TableCreating A New TableChanging Field PropertiesAdding Records In A TableAdding Records Using An AutoFormCreating A Reusable AutoFormAdding Records Using A FormAssignment – Adding RecordsImporting Data From Microsoft ExcelClosing A Database File

Managing Table Data

Navigating In A TableEditing A RecordDeleting A RecordDeleting Several RecordsFinding And ReplacingUndoing An ErrorCompacting A DatabasePrinting Records

Formatting Table Data

Changing Column WidthsChanging Column HeadingsFormatting The DataSheet (Table)Changing FontsMoving ColumnsFreezing ColumnsHiding ColumnsUnhiding Columns

Sorting & Filtering Table Data

Simple SortingSorting On Several FieldsCreating A Simple FilterClearing A FilterFiltering By ExceptionFiltering By Form

Data Validation

Assigning Default ValuesMarking A Required FieldValidation Rules And TextCreating A LookUp FieldWorking With Validations

Printing In Access

Previewing Records In A TablePreviewing A FormPreviewing A ReportChanging Report OrientationChanging Report Paper SizePrinting The Entire TablePrinting A Page Of Table RecordsPrinting Selected Table RecordsPrinting Form RecordsPrinting Specific Pages Of Form RecordsPrinting Specific Form RecordsPrinting Query OutputPrinting A ReportPrinting Specific Report Pages

Select Queries

Select Queries – How They WorkCreating A Query DesignDifferent Views Of A QueryWorking With Fields In A QuerySelecting Records Using A QueryClearing All Selection CriteriaExamples of Criteria ExpressionsAssignment – Select QueriesQuerying Using WildcardsQuerying - Problem charactersQuerying With Logical OperatorsSaving And Reusing A QueryCalculated Fields In A QueryChanging Column Headings In A QueryFormatting Query fieldsQueries That Summarise DataSelecting The Entire Field List in a Query

Working With Forms

Opening A FormNavigating Records In A FormMoving To A Specific Form RecordAdding Records In A FormEditing Records In A FormDeleting Records In A FormSorting Records In A FormAdding Text To Headers And FootersEditing Text In Headers And FootersFiltering In A FormRemoving A Filter From A FormSaving Form ChangesClosing A FormDeleting A Form


Reports - How They WorkCreating A New Report Using The Report WizardPreviewing A ReportPrinting A ReportUnderstanding Report BandsMoving Field Objects On A ReportFormatting A ReportRemoving Headers And FootersAdding A Header To A ReportFormatting Headers In A ReportForcing A New PageAdding A Page Footer To A ReportAdding A Report Footer To A ReportFormatting Footers In A ReportCreating A Grouped ReportCreating A Report From A Query

Database Design

Designing A Relational DatabaseScoping The SystemDetermining The InputsNormalising A TableFirst Normal Form (1NF)Second Normal Form (2NF)Second Normal Form - Case StudyThird Normal Form (3NF)

Creating Relational Databases

Creating A New Database FileAccess 2007 Data TypesCreating A New TableChanging Field PropertiesCreating A Table From A ShortcutCreating A Table With Numbers And CurrencyAssignment - Creating TablesAdding Fields To An Existing TableDelete A TableSaving And Closing TablesDefining A Primary KeyIndexing With Duplicates AllowedIndexing Without Duplicates AllowedChanging Number FormatsChanging Date Formats

Setting Table Relationships

Understanding Table RelationshipsAccessing The Relationships WindowTable Joins In The Alpheius Case StudyCreating Table JoinsAssignment - Creating Relational JoinsEditing An Existing RelationshipPrinting Table Relationships

Adding Relational Records

Adding Records In A TableAdding Records Using An AutoFormAssignment - Adding RecordsData Entry Key ViolationsData Integrity Violations

Students that were interested in this course also looked at...
See all