Home /
Training Courses /
Microsoft Access 2000 Fundamentals (2 days)
Microsoft Access 2000 Fundamentals (2 days)
Training Description
The skills and knowledge acquired in Microsoft Access 2000 Fundamentals are sufficient to be able to use and operate the software at an efficient level.The Course Suits
Microsoft Access 2000 Fundamentals is designed for users who are keen to extend their understanding and knowledge of the software. Microsoft Access 2000 Fundamentals assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.Training Benefits
At the completion of Microsoft Access 2000 Fundamentals you should be able to:
- start Microsoft Access and work with the various windows and objects.
- create a database file and a data table
- work with records in a relational database
- navigate a table and edit and delete data
- change the way that data in a table appears
- sort and filter data in a table
- create select queries and display data according to specified criteria
- create and use forms which assist you working with your data
- create and run reports from data in a table and in queries
- design relational databases
- use data validation techniques to protect the integrity of the data
- create relational databases
- set table relationships in a database
- add records to a relational database
Course Timetable
The course focuses on practical work within the product giving delegates ample opportunity to use their PC skills through a series of graded exercises.Topics covered include:Access 2000 Orientation
Starting Access 2000
Opening An Existing Database
The Access 2000 Database Screen
The Database Window
Working With Database Objects
Exiting From Access 2000
Creating A New Database
Creating A New Database File
How Access Stores Data
Access 2000 Data Types
Designing A Database Table
Creating A New Table
Changing Field Properties
Adding Records In A Table
Adding Records Using An AutoForm
Creating A Reusable AutoForm
Adding Records Using A Form
Assignment – Adding Records
Importing Data From Microsoft Excel
Closing A Database File
Working With Records
Navigating In A Table
Editing A Record
Deleting A Record
Deleting Several Records
Finding And Replacing
Undoing An Error
Compacting A Database
Printing Records
Working With Sub Datasheets
Assigning A Sub-Datasheet
Managing Table Data
Navigating In A Table
Editing A Record
Deleting A Record
Deleting Several Records
Finding And Replacing
Undoing An Error
Compacting A Database
Printing Records
Formatting Table Data
Changing Column Widths
Changing Column Headings
Formatting The DataSheet (Table)
Changing Fonts
Moving Columns
Freezing Columns
Hiding Columns
Unhiding Columns
Sorting And Filtering Table Data
Simple Sorting
Sorting On Several Fields
Creating A Simple Filter
Clearing A Filter
Filtering By Exception
Filtering By Form
Select Queries
Select Queries – How They Work
Creating A Query Design
Different Views Of A Query
Working With Fields In A Query
Selecting Records Using A Query
Clearing All Selection Criteria
Assignment – Select Queries
Querying Using Wildcards
Querying - Problem characters
Querying With Logical Operators
Saving And Reusing A Query
Calculated Fields In A Query
Changing Column Headings In A Query
Formatting Query fields
Queries That Summarise Data
Forms
Forms – How they Work
Creating A New Form Using The Form Wizard
Working With A Form
Understanding Form Objects
Modifying Field Widths In A Form
Moving Fields On A Form
Adding A Label To A Form
Changing The Properties of A Form Object
Adding A Picture To A Form
Changing The Background Of A Form
Changing A Field To A Combo Box
Using A Combo Box Control On A Form
Creating A Form From A Query
Reports
Reports - How They Work
Creating A New Report Using The Report Wizard
Previewing A Report
Printing A Report
Understanding Report Bands
Moving Field Objects On A Report
Formatting A Report
Removing Headers And Footers
Adding A Header To A Report
Formatting Headers In A Report
Forcing A New Page
Adding A Page Footer To A Report
Adding A Report Footer To A Report
Formatting Footers In A Report
Creating A Grouped Report
Creating A Report From A Query
Database Design
Designing A Relational Database
Scoping The System
Determining The Inputs
Normalising A Table
First Normal Form (1NF)
Second Normal Form (2NF)
Second Normal Form - Case Study
Third Normal Form (3NF)
Data Validation
Assigning Default Values
Marking A Required Field
Validation Rules And Text
Creating A LookUp Field
Working With Validations
Creating Relational Databases
Creating A New Database File
Access 2000 Data Types
Creating A New Table
Changing Field Properties
Creating A Table From A Shortcut
Creating A Table With Numbers And Currency
Assignment - Creating Tables
Setting Table Relationships
Understanding Table Relationships
Accessing The Relationships Window
Table Joins In The Rostrum Case Study
Creating Table Joins
Assignment - Creating Relational Joins
Editing An Existing Relationship
Printing Table Relationships
Adding Relational Records
Adding Records In A Table
Adding Records Using An AutoForm
Assignment - Adding Records
Data Entry Key Violations
Data Integrity Violations
© PTP/A3M1
Please Choose from the list below:
Quick Training Search
-
- Training Courses
- Customer Care Training
- Assertiveness & Building Personal Confidence
- Body Language - The Hidden Secret of Communicating Successfully
- Brand Building with the Public
- Call Centre - Achieving Best Practice
- Customer Care
- Customer Excellence for Finance Staff
- Customer Satisfaction as a Selling Tool
- Dealing with Difficult People
- Dealing with Incoming Calls Positively
- Enhancing the Visitors Experience
- Excellent Customer Care - Incoming Calls
- How to say 'No' and retain Customer Satisfaction
- Introduction to Account Management
- Outstanding Customer Service Skills
- Professional Writing Skills
- Relationship Marketing
- Through the Customers' Eyes
- Finance and Planning Training
- Finance and Planning Training
- Business Skills for Administrators
- Credit Control
- Customer Excellence for Finance Staff
- Cutting Costs and Waste in Your Office
- Finance for Marketing and Sales People
- Finance For Non-Finance Managers
- Interpreting Financial Statements
- Investor and Entrepreneur Skills
- Managing Budgets
- Practical Project Management (2 day course)
- Prince2 Practitioner - 5 Day Course
- Project Management
- Successfully Setting and Achieving Business Objectives
- Sustaining Effective Financial Control
- Finance Management
- Time Management Training
- Managing Effective Meetings
- Personal Organisation Skills for Secretaries & PAs
- Planning & Prioritisation for the Busy Sales Person
- Planning Sales Activity to Help Meet & Exceed Targets
- Speed Reading & Information Management
- Successfully Setting and Achieving Business Objectives
- Time Management
- Work-Life Balance
- Finance and Planning Training
- IT Courses
- Microsoft Access Courses
- Microsoft Access 2000 Fundamentals (2 days)
- Microsoft Access 2000 Specialised (2 days)
- Microsoft Access 2003 Fundamentals (2 days)
- Microsoft Access 2003 Specialised (2 days)
- Microsoft Access 2007 Fundamentals (2 days)
- Microsoft Access 2007 Specialised (2 days)
- Microsoft Access VBA (2 days)
- Microsoft Access XP Fundamentals (2 days)
- Microsoft Access XP Specialised (2 days)
- Microsoft Excel Courses
- Microsoft Excel 2000 Advanced
- Microsoft Excel 2000 Fundamentals
- Microsoft Excel 2000 Intermediate (2 days)
- Microsoft Excel 2003 Advanced
- Microsoft Excel 2003 Fundamentals
- Microsoft Excel 2003 Intermediate (2 days)
- Microsoft Excel 2003 Upgrade
- Microsoft Excel 2007 Advanced
- Microsoft Excel 2007 Fundamentals
- Microsoft Excel 2007 Intermediate (2 days)
- Microsoft Excel 2007 Upgrade
- Microsoft Excel VBA (2 days)
- Microsoft Excel XP Advanced
- Microsoft Excel XP Fundamentals
- Microsoft Excel XP Intermediate (2 days)
- Microsoft Outlook Courses
- Microsoft Outlook 2000 Fundamentals
- Microsoft Outlook 2000 Specialised
- Microsoft Outlook 2002 Fundamentals
- Microsoft Outlook 2003 Fundamentals
- Microsoft Outlook 2003 Specialised
- Microsoft Outlook 2003 Upgrade
- Microsoft Outlook 2007 Fundamentals
- Microsoft Outlook 2007 Upgrade
- Microsoft Outlook XP Specialised
- Microsoft PowerPoint Courses
- Microsoft PowerPoint 2000 Fundamentals
- Microsoft PowerPoint 2000 Specialised
- Microsoft Powerpoint 2002 Fundamentals
- Microsoft Powerpoint 2002 Specialised
- Microsoft PowerPoint 2003 Fundamentals
- Microsoft PowerPoint 2003 Specialised
- Microsoft PowerPoint 2003 Upgrade
- Microsoft PowerPoint 2007 Fundamentals
- Microsoft PowerPoint 2007 Specialised
- Microsoft PowerPoint 2007 Upgrade
- Microsoft Word Courses
- Microsoft Word 2000 Advanced
- Microsoft Word 2000 Fundamentals
- Microsoft Word 2000 Intermediate
- Microsoft Word 2002 Fundamentals
- Microsoft Word 2002 Intermediate
- Microsoft Word 2003 Advanced
- Microsoft Word 2003 Fundamentals
- Microsoft Word 2003 Intermediate
- Microsoft Word 2003 Upgrade
- Microsoft Word 2007 Advanced
- Microsoft Word 2007 Fundamentals
- Microsoft Word 2007 Intermediate
- Microsoft Word 2007 Upgrade
- Microsoft Word VBA (2 days)
- Microsoft Word XP Advanced
- Miscellaneous Microsoft Courses
- Microsoft FrontPage 2000 Fundamentals
- Microsoft Project 2000 FastPath
- Microsoft Project 2000 Level 1 (2 days)
- Microsoft Project 2000 Level 2 (2 days)
- Microsoft Project 2002 Level 1 (2 days)
- Microsoft Project 2003 FastPath
- Microsoft Project 2003 Level 1 (2 days)
- Microsoft Project 2003 Level 2 (2 days)
- Microsoft Project 2007 FastPath
- Microsoft Project 2007 Level 1 (2 days)
- Microsoft Project 2007 Level 2 (2 days)
- Microsoft Project XP FastPath
- Microsoft Publisher 2003 Fundamentals
- Microsoft Visio 2000 Fundamentals
- Microsoft Visio 2000 Specialised
- Microsoft Visio 2002 Fundamentals
- Microsoft Visio 2002 Specialised
- Microsoft Visio 2003 Fundamentals
- Microsoft Visio 2003 Specialised
- Microsoft Visio 2007 Fundamentals
- Microsoft Visio 2007 Specialised
- Microsoft Windows Vista New Features
- Non-Microsoft Courses
- Microsoft Access Courses
- Management Training
- Green Management
- HR and Recruitment Training
- Appraisee Training
- Appraising Performance Effectively
- Developing Your PA Potential to Ensure Success
- HR Skills For Line Managers
- Influencing Skills
- Managing Appraisals
- Managing Difficult Staffing Situations
- Managing Sickness And Absences
- One-To-One and Small Group Training
- Performance Review Skills
- Recruiting the Best People
- Successful Interviewing
- Understanding Discipline and Grievance
- Walk, Talk, Stance for Maximum Impact
- Interview Training
- Introductory Skills
- Developing Your PA Potential to Ensure Success
- Essential Management Skills (2 Days)
- Introduction to Facilitation Skills
- Introduction to Green Office Management
- Introduction to Management and Supervisory Skills
- Introduction to NLP
- Introduction to Quality Management
- Managing Budgets
- Successfully Setting and Achieving Business Objectives
- Leadership Skills
- Creative Problem Solving
- Introduction to Management and Supervisory Skills
- Leadership & Management Skills
- Management by Coaching
- Senior Management Skills
- Success in Leadership & Motivation Skills
- Successful International Joint Venture Teamworking
- Successfully Setting and Achieving Business Objectives
- Team Building
- The Roles and Responsibilities of a Director
- Walk, Talk, Stance for Maximum Impact
- Management and People Skills
- Advanced Facilitation Skills (1 Day)
- Advanced Listening Skills
- Assertiveness & Building Personal Confidence
- Body Language - The Hidden Secret of Communicating Successfully
- Building Excellent Working Relationships
- Communication Skills
- Creativity and Innovation (1 day course)
- Dealing with Difficult People
- Effective Management of Your Team
- Essential Management Skills (2 Days)
- First Line Manager Skills
- Getting Results
- HR Skills For Line Managers
- Introduction to Facilitation Skills
- Introduction to Management and Supervisory Skills
- Management by Coaching
- Management Skills - How to Survive and Thrive
- Managing Change
- Managing Conflict
- Managing Effective Meetings
- Managing People on Projects
- Maximising Performance by Influencing and Persuading
- Motivation Skills
- People Management
- Performance Management
- Performance Review Skills
- Practical Project Management (2 day course)
- Re-Energising a Stalled Change Campaign
- Senior Management Skills
- Success in Leadership & Motivation Skills
- The Internal Consultant
- The Practical MBA - Managing By Your Actions (2 day course)
- Walk, Talk, Stance for Maximum Impact
- Work-Life Balance
- Working Globally Inter-Cultural Communications
- Management Finance
- Networking & Sales Skills for Managers
- Advanced Facilitation Skills - (2 Days)
- Coaching Skills for Sales Managers
- Introduction to Blogging
- Introduction to LinkedIn
- Introduction to Twitter
- Maximising Performance by Influencing and Persuading
- Negotiation Skills
- Networking For Success
- Referral Marketing
- Successful International Joint Venture Teamworking
- Walk, Talk, Stance for Maximum Impact
- Presentation
- Project Management
- Sales Management
- Strategy and Risk Management
- Time Management Skills
- Training and Coaching Skills
- Advanced Facilitation Skills (1 Day)
- Coaching and Mentoring
- Coaching Skills
- Introduction to Facilitation Skills
- Introduction to Management and Supervisory Skills
- Management by Coaching
- Managing the Training Function
- One-To-One and Small Group Training
- The Creative Trainer
- Train the Trainer (2 day course)
- Train the Trainer (one day course)
- Walk, Talk, Stance for Maximum Impact
- Personal Development
- Appraisee Training
- Assertiveness & Building Personal Confidence
- Body Language - The Hidden Secret of Communicating Successfully
- Building Excellent Working Relationships
- Building Personal & Professional Confidence
- Business Skills for Administrators
- Communication Skills
- Creative Problem Solving
- Creativity and Innovation (1 day course)
- Creativity and Innovation (2 Day Course)
- Cutting Costs and Waste in Your Office
- CV Writing and Interview Confidence Building
- Developing Your PA Potential to Ensure Success
- How to Learn Anything Quicker
- Influencing Skills
- Introduction to Twitter
- Maximising Performance by Influencing and Persuading
- People Management Skills for Secretaries & Pas
- Personal Development for Professionals
- Personal Effectiveness
- Personal Organisation Skills for Secretaries & PAs
- Preparing Yourself for Interview
- Professional Writing Skills
- Self-Discipline and Emotional Control in the Workplace
- Speed Reading & Information Management
- Stress Management
- The Effective Administrator
- The Green Worker
- Work-Life Balance
- Write to the Top! - Professional Report Writing
- Sales Training
- Face to Face Selling Skills
- Advanced Closing Skills
- Body Language - The Hidden Secret of Communicating Successfully
- Closing The Sale & Dealing With Objections
- Confidence in Making Face to Face Cold Calls
- Introduction to Sales - From Emerging Salesperson to Buying Advisor
- Successful Sales Presentations
- The Client Meeting - Face to Face Selling
- Walk, Talk, Stance for Maximum Impact
- Winning More Business in the Final Meeting (2 day course)
- General Sales Skills
- Advanced Closing Skills
- Advanced Listening Skills
- Advanced Selling Skills (2 day course)
- Closing The Sale & Dealing With Objections
- Consultative Selling
- Customer Satisfaction as a Selling Tool
- Developing Major Accounts
- How to Learn Anything Quicker
- Introduction to Account Management
- Introduction to Blogging
- Introduction to NLP
- Introduction to Sales - From Emerging Salesperson to Buying Advisor
- Introduction to Twitter
- Key Selling Skills
- Managing Major Accounts (2 day course)
- More Advanced Selling Skills
- Planning Sales Activity to Help Meet & Exceed Targets
- Selling for Non-Sales Professionals
- Successful Sales Presentations
- The Art of Retail Selling
- The Secrets of Low Cost Advertising
- Through the Customers' Eyes
- Marketing Skills
- Brand Building with the Public
- Essential Advertising
- Essential Marketing Skills
- Introduction to Account Management
- Introduction to Blogging
- Introduction to Twitter
- Networking For Success
- Referral Marketing
- Relationship Marketing
- The Secrets of Low Cost Advertising
- Walk, Talk, Stance for Maximum Impact
- Marketing Training
- Negotiation, Objection Handling and Closing Skills
- Presentation Skills
- Sales Management and Coaching Skills
- Sales Writing Skills
- Telemarketing Training
- Telephone Sales Skills
- Advanced Telephone Prospecting
- Closing Incoming Calls Effectively
- Gaining Commitment on the Telephone
- Generating New Business by Telephone
- Maximising Appointments on the Telephone
- Outgoing Calls - Maximising Effectiveness
- Telephone Techniques - Incoming & Outgoing Calls
- Winning More Business on the Telephone
- Face to Face Selling Skills
- Customer Care Training
- Training Courses
To perform a free text search for courses enter your chosen keyword/s below:
Special offers
Click here to find training related special offers in your area special offers
Open course schedule
One day open course schedule for the next month more info
U-Choose
Can't find the right date?
Can't find the right venue?
With U-Choose you can build the training package of your specification more info
Download our brochure
To download our brochure please click
here
To download our 2011 Open Schedule click
here
Special Offers Subscription
Subscribe to receive our special offers.