Dreamweaver course in north London

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.

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

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.

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 

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.

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

Course Duration 1 Day
Private Course Price and dates This course is only available as individual 1:1 on a bespoke
Please call centre on 0208 443 2888 for a quote and to arrange dates
Course Times 10:00 till 16:00