Microsoft Access 2007 - Beginners

Short course

In Nottingham

£ 149 VAT inc.

Description

  • Type

    Short course

  • Level

    Beginner

  • Location

    At 2 venues

  • Class hours

    6h

  • Duration

    1 Day

Suitable for: This course is designed for people with little or no experience with Microsoft Access. Some knowledge of the Microsoft environment will help but is not essential.

Facilities

Location

Start date

Nottingham (Nottinghamshire)
See map
46-48 Alfreton Road Canning Circus, NG7 3NN

Start date

On request
Nottingham (Nottinghamshire)
See map
Ebury Road Sherwood Rise Nottingham, NG5 1BB

Start date

On request

About this course

This is a beginner - Intermediate course and therefore no prior experience is necessary.

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

Subjects

  • Access
  • Access for Beginners
  • Access Beginner - Intermediate
  • Database
  • Database Design
  • Database Marketing
  • Database training
  • MS Access
  • MS Access 2007
  • Microsoft Access 2007
  • Microsoft Access 2007 for Beginners
  • Microsoft Access 2007 Beginner - Intermediaet
  • Microsoft Office
  • Designing Database
  • Creating Tables
  • Running Queries
  • Reports

Teachers and trainers (1)

Mandy Jones

Mandy Jones

ICT Trainer

Qualified and Experienced ICT trainer who brings significant knowledge, skills and experience in the use of Microsoft Office Applications from Beginner to Advanced Levels. Mandy supports learners in a professional and relaxed manner, through a range of practical exercises, enabling them to develop their knowledge and skills in ways that enable them to apply what they have learnt in the workplace.

Course programme

Microsoft Access for Beginners introduces you to the creation of a Microsoft Access 2007 database and understanding how relational databases work. The training demonstrates how to organise data into tables while using queries and filters to access specific data information.

Upon completion the delegate will be able to:

  • Open, save & close Access databases
  • Use the Access help system & the Office Assistant
  • Enter, edit & delete information using tables & forms
  • Create tables, forms & reports using wizards & Design View
  • Modify Access database objects using Design View
  • Sort & filter information held in an Access database
  • Create select queries to extract & sort information
  • Preview & print Access database objects

Additional information

This course is an introduction to Microsoft Access, designed for learners who have never used Access before and might be unfamiliar with database software in general. It introduces the learners to the basic concepts of a relational database system as well as some of the things that are possible with Microsoft Access. This direct delivery programme is an interactive course, packed with exercises and provides a good foundation on which to continue learning and creating applications with Microsoft Access and Visual Basics.   Upon completion of the course, delegates will be able to:
 •Organize data efficiently by using a database management system; start Access and open Access databases; and use the Help feature.
 •Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
 •Modify a table’s design; use the attachment data type; find and replace data; sort, filter, and delete records.
 •Set field properties, create input masks, and set validation rules.
 •Create queries, and sort and filter the results; modify queries; and perform operations in queries.
 •Creat

Microsoft Access 2007 - Beginners

£ 149 VAT inc.