ByteBack Training
IT Training providers based in North Wales
- 07770 472488
- Contact
Contact Sue Jackson to discuss your training needs; look forward to hearing from you!
Microsoft Access
These are outlines of what we hope to cover during the course. The course outlines are not written in stone and each course may vary slightly to meet the needs of the group attending
An Introduction to Microsoft Access
Microsoft Access is a very powerful database application designed to save time and make creating relational databases easier. This one-day Access training course, introduces delegates to the concepts of creating and using a relational database.
Prior Knowledge: No previous knowledge of Access is needed
Aims and Objectives: By the end of the course participants will be able to:
- Understand database concepts
- Open and close Access
- Open an existing Database
- Understand the Access Screen
- Use the Help
- Create a new database
- Create tables
- Edit tables
- Use datasheet view
- Use field properties
- Change row height and column width
- Find, sort and filter data
- Print data
- Page set-up
- Create and understand simple relationships
- Set referential integrity
- Use related tables
- Create and use queries
- Create and use forms
- Create and use reports
- MailMerge from Word using your Access DataBase
Microsoft Access 2002, 2003 or 27 Intermediate
Prior Knowledge: This one-day course is intended for delegates with experience of Access who need to develop more advanced skills. The course will demonstrate how the many new features in Access can be used effectively.
Aims and Objectives: By the end of the course participants will be able to:
- Modify tables
- Insert Lookup columns
- Set field properties
- Set Yes/No formats
- Set default values
- Propagate field properties
- Use Operators in Queries
- Use And/Or/Between conditions
- Design Advanced Queries
- Create calculated fields
- Create Action Queries example
- Create an Update Query
- Use the Advanced Query to Find Duplicates
- Use advanced database features
- Importing Data
- Use advanced form design example
- Create Combo Boxes
- Use advanced report design
- Group Data in a Report
- Create and use subforms and subreports
Microsoft Access 2002, 2003 or 2007 Advanced
Prior Knowledge:This one-day course aims to build on a reasonable level of database design experience that may have been gained from attending the Microsoft Access Introduction course and the Microsoft Access Intermediate training course. This module introduces you to macros and custom toolbars. Tasks include creating and using macros and working with switchboards. You will also learn how to create custom toolbars and export data to Excel and Word.
Aims and Objectives By the end of the course participants will be able to understand
- Database Concepts & Design
- Types of Relationship
- Creating Links & Referential Integrity
- Using Switchboards
- Create, opening and use a switchboard form
- Adding a command button to a switchboard
- Setting startup options
- Working with macros
- Opening the macro design window
- Creating a macro Assigning an argument to an action
- Saving a macro
- Running a macro
- Editing an existing macro
- Running a macro using the Tools menu
- Assigning a macro to a control
- Creating a command button
- Adding a condition to a macro
- Creating a group macro
- Creating an Autoexec macro
- Creating a Custom Toolbar
- Exporting Data to Excel and Word
The course outlines are only suggestions, I will happily prepare a course for your individual requirements. These are outlines of what we hope to cover during the course. The course outlines are not written in stone and each course may vary slightly to meet the needs of the group attending.
You will be amazed how much you can learn in one day! Yes, the courses are lively and quite intensive but as a maximum of 9 people attend each course I am able to tailor each course so that everyone attending will benefit fully from the training.
If you need bespoke training or training in your own offices please call to discuss your needs.
Self teach kits are also available with an easy to follow manual, exercises and an email helpline.
By booking your training with us you will be helping to support and develop a sustainable, not for profit IT resource within the Communities First area, encouraging more community engagement and raising awareness of other leisure time activities locally.
 Follow ByteBack on Twitter»
|
© ByteBack Training '09
Sue Jackson trading as ByteBack Training. Oak Trees, 4 Pen y Bryn Road, Colwyn Bay, Conwy LL29 6AF. Tel: 07770 472488. Email: sue@bytebacktraining.co.uk
ByteBack Training - Freelance IT Training specialist. Offering courses in Windows basics, Microsoft Word, Microsfot Excel, Microsoft Access, Microsoft Publisher, Microsoft Project, Microsoft Powerpoint, Internet/ Websites, bespoke courses and train the trainer. Covering the North West and Wales; courses can be held either at your premises or you can join the open course sessions at the Ty Llywelyn Community Centre.