Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access courses in london - Full working data base

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access courses in london - Full working data base

Resolved · Low Priority · Version Standard

Reply Thu 1 Mar 2007, 12:28Delegate Justin said...

Justin has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Full working data base

I dont use Access as yet but what I would like to know is if someone could show me something with the end product using Access? I need to see an end result so I can see what somebody would be working to.
I am finding it hard to grasp the full concept if I cant see an end result.

For upcoming training course dates see: Pricing & availability

Reply Thu 1 Mar 2007, 16:39Trainer David said...

Microsoft Access Database

Hi Justin

Databases are very complex and can have lots of development work carried out on them. In essence a database will always be evolving. The database that you used on your course was simple yet complete. So you can count this as a complete database.

Alternatively you will find a couple of examples already built into access. Which you may find useful.

Hope this helps

David

Access articles

· Material covered on a Microsoft Access Course
· One To Many Relationships In Access
· How to Find a Third-Party Venue for Microsoft Access Training
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· What Is The Database Documenter And How Is It Used?

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips