Create A Tutorial That Tracks Progress For A Specialized Access Database

Apr 13, 2007

We are working on an access2000 database that will incorporate various "tutorial" or "training" elements in the db on how to use the db (mostly links to outside PDF files, etc.); the training elements guide users on how to do various data entry tasks, report generation, etc.

Is there a way, in Access, to track which "step" of the procedure a user is on? For instance, if they make it through Exercises 1-5, is there a way we can add some sort of indicator that lets them know, when they come back to it a week later, that they left off on Exercise 6? I have seen this done in various software tutorial packages, but I'm not sure how it is accomplished?

Any suggestions?

View Replies


ADVERTISEMENT

Customer Database Tutorial

Jul 5, 2006

Hi

I am new to Access and would like to learn by taking on small projects.

Does any body know any good tutorials for beginners that could show how to start a database for a list of customers or something similar?

I have looked at the ones that can be created with the Wizards but obviously this doesn't help you understand the mechanics.

I would like to learn the 'nuts and bolts' so that I can expand the database and create new ones the more advanced I become.

Any good suggestions would be appreciated.

Thanks

View 2 Replies View Related

A Thorough Tutorial That Helps One Make A Mean Database

Oct 24, 2006

Hello all!

I have been searching online for the past couple of days for a thorough tutorial that aids the user to make his/her own detailed database based on example data (that does not necessarily have to be adhered to) supplied as the tutorial progresses.

As a student participating in an advanced computing class, I feel that this would benefit me as I can do as the steps ask and see how certain things are done. I am not a complete Access mug... I have a basic knowledge of the fundamentals, but stumbling accross an in-depth tutorial that details all of the standard features (tables, queries, forms etc) along with possibly some example modules would be excellent and beneficial.

All I have found so far is various snippets - "SQL basics" and "Macros: what they do and how to implement them" for example - these miss the bigger picture I am looking for. Surely a step-by-step tutorial on "Designing and working a fully-featured database from the gound up" is not that rare!

Thanks in advance for any help. :)

View 5 Replies View Related

Looking For Good Tutorial On Feeding A Site With A Database.

Oct 25, 2004

I am very new to ASP and Access. I need to learn how to create a database full of images and text to feed dozens of webpages for a new site I am doing. I have googled many times and can't really find what I am looking for. I've come across ADO several times. Is this similar to what I am looking for? Thanks.

View 5 Replies View Related

VBA For Access Tutorial

Jun 4, 2005

Does anyone knows a good VBA for Access tutorial or documentation i can download so i learn how to write the Event Procedures in MS Access?

Thank you for your help.

View 1 Replies View Related

Access Tutorial With Exercises

Sep 21, 2005

Hi All

I have just spent 30-40 minutes reading through this forum. So many solutions. Excellent. http://www.access-programmers.co.uk/forums/images/icons/icon7.gif
Smile I am just starting Access and I want to find a course where there are exercises which will take me to a reasonably proficient level.

If anyone has done come across a book CD or online that they would recommend then I’d be most appreciative.

All the Best
Jacky Kenna

View 1 Replies View Related

Access Tutorial Videos

Nov 11, 2007

Sorry, couldn't let the world go without these instructional videos. It's not much, but it's a good place for beginners to start:

Access Instructional Videos

This might be a good sticky

View 11 Replies View Related

How To Create A "status" Or Progress [popup] Display

Jan 8, 2006

Ok the question may sound cryptic, but I have a large database with many forms that all contains VBA code that can be iniated via a button and will perform some time consuming work.

I would like to be able to view some kind of status or progress of the work performed. Perhaps even dynamically like in from 0-100% work done.

Example send some status text to either a popup form or even the bottom "statusbar" text area. The problem with the latter is that I know how to change it via VBA, but as far as I know it requires me to access and change it using form and object. But I need this from so many forms and objects (buttons) that I would need to do a lot of code rework to actually know where I am calling my VBA code from.

Is it possible to change the status text "universally", that is without regards to a form and object?

Or how else can I go about to display some status/progress text which will work from any form and object without passing form and object name.

View 4 Replies View Related

Access 2000 Progress Meter

Oct 29, 2006

I have a form that takes sever seconds to load, due in part to the number of records I suppose, however I would like to create a progress meter (form?) that will run while the form is loading. I have tried several different suggestions but none work. Can anyone help me?


Thanks
Mickey

View 4 Replies View Related

Specialized Autonumber

Jun 2, 2005

I am creating a database for my company to register projects. And each project needs to have a unique Project ID number, which (due to the conformity of another software tool) must be 4 characters long. The first character is a specific letter based on the group the project is created by, followed by a 3 digit number. So, for example, one of the group code letters is C, so the first "C Project" would have the ID 'C001'.

I want my database to assign these automatically after selecting the group.

Any ideas?

View 2 Replies View Related

Microsoft Access Was Unable To Create An MDE Database

Mar 31, 2006

When trying to create an MDE using Access 2002 I get the message

"Microsoft Access was unable to create an MDE database"

The database is split and in Access 2002 format.

Could this be anything to do with References? I say this because I recently downloaded a dll for Redemption to make use of the SafeOutlook Library

Thanks

Oliver

View 2 Replies View Related

Can ASP Or ACCESS Create A Database Search Report?

Dec 30, 2005

Hey there, can anyone advise if the following is possible and if so how it might be done?

I have created a site using DWMX04, ASP & ACCESS.

I would like to be able to have some sort of report on what is being searched on the database.

Can this be done in ACCESS or by using ASP?

Any ideas or suggestions would be great.

Mally.

View 3 Replies View Related

Reports :: Emailing Specialized Report To Multiple Recipients

Jul 20, 2015

I have a large report that generates information specific to a large list of contacts. I would like to email each contact a .pdf of their part of the report. If possible, I'd like access to run a loop and do this in one button click. I'm not even sure to begin with this.

View 2 Replies View Related

CREATE TABLE In Access Database Syntax Error..

Aug 13, 2006

Hi folks.. I'm trying to dynamicly create a table in an existing ACCESS database..

Here's wat i'm using:

PHP Code:<%
strDB = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../../../imgdbase/vrienden.mdb") & ";Uid=Admin;Pwd=mljiscool;"
sql = "CREATE TABLE " & request("login") & " (id INT(10) PRIMARY KEY AUTO_INCREMENT, email VARCHAR(155), gevalideerd VARCHAR(10) DEFAULT 'nee', inlogCount INT(10) DEFAULT 0, lastLogin DATETIME)"
Set DBConn = Server.CreateObject("ADODB.Connection") 
DBConn.Open strDB
DBConn.Execute sql
DBConn.close
Set DBConn=Nothing    
%> 


Code:I'm getting this error:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement./mljnew/welcomeportal/registration/registration/test.asp, line 7

What am I doing wrong ??? The code here is probably the MySql correct code (Access uses different data types / field names ???) Hope somebody can help me out, because I can't find the correct data types anywhere ! (like use TEXT instead of VARCHAR, that's all I know...)

Here's the actual sql i'm using (displayed by response.write sql):
CREATE TABLE roel (id INT(10) PRIMARY KEY AUTO_INCREMENT, email VARCHAR(155), gevalideerd VARCHAR(10) DEFAULT 'nee', inlogCount INT(10) DEFAULT 0, lastLogin DATETIME)

Thnx !!!!
Roel.

View 3 Replies View Related

General :: Create A Check List In Access Database

Jun 12, 2015

I'm trying to create a checklist in my access database that can be assigned to different companies. Is there a way to maintain a blank checklist so that we don't have to recreate it every time we start working with a new company?

View 3 Replies View Related

General :: Create A Front End Application For Access Database

Apr 10, 2013

I was looking to see if there was an easy way to create a user front end desktop application for a small access database.I have three users on different computers i would like them to input or amend data within one table of the access database.

View 2 Replies View Related

Create A Shortcut To Open An Access Database Object For 2007

Dec 17, 2007

Running 2007. In 2003, to make a shortcut for an object, all I had to do is right click and place the short cut where i wanted.

I can't seem to find anyway to do it in 2007

Anybody have any clues?

View 3 Replies View Related

Modules & VBA :: Command That Will Create Backup Of Access Database Once Every Week

Feb 24, 2014

Im trying to create a command that will create a backup of my access database once every week. here is the code I've got so far. it works, but not once a week but every time I start the access:

MsgBox ("Hello! Starting Backup procedure")

Dim DateOfBackup As Date
Dim strSourcePath As String
Dim strSourceFile As String
Dim strBackupFile As String
Dim SQL As String

[code]...

View 2 Replies View Related

Modules & VBA :: Error - Microsoft Access Was Unable To Create MDE Database

Sep 19, 2013

I have tried to create an MDE database and receive the message "Microsoft Access was unable to create an MDE database" I deleted all unnecessary tables, queries, forms and reports and still receive this message.

how to fix this problem in MsAccess 2003?

View 6 Replies View Related

General :: Create Database In Access That Links To Contacts In Outlook Pst File

Nov 21, 2013

I have limited programming skills but a basic understanding of databases.I want to create a database in Access that links to contacts in an Outlook pst file, and in the Access database I want to create a series of date dependant tasks or processes that I can apply to the relevant contact.The object being to to save that collection of tasks to apply to different contacts within Access.

View 2 Replies View Related

SQL Tutorial

Oct 20, 2006

Hi,

I am trying to learn how to use SQL. Can ayone please tell me where to download/view a comprehensive and easy to use tutorial?

Thank you very much.

Gareth

View 1 Replies View Related

Need A Good Tutorial

Jan 26, 2006

I have been selected to do a project by my department head. It involves programming an Access database to do various things. It has to have forms and all that good stuff. I'm trying to get the higher powers to get a web server for me to do this as a web application, but I may need to fall back on the Access idea. So I need a good tutorial on programming in an Access environment. I know it uses VB and I am pretty decent when it comes to programming with that language. What I need help with is how to do certain things like close a form using an onclick event or to print a report. There's a lot I need to be able to relearn so if anyone can point me in the right direction I would appreciate it much. I'm doing this for a Commander in the US Navy...(several ranks above me )...so I need to be able to pull this off!!

Thanks much,

JMH

View 1 Replies View Related

Looking For A Chart Creating Tutorial...

Apr 17, 2007

Anyone know a good site w/ help creating charts in Access 2k? I have a few queries id like to display as charts but just playing w/ the chart feature is getting more confusing by the minute. Any tutorial would be great. TIA!

View 1 Replies View Related

Expression Builder Tutorial Or FAQ?

Oct 13, 2006

Now I have been working for a few months with ACCESS but one thing that keeps giving me trouble and that is the "Expression Builder". I look at the Microsoft Help and it is not good in explaining this part of ACCESS. I have Access books and they are not good with explaining this aspect of Acess. Is there anyone with a good source to point me in the direction to learning the Expression Builder better then I know now?

View 1 Replies View Related

Tables :: Create A New Database Y And Link To Database X

Aug 28, 2013

I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!

View 1 Replies View Related

Recommend A Tutorial To Print Records Please?

Mar 8, 2007

Hi,
I'm using Access 2000.
I currently use a form to enter my customer details. As soon as the info is entered I need to send out a "thank you for joining" letter, but I can't figure out how to print out a single field, it prints them all.

Ideally I'd like to have a button on the form so I can print it out on a template.

Can anyone recommend a good tutorial on how to do this, or offer any advice please?

Any help would be greatly appreciated!

Many thanks

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved