Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

database files used practice

Forum home » Delegate support and help forum » Microsoft Access Training and help » Database files used in practice activities

Database files used in practice activities

ResolvedVersion 2010

Errol has attended:
No courses

Database files used in practice activities

I have downloaded the Access 2010 training manuals and would very much appreciate obtaining the training files used in the practice activities. How do I access these files for download? Thanks and be well.

RE: Database files used in practice activities

Hi Errol

Thanks for getting in touch and I hope you are enjoying the manuals.

Whilst the manuals are a courtesy to all our visitors, files are provided to delegates as part of training. However, you should be able to use the processes described on any database, or by using the Northwind database which comes free with Access.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Database files used in practice activities

Gary:

Thanks for your prompt and courteous reply. I know I can learn from the answers given for the practice activities but really wanted a hands-on feel during the training.

However, as recommended by you, I will make substitutions during my training using tAccess' Northwind database as best as I can.

Thanks again and be well.

Errol

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.