Friday, February 10, 2012
|
9 a.m. -
11 a.m. | Microsoft Access 2007 - I (Tables) |
| |
This workshop provides an Introduction to Databases using Microsoft Office Access 2007. The following topics will be covered:
A. General database concepts such as records (rows), fields (columns), primary keys, attributes of the fields, relational database.
B. Overview of the Microsoft Access 2007 Interface
C. How to create Tables in Microsoft Access 2007 using Design View.
Location: LWH-4066
Prerequisites:
1- Experience using of Microsoft Excel 2003 or 2007. Ideally it is recommended that you have a minimum of approximately six months of experience with Excel.
Registration:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line
“UTS Training: Microsoft Access I (Friday, Feb-10-2012)”
Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:
Important Notes:
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants. Please check the calendar periodically to check the workshop's availability.
Posted by: Faisal Kalota
|
Friday, February 17, 2012
|
9 a.m. -
11 a.m. | Microsoft Access 2007 - II (Queries) |
| |
This workshop covers queries in Microsoft Access 2007. Some of the topics that will be covered in this workshop are:
* Query
- What is a query
- How to create a simple query
* Query Operators
- AND, OR, NOT
- Wild Card Characters
- Relational Operators
* Query Types
* Understanding different type of Queries (Select, Append, Delete, Update, etc)
PREREQUISITES:
* Microsoft Access 2007 - I (Introduction).
* General understanding of relational operators such as >, <, >=, <=, !=, etc.
* Be able to demonstrate the basic database principles by designing and creating a new database with at least 4 tables.
* Be able to create tables in a database and set various attributes of the fields in the table.
* Be able to establish relationship among the different tables.
* Be able to create tables by importing data from Excel and then updating the table properties.
* Be able to create a table and then import data from Excel.
Location: LWH-4066
Registration:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line
“UTS Training: Microsoft Access II (Friday, Feb-17-2012)”
Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:
Important Notes:
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants. Please check the calendar periodically to check the workshop's availability.
Posted by: Faisal Kalota
|
Friday, February 24, 2012
|
9 a.m. -
11 a.m. | Microsoft Access 2007 - III (Forms & Reports) |
| |
The workshop provides an overview of Forms and Reports in Access 2007. The following topics will be covered:
1 Reports
- Purpose of a report.
- Creating a simple report using the wizard.
2 Forms
- Purpose of a form.
- Creating a simple form using the wizard.
PREREQUISITES:
• Microsoft Access 2007 - I (Introduction)
• Be able to demonstrate the basic database principles by designing and creating a new database with at least 4 tables.
• Be able to create tables in a database and set various attributes of the fields in the table.
• Be able to establish relationship among the different tables.
• Be able to create tables by importing data from Excel and then updating the table properties.
• Be able to create a table and then import data from Excel.
• Be able to create queries in Access using the Wizard.
Location: LWH-4066
Registration:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line
“UTS Training: Microsoft Access III (Friday, Nov-24-2012)”
Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:
Important Notes:
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants. Please check the calendar periodically to check the workshop's availability.
Posted by: Faisal Kalota
|
