microsoft-access-course - Database

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

Resolved · Low Priority · Version Standard

Database

Carmen has attended:
Access Introduction course

by - delegate Carmen [1 post] (2007 Feb 5 Mon, 09:57) Reply

What is a access database?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 20 Mon + 21 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	6	book now	£450	£485
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 14 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Database

by - trainer Amanda platinum contributer [961 posts] (2007 Feb 5 Mon, 13:47) Reply

Hi Carmen

Thank you for posting to our forum.

A database is a collection of information organized in such a way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system.

Traditional databases are organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which consists of three fields: name, address, and telephone number.

To access information from a database, you need a database management system (DBMS). This is a collection of programs that enables you to enter, organize, and select data in a database.

Enjoy your training today
Amanda

· Material covered on a Microsoft Access Course
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Tips for designing databases in Microsoft Access
· Microsoft Access: Unleash the True Potential Today

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips