Microsoft Access Tricks and Tips Easy ways to get more from Access 2 : Tables
When and why should I use Indexes? You should use an index on any field that you will want to sort, search, or join to another table. They will speed up these tasks. However, each index makes the database file larger and can slow it down, so only use them when you need to. How can I change the starting value of an AutoNumber type field? First of all you need to create your table with an AutoNumber type field. Do not enter any records. Then create another table with only a single Long Integer Number type field. Ensure this field has the same name as the AutoNumber field in the first table. Enter one record in the second table that is a number one less than the required start of the AutoNumber for the first table. Now create an append query to append the record in the second table to the first table and run the query. You can now delete the second table and begin entering your data into the first table. How can I hide Rows and Columns in Tables? You can reduce the width of a column in table by using the mouse to drag the column edge to the desired width. Position your mouse pointer at the right of the field selector for that column and drag it to the left. If you drag it beyond the left hand side of the column you will hide the column. You can decrease the height of a row in a table in a similar way. Simply position the mouse between the two record selectors at the left side of the table and drag to the required height. When you change the height of the row it will make all rows for that table the same. For this reason you cannot hide the row by dragging the bottom above the top of the row as it would hide all rows for the table. How to remove tables from the Relationships window? you don't have to delete your table. Simply select the table in the relationships window, then Right Click and REMOVE TABLE. This does not change any relationships the table has and you can always add the table again if you need to by using ADD TABLE from the relationships menu.
Main Menus : All Tricks & Tips Access Tricks & Tips More Access : Forms/reports Queries General

Activia Training Abbey House 18-24 Stoke Road Slough SL2 5AG
Telephone: 0845 230 6150 (local rate)

Training course finder | Train To Gain Government Funded training
Training in London | Training in Birmingham | Training in Berkshire | Training in Buckinghamshire | Training in Hampshire
MS Access training courses UK | Why Activia
Copywriting for web sitesBook your accredited Microsoft Access Courses with Activia

[ Close ]

Why Activia for Microsoft Access Courses ?

Microsoft Access Courses in London, Berkshire, Buckinghamshire, Hampshire and Birmingham

Activia should be your first choice for courses in Access in the UK. We provide you with a full range of classes for job-related Business Skills, HR & Supervision, Sales and Management Development as well as IT applications from Microsoft, MS Office, Sage, Adobe, Macromedia, Crystal Reports and Lotus. If you are looking for Microsoft Access classes, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Microsoft Access Courses at fiercely competitive prices.

MS Access Training Course

If your requirement is MS Access database software database software training course, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for learning Microsoft Access, Activia will provide more tailored, flexible and focused solutions, and this enables you to get the most from your budget using the minimum of resources.

Courses in London, the Midlands, Berkshire (Berks), Buckinghamshire (Bucks), Hampshire (Hants), Surrey, Middlesex and UK wide

We provide MS Access Training Course courses all over the UK, with modern, fully equipped training centres in the following locations:

Microsoft Access Courses in the City of London

Serving the City and West End of London, as well as areas like Leytonstone, Walthamstow, Barking, Chingford and Ilford.

Microsoft Access Courses in West London

Serving West London, as well as areas like Brentford, Kew, Watford and Richmond.

MS Access Training Course at London Heathrow

Serving Middlesex and Surrey, covering Uxbridge, Staines, Egham, Sunbury, Hounslow and Twickenham.

Microsoft Access Courses in Birmingham City Centre

Serving Warwickshire and the Midlands, covering Birmingham, Walsall and Dudley as well as Wolverhampton, Telford and Tamworth.

MS Access Training Course in Birmingham South

Serving Warwickshire and the Midlands, covering Solihull, Halesowen and Redditch as well as Coventry, Kidderminster and Worcester.

Microsoft Access Courses in Manchester

Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.

Microsoft Access Courses in Reading

Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley, Bracknell and Basingstoke.

MS Access Training Course in Slough

Serving Berkshire and the Thames Valley, covering Slough, Windsor and Maidenhead as well as Gerrards Cross, Uxbridge and Watford.

Microsoft Access Courses in Aylesbury

Serving Buckinghamshire, covering Aylesbury, High Wycombe and Hemel Hempstead, as well as Oxford, Bicester and Buckingham.

MS Access Training Course in Milton Keynes

Also serving Buckinghamshire, covering Milton Keynes, Luton and Bedford, as well as Stevenage, St Albans and Welwyn Garden City.

Microsoft Access Courses in Basingstoke

Serving Hampshire, covering Basingstoke, as well as Camberley, Farnborough, Aldershot to the east, and Newbury, Andover and Winchester to the west.

Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.

In House Microsoft Access Courses across the UK

For in house delivery of MS Access Training Course, we have an established national UK network of trainers, as well as centres in London, Birmingham, Slough, Reading, Basingstoke, London Heathrow, Aylesbury and Milton Keynes, so you can be sure that your courses in Access will be delivered in a quality assured and cost effective manner. For in-house MS Access database software database software training course, you need look no further than Activia.

[ Close ]

Standard:
Large:
Larger:
Largest:
Please Note: Changing the text size may adversely affect the layout of some pages.

Activia's Quick Course Finder
Welcome to Activia's easy-to-use Quick Course Finder Just click on any heading (in black) or section (in blue) to go straight to where you need to be Or click here to close the Quick Course Finder and return to the page you were on
Staff Development Training Sales & Business Development training • Sales Training • Presentation Skills • Telephone Sales Training • Negotiation Skills • Sales Management Employee Skills training • Assertiveness Training • Business Writing Skills • Communication Skills • Customer Service • Influencing Relationships • Minute Taking • Presentation Skills • Time Management • Receptionist Skills • Telephone Techniques HR and Recruitment training • Interviewing Skills • Stress Management At Work • Stress Management For Managers • HR for Non HR Managers • Developing a Training Programme • Train the Trainer Essentials • Training Needs Analysis Compliance Health and Safety training • First Aid Certification Cisco Certification training • Cisco Network Devices Part 1 (ICND1) • Cisco Network Devices Part 2 (ICND2) • CCNA Boot Camp • Implementing Cisco IP Routing (ROUTE) • Implementing Cisco Switched Networks (SWITCH) • Troubleshooting Cisco IP Networks (TSHOOT) Microsoft Certification training • 2273B: Managing Windows Server 2003 • 6231A: Maintaining SQL Server 2008 • 6232A: Implementing SQL Server 2008 • 6294A: Windows 7 Desktop Deployments • 6416B: Updating to Windows Server 2008 • 6417B: Updating to Windows Server 2008 • 6418B: Deploying Windows Server 2008 • 6419A: Windows Server 2008 Servers (1) • 6420A: Win Server 2008 Network/Apps • 6421A: Win Server 2008 Infrastructure • 6422A: Windows Server 2008: Hyper-V • 6423A: Windows Server 2008: Clustering • 6424A: Win Server 2008: Active Directory 1 • 6425A: Win Server 2008: Active Directory 2 • 6426A: Win Server 2008: Identity/Access • 6427A: Windows Server 2008: IIS • 6428A: Win Server 2008 Terminal Services • 6430B: Windows Server 2008: Planning • 10135A: MS Exchange Server 2010 (1) • 10233A: MS Exchange Server 2010 (2) APM PRINCE2 training • PRINCE2 Foundation • PRINCE2 Foundation and Practitioner • PRINCE2 Practitioner Upgrade ITIL training • ITIL V3 Foundation Bridge • ITIL V3 Foundation	Professional & Management Training Management Skills training • Project Management • Change Management • Management Skills (1 day) • Management Skills (2 days) • Decision Making Managing Staff Performance training • Staff Performance • Supervisor Training • Coaching Skills • Motivating Staff • Building Relationships • Team Building & Working • Managing Discipline • Conflict Management • Facilitation Skills • Delegation Skills Accounts & Finance training • Sage Accounts • Excel for Accounts: Intro • Excel for Accounts: Adv • Finance for Managers • Business Accounting • Budgeting and Forecasting • Finance Management: Intro • Finance Management: Adv Mentoring training • Management Mentoring • Sales Staff Mentoring	Desktop Applications Training Microsoft Desktop training • Access Training • Excel Training • FrontPage Training • Office Training • Outlook Training • PowerPoint Training • Project Training • Publisher Training • SharePoint Training • Visio Training • Windows Training • Word Training Adobe training • Adobe Acrobat Training • Adobe Photoshop Training • Adobe Illustrator Training • Adobe InDesign Training • Adobe DreamWeaver Training • Adobe Flash Training • Adobe Fireworks Training Sage training • Sage Line 50 Training • Sage Payroll Training Lotus training • Lotus Notes Training • Lotus Domino Training Crystal Reports training • Reports 9.0 Introduction • Reports 9.0 Advanced • Reports 10.0 Introduction • Reports 10.0 Advanced • Reports XI Introduction • Reports XI Advanced • Crystal Reports 12 (2008) Introduction • Crystal Reports 12 (2008) Advanced Web Design training • HTML Introduction • HTML Advanced • JavaScript Introduction • JavaScript : Advanced • Effective Web Design Computer Skills training • Computer Basics (Windows XP) - Level 1 • Computer Basics (Windows XP) - Level 2 • Computer Basics (Win Vista) Level 1 • Computer Basics (Win Vista) Level 2
[ Close Quick Course Finder ]

Microsoft Access Tricks and Tips

Easy ways to get more from Access

2 : Tables

When and why should I use Indexes?

How can I change the starting value of an AutoNumber type field?

How can I hide Rows and Columns in Tables?

How to remove tables from the Relationships window?