microsoft access course - Adp vs Mdp

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

Resolved · Low Priority · Version Standard

Adp vs Mdp

Clare has attended:
Access Introduction course

by - delegate Clare [6 posts] (2007 Feb 13 Tue, 11:24) Reply

Hi

Can you tell me the difference between these two file types in access? All the work I did in the course ended in Mdp but when I have come to look at all the databases we have at work, they all seem to be adp.

Thanks

Clare

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Southwark	3	book now	£210	£215
2003	2008 Sep 9 Tue	Bloomsbury	6	book now	£193	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
Full Schedule: See all 73 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Adp vs Mdb

by - trainer Carlos gold contributer [394 posts] (2007 Feb 14 Wed, 15:17) Reply

Mdb (Not Mdp) is the normal Microsoft Access Database.

Adp is a Microsoft Access Project file.

An Access project contains only HTML-based (Web) database objects: forms, reports, the name and location of data access pages, macros, and modules.

An Access project does not contain any data eg tables.

To create your application and access the data, you must connect the Access project to a SQL Server database

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· How Reorganising Your Data Can Take Your Business to the Next Level
· MS Access: Access your Personal Information with Ease

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