<%@LANGUAGE="VBSCRIPT"%> <% set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_CONNprrt_STRING Recordset1.Source = "SELECT * FROM tblContent WHERE pageName='courses'" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 3 Recordset1.Open() Recordset1_numRows = 0 %> PRRT - Building New Futures.




 
   

IT Training - Introduction to Access
1 Day Course

Course Objectives


This course is designed as an introduction to understanding the concepts and uses of databases. Using the popular database MS Access 2000, the course explains when and why to use a database. The course considers, what is a database, then the design of a database, how to build a database, populate it with data, then sort, filter and query the data before building reports.

Course Content

- What is a database?
- Designing a database
- Storing your data: Tables and Forms
- Finding your data: Filtering and Queries
- Using your data: Reports

Notes:
Knowledge of Access or databases is not required. Participants should have a good working knowledge of computers, word processing, understanding of files and folders, the desktop, windows, and using the mouse.

Learning Outcomes

After attending this course participants will be able to:-
- Understand the benefits of using a database
- Design and build a database table and populate it using forms
- Filter and query the data to find specific information
- Use the data to build reports

Having completed this course, participants will be able to proceed to the Microsoft User Specialist 2 Day Access 2000 (Core) training course and the MOS accredited examination

- >> Back to main IT training page

 
<% Recordset1.Close() %>