Course

In Preston

Price on request

Description

  • Type

    Course

  • Methodology

    Inhouse

  • Location

    Preston

  • Class hours

    18h

To learn the Access program to Microsoft Office Specialist Level. The flexibility and value of a self-study course designed to enable you to work at your own pace. A personalised workbook to use as a reference guide on completion of the course. The opportunity to gain the widely recognised Pitman Training Certificate. Suitable for: Databases form the backbone of customer and client information help within any business. Develop your database skills with Microsoft Access from the initial design stage and have the ability to run reports and queries whilst storing sales, marketing and accounting information. Successful completion of this course will enable you to work towards further qualifications.

Facilities

Location

Start date

Preston (Lancashire)
See map
1st Floor, 7-8 Winckley Street, PR1 2AA

Start date

On request

About this course

Familiar with Windows environment and experience of another Office program, ideally Word.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Lesson 1: Including: 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.

Lesson 2: Including: 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.

Lesson 3: Including: Defining relationships, using the Table Wizard to create a table, modifying the table design, using the Input Mask Wizard, using the Database Wizard to create a new database.

Lesson 4: Including: 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.

Lesson 5: Including: 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.

Lesson 6: Including: 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.

Lesson 7: Including: 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.

Access

Price on request