Creating a database for online use

Resolved · Medium Priority · Version 2003

Tue 25 Oct 2011, 21:57 Delegate Colin said...

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?

Tue 1 Nov 2011, 12:48 Trainer Doug said...

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

Wed 2 Nov 2011, 22:11 Delegate Colin said...

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.8 % recommend us
	More live stats...

Training information:

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips