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 individual

£395 +VAT
Public course

Cost per course

£1,100 +VAT
Client site, max 10 individuals

Duration

2 Days

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

14/01/2019 Liverpool
04/02/2019 Bradford
29/04/2019 Liverpool
28/05/2019 Bradford

Book course

This course is intended for users who need to design and create basic databases in Microsoft Access.

Objectives:

By the end of the course, users will be familiar with the concepts of a relational database and be able to create a multi-table database. They will be able to interrogate and present data using queries and reports and create simple Access Forms to view and input data on screen.

Prerequisites: Users must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close. Familiarity with either Word or Excel would be useful, but is not essential. 

Download Outline (PDF) 

Database Basics
  • Introducing Databases
  • The Access Objects
Navigation & Data Entry
  • Opening Tables
  • Navigating in Datasheet View
  • Searching & Finding Records
  • Adding & Deleting Records
  • Selecting in a Table
Creating Databases & Defining Tables
  • Database Design Techniques
  • Creating & Saving a Database
  • Creating Tables
  • Inserting, Deleting & Moving Fields
  • Changing Field Data Types
  • Modifying Field Properties
Relationships & Look-ups
  • What is a Relational Database?
  • Relationship Types
  • Primary & Secondary Key Fields
  • Creating a Relationship
  • About Lookups
  • Referential Integrity
Working with Data in Tables
  • Changing the Look of Data
  • Sorting in Tables
  • Formatting Datasheet View
  • Filtering Data
Queries
  • Creating & Running Queries
  • Adding Criteria to Queries
  • Understanding Query Dynasets
  • Multi-Table Queries
  • Setting Field Properties
Forms
  • AutoForms & the Form Wizard
  • Multi-Table Forms
  • Designing Forms
  • Formatting Controls
  • Setting Control Properties
Reports
  • Creating Reports using Report Wizard
  • Creating Mailing Labels
  • Report Sections
  • Form Design vs Report Design
  • Summary Reports
Printing in Access
  • Printing from Tables & Queries
  • Printing Forms & Reports

Book a course

Fill in your information to book this course. The information you provide on this booking 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.

Booking Form

Please select a date and location from the dropdown to add attendees

There are not enough spaces at this location for this many attendees. Please remove 0 attendees before continuing.

spaces remaining

If you just wish to enquire about this course click here