Part of our range of Microsoft Access 2003 Training Courses in Manchester.
|
| Course Title: |
Microsoft Access 2003 Training Courses (Introduction) |
|
|
Course Overview For Microsoft Access 2003 Training Courses (Introduction)This course is designed for the new or inexperienced user who has a need to use the programme on a regular basis, but who has had no formal or structured training and is likely to be self taught.
Delegates attending the course will be able to understand databases, create, manage and format data and use the various tools and shortcuts available within Access to do so in an efficient and timely manner. This will enable the delegate to interrogate the data and create informative reports. |
|
| |
Course Content Of Microsoft Access 2003 Training Courses (Introduction)
A typical course will cover the following:-
The Access Environment
- The Database Window
- How Access Stores Data
- Examine An Existing Database
MS Access 2003 Orientation
- Opening An Existing Database
- Working With Database Objects
- Using Menu Commands
- Using Keyboard Shortcuts
- Exiting From Access
Create A Simple MS Access 2003 Database
- Using The Wizard
- Using Design View
- Data Types
- Name A Table
Managing Access Table Data
- Navigating Around A Table
- Edit A Record
- Delete Records
- Find And Replace Data
- Print Tables
Formatting Access 2003 Table Data
- Change Column Widths
- Format The Datasheet
- Move Columns
- Freeze Columns
- Hide And Unhide Columns
|
Sorting & Filtering Table Data in Access 2003
- Sorting On One Column
- Sorting On Several Fields
- Create A Filter
- Clear A Filter
- Filter By Exception
- Filter By Form
Select Queries in Access 2003
- Creating A Select Query
- Adding Selection Criteria
- Clearing Criteria
- Query Using Wildcards
- Query With Logical Operators
- Save And Reuse A Query
Microsoft Access 2003 Forms
- Creating A New Form Using The Form Wizard
- Working With A Form
- Understanding Form Objects
- Modifying Fields In A Form
- Moving Fields On A Form.
- Creating A Form From A Query
MS Access 2003 Reports
- Creating A Report Using The Report Wizard
- Preview A Report
- Print A Report
- Create A Report From A Query
|
Download As A PDF
To find out more about how Copernicus Training can help your business, please call us on 0870 - 879 - 5327
or e-mail us at info@copernicus-training.com
|
