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.
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 |