Microsoft Access Introduction

Microsoft Access Introduction

Cost

£125+VAT

Next Date

13/11/2018

Duration

One to Two Days

Microsoft Access Introduction

Course Description

This course is to introduce delegates to the usage of Access and give them the ability to enter data and do basic interrogation. The course can be compressed to one day for an exceptional or experienced group of delegates (small group).

Course Objectives

By the end of the course, delegates will be confident in using basic features of Access including amending existing databases and creating custom reports.

Course Content

Introduction
The importance of company news
What do people actually want to read?

Style and tone
What is the primary message?
Formal vs informal newsletters
Selecting a style and tone
Creating eye catching headlines

Industry and company news
Making internal news interesting, relevant and readable
Potential news ideas - awards, diary events, industry trends, appointments
Making information come alive

Feature writing
Choosing topics for features
How to structure features
Keeping features on-message
Reporting on company events
What to include and what to exclude
The importance of photography
Using photos to increase your readership
Reporting on events
Using interviews and quotes
Involving your audience

Writing newsletters
Deciding the look and feel of your newsletters
Prioritising news and information for your readers
Getting the right balance between industry news, company news, features and interviews in your newsletters
Regular columns
Encouraging feedback and involvement from readers

Feedback
Measuring reader response
Measuring how successful your communication has been

Introduction
What is a database
What is a relational database (not building one)
Basic terminology
Data types – text, number, date, etc.
The Access windows
Getting into Access
Creating new tables
Validation rules and indexes

Opening an existing database
The editing keys
Modifying data
Deleting data
Adding new data
Searching for records to modify
Changing the table / query view)
Moving columns
Sizing columns | Side reference areas

Changes to fonts and gridlines
Printing table data

Designing queries and simple related queries
Selecting fields
Filtering records (search criteria)
Creating ad-hoc relationships
Derived fields and the expression builder
Formatting field calculated fields
Printing queries

Basic query types
Select queries
Summary aggregate queries*

Reports
Basic columnar reports and using report wizard
Creating custom reports
Adding grand totals
Adding dates and page numbers
Derived field types in reports and field properties*
Grouping and subtotalling*

Creating data entry forms
Using the wizards
Modifying forms*
Using and creating filters in forms
Query by selection
Filter by form
Using data entry forms

Relationships
Principles*
Linking queries*

Related courses

Microsoft Access Intermediate

Microsoft Access Advanced

Microsoft Excel Advanced

BOOK THIS COURSE

Simply complete the form below and we'll come back to you as soon as possible