Course Subjects

Contact Us

Need Help

 
Microsoft Access: Introduction (Level 1)   

This intensive, hands-on training course is designed to give delegates an understanding of some of the major features and functions within Microsoft Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given.

Scheduled Course Dates and Prices

Duration: 1 Day

Public Course Price: £99
1-to-1 price: £199

Scheduled Dates: spacer
Wednesday 28th April 2010

If you can't come to us we can come to you! All courses are available as individual 1:1 tuition or small groups at your office as well as at our centre. Please click here for more information.

Who Should Attend  

New, recent or intending users of Access 2003 who have little or no existing database knowledge.

Prerequisites 

Because of the amount of material we cover in class, we do require students to be comfortable using a mouse, opening and saving files, and the general operations of computers. While we will make every reasonable effort to help, students with insufficient skills may be required to undertake a IT skills course as to not slow down the rest of the class.

Performance-Based objectives  

Course Outline

Starting Out:
Basic Terminology 
Opening Microsoft Access 
Interface Overview 
Closing Microsoft Access 

Using the Access Interface:
UsingThe Access Menus 
Access Task Panes 
Using Toolbars 
Adding, Removing, and Moving Toolbars 
The Switchboard 
Using the Database Window 

Getting Help:
The Help Menu 
The Help Task Pane 
The Office Assistant 
Using the Type a Question Box 
Getting Help in a Dialog Box 
Using the Sample Databases 

First Steps:
Planning a Database 
Creating a Blank Database 
Database Objects 

Records:
What is a Record? 
Adding Records 
Editing Records 
Deleting Records 
Printing Records 

Creating a Table:
About Tables 
Creating a Table in Design View 
Creating a Table using the Wizard 
Entering Data into a Table 
Formatting a Table 

Formatting Text:
The Zoom Toolbar 
Selecting Data 
Cutting, Copying, and Pasting 
The Format Painter 
Undo and Redo 
Checking your Spelling 

Formatting Controls:
Changing the Colour of a Control 
Control Properties 
Aligning Controls 
Applying Special Effects 

Creating Forms:
What is a Form? 
Bound vs. Unbound Controls 
Creating a Form with the Wizard 
Creating a Form in Design View 
Using Forms 

Creating Queries:
What is a Query? 
Creating a Query with the Wizard 
Using Design View to Modify a Query 
Using Queries 

Reports:
What is a Report? 
Creating a Report with the Wizard 
Creating a Report in Design View 
Using Reports 

Sorting and Filtering Data:
Using Find and Replace 
Sort Ascending or Descending 
Using Filter by Form 
Using Filter by Selection 
Creating a Filter 

Formatting a Datasheet:
Adjusting Row Height and Column Width 
Rearranging Columns 
Freezing a Row or Column 
Hiding a Column 
Changing the Datasheet Font 

Viewing Data:
The View Menu 
The Window Menu 
Hiding and Unhiding Windows 
Arranging Windows 
Closing Individual Windows 

Printing a Database Object:
The Print Icon 
Print Preview 
Page Setup 

Course Times

Class time is 10:00 a.m.- 4:30/5:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled between 1-2 pm. We provide you with Tea, Coffee, Biscuits and other refreshments on the house. We also have a fridge and a microwave available for you to store/warm up any food you wish to bring along for your lunch.

Related Courses

We recommend the following courses that relate to this class: Microsoft Access Intermediate and Microsoft Excel Introduction

Back to top

 

Microsoft Access Level 2

Microsoft Excel

Our Location