microsoft access courses - creating custom applications acc
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Creating custom applications with Access

microsoft access courses - Creating custom applications with Access

resolvedResolved · Low Priority · Version Standard

replyReply Fri 13 Jul 2007, 17:10Delegate Dave said...

Dave has attended:
No courses

Creating custom applications with Access

Hi,

I would like to know if it is possible to create custom applications using MS access as the back-end database. I have heard that this can be done using Microsoft VBA or Visual basic. Any advise on this would be great, as I really want to create a custom application using forms for my client.

I also understand that by creating a custom application, I will no longer need to use the built in forms access will create for you, is this true?

Thanks
Dave

For upcoming training course dates see: Pricing & availability

replyReply Mon 16 Jul 2007, 09:27Trainer David said...

RE: Creating custom applications with Access

Hi Dave,

Yes, it is possible to create custom applications with Microsoft Access. You can do this using vba, but using this method you will still need to use Microsoft Access to some extent. However you will be able to create your own custom forms and reports.

The alternative way to do this, is to use Visual Basic (part of the Visual Studio software package) This will enable you to create you own custom application using Microsoft Access as the back end database. Using this method you will not need to use Microsoft Access at all. Visual Basic will create an .exe file that contains all of the Microsoft Access DLL's that you will need to run the application with complete separation from Microsoft Access.

Hope this helps
David

 

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard