£185 (includes course materials, lunch and refreshments) Corporate rates available please contact us for further information
Intending, new or recent users of Access 2003.
Delegates should be familiar with the Windows operating system. No knowledge of Access 2003 is expected.
Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.
This practical course will introduce the delegate to Access 2003. It will provide “hands on” experience of many of the features found in this programme. By the end of the course, the user will be competent with the following skills:
Fundamentals
- Menus
- Toolbars
- The Task Pane
- The Taskbar
- Help
Databases
- Database Principles
- Create a New Database
- Open an Existing Database
- Database Views
- Save and Close a Database
Tables
- Create a Table
- Change Field Properties
- Move Around in a Table
- Change Column Width
- Change Row Height
- Freeze, Move and Hide Columns
- Format a Table
- Preview and Print a Table
- Find Specific Text
- Add, Edit and Delete Records
- Cut, Copy and Paste
- Use Undo to Correct Errors
- Use Shortcuts to Enter Data
Sort and Filter Data
- Sort Records
- Filter by Selection
- Filter Excluding Selection
- Filter by Form
- Filter for Specific Text
- Advanced Filters/Sort
Queries
- Ranges of Values
- Patterns
- Non-Matches
- Current Date Query
- And Queries
- Or Queries
- Multiple Table Query
Forms
- Create, Edit and Format Forms
- Use AutoForm
- Add and Delete Records
- Preview and Print a Form
Reports
- Create a Report
- Use AutoReport
- Use Report Wizard
- Preview and Print a Report
This course outline is a guide. All our courses can be tailored to customer requirements.
Microsoft Access 2003 Intermediate or explore the benefits of using other Office applications including Excel, Word, PowerPoint or Project.
Microsoft Office Specialist
(MOS 2007)
MOS - Excel
MOS - Word
MOS - PowerPoint
MOS Outlook
MOS Access
Intensive Training (Office 2007)
Government funding available for local businesses through Train to Gain Enhancement Fund.
Click on icon to print this page
Email: info@ictacademy.co.ukTel: 01302 554958Address: ICT Academy, DBIC, Doncaster, DN4 5QA