access training - Access and Excel - confidentiality

The UK's most regular instructor-led training courses.
Training information: access training · Courses in microsoft access · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Access and Excel - confidentiality

Ariane has attended:
Access Introduction course
Access Intermediate course

by - delegate Ariane [1 post] (2007 Jun 4 Mon, 12:49) Reply

Are Access and Excel different in terms of data protection/confidentiality?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Access and Excel - confidentiality

by - trainer Tracy platinum contributer [586 posts] (2007 Jun 4 Mon, 16:02) Reply

Hi Ariane,

Thank you for your question.

Excel and Access are predominately different in there uses, excel is generally used for numerical information whereas Access is generally used to store information in terms of text. In terms of data protection each have similar ways to password protect documents.

Tracy

· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Microsoft Access as a Business's Database Management System
· Material covered on a Microsoft Access Course
· Why Do I Need To Use Access?

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips