Course not currently available
Microsoft Access 2000 Introduction
-
We had a pretty nice experience with this course. Intially we were provided the professional course but our requirement was for the bespoke course. The trainer was very kind and patient enough to design the complete course again to a bespoke one.
I would rate it a 4 for the sales person was not dedicated for the work and was not listening carefully.
← | →
Short course
In Reading ()
Description
-
Type
Short course
-
Duration
1 Day
This 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 is given, as well as hints and tips on good database design techniques. Suitable for: New, recent or intending users of Microsoft Access 2000 who have little or no existing database knowledge. Note: A working knowledge of using PCs in the Microsoft Windows environment is required.
Reviews
-
We had a pretty nice experience with this course. Intially we were provided the professional course but our requirement was for the bespoke course. The trainer was very kind and patient enough to design the complete course again to a bespoke one.
I would rate it a 4 for the sales person was not dedicated for the work and was not listening carefully.
← | →
Course rating
Recommended
Centre rating
Maria
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 15 years
Subjects
- Access
- Database Design
- Windows
- Database
- Database training
- Microsoft Access XP
- Design
- Design techniques
- Property
- Microsoft Access
Course programme
This 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 is given, as well as hints and tips on good database design techniques.
Who Should Attend?
New, recent or intending users of Microsoft Access 2000 who have little or no existing database knowledge. Note : A working knowledge of using PCs in the Microsoft Windows environment is required.
Course Outline: Microsoft Access 2000 Introduction
Introduction to Databases
· What is a Database? · Computerising a Database · Designing an Access Database · Defining a Data Store · Populating a Database · Extracting Information from a Database · Reporting Data · Year 2000 Best Practice
Getting Started with Access 2000
· Starting Access 2000 · Access 2000 Opening Screen · The Title Bar · The Menu Bar · Toolbars · The Status Bar · Menus and Submenus · SpeedKeys · The Database Window · The Database Window Toolbar · Scroll Bars · Exiting Access
Getting Assistance with Access 2000
· Using the Office Assistant · Getting Help Without the Office Assistant · Manipulating the Help Window · Help for Screen Objects - ScreenTips
Creating Tables and Adding Records
· Creating a Table Using the Table Wizard · Datasheet View · Adding a Record · Saving Changes · Moving Around the Datasheet · Finding a Record · Modifying Records · Deleting a Record
Designing Table Structures
· Table Design - Hints and Tips · Creating Tables · Switching Between Views · Saving Tables · Field Properties · Field Size Property · Format and Input Mask Properties · Caption Property · Default Value Property · Required Property · Allow Zero Length Property · Indexed Property
Working with Data
· Sorting Data · Filtering Data · Using Advanced Filters
Forms
· Creating a Form · Filling in a Form
Simple Select Queries
· What is a Query? · Creating a Query · Modifying a Query · Restricting Records Returned by a Query · Simple Calculated Fields · Summary Queries
Simple Reports
· Reporting from Access · Printing from Datasheet View · AutoReports · Designing a Report Using Report Wizards · Label Reports · Modifying Reports
Microsoft Access 2000 Introduction