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

creating database online use

Forum home » Delegate support and help forum » Microsoft Access Training and help » Creating a database for online use

Creating a database for online use

ResolvedVersion 2003

Colin has attended:
Access Introduction course

Creating a database for online use

I am just starting out in the world of Access.

My final aim however is to create a database that can be polpulated from different offices around the world.

Is there any advice to start me off on the right foot?

RE: Creating a database for online use

Hi Colin

As you are using Access 2003 you might want to investigate using Access Pages. It allows users to populate a database remotely.

However Access Pages has been discontinued in more recent versions of Access replaced by the use of Sharepoint.

I will get back to you if I have further suggestions but in the mean time you could ask in your IT department whether either Pages or Sharepoint has been used for remote updating.

Regards
Doug Dunn
Best STL

RE: Creating a database for online use

Hi Doug

Thanks for the answer.

Not sure I mentioned I was using 2003. I have had mine upgraded to 2007 as that is what I did the training course with.

I will look into sharepoint however, so I think you answered my question none the less.

Thanks

 

Training courses

98.7 % recommend us

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Please browse our web site to find out more about
access+training and other training courses.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.1 secs.