Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per course

£495 for any two half day courses +VAT
Client site, max 10 individuals

Duration

Half day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

Contact us for the latest course dates.

Book course

This course is intended for users who are required to view, find, add, edit and delete data in an existing database.

Objectives:

To understand the purpose of the four main database objects: Tables, Queries, Forms and Reports. Users will be able to open and close Access objects, navigate between the existing database records and update the data in the database.

Prerequisites:

Users must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close windows.

Download Outline (PDF)

Introducing Access Databases
  • Opening & Closing a Database
  • Opening Objects using the Navigation Pane
  • Opening & Closing Tables, Queries, Forms & Reports
Working with Data in Tables
  • Navigating Table Data
  • Entering, Editing & Deleting Records
  • Sorting & Filtering Data in a Table
  • Showing & Hiding Columns
Working with Forms
  • Navigating Records in Forms
  • Finding Records
  • Adding New Records
  • Editing & Deleting Records
  • Sorting & Filtering Data in a Form
Previewing Data in Reports
  • Opening Reports in Report View
  • Previewing & Printing Reports

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.