I need clear easy to follow instructions on how to teach several MS Access topics to students.
By trade I am a .NET instructor, not an Access instructor, but I have been asked to teach this class starting Monday Jan 13th.
In order to give me time to prepare, I need to your work completed by Friday Evening on the 10th of January.
Yes, I know this is only 3 days away! So only bid if you are able to complete it.
The format can be in almost any Microsoft product. Word, Wordpad, notepad, Powerpoint etc.
Images would be a plus, but are not required.
## Deliverables
Per the client, The topics to be taught are as follows:
**Creating and Using Databases**
• Create Access databases
• Open database objects in multiple views
• Move among records
**Creating and Modifying Tables**
• Link to MS SQL Server tables via ODBC connection
**Creating and Modifying Queries**
• Create and modify Select queries
• Add calculated fields to Select queries
• Create complex expressions using, group by, sum, count, etc
•• The client requests a fair amount of time on queries, the different types and result sets available.
**Viewing and Organizing Information**
• Create Queries
• Sort Records
• Filter Records
**Defining Relationships**
• Discuss one-to-many relationships
• Discuss the meaning of referential integrity
**Producing Reports**
• Create and format reports
• Add calculated controls to reports
• Preview and print reports
• • The client would like to see a fair amount on the subject of reporting, i.e.
• The different types and methods available
• Group Levels
• Sums
**Exporting**
Exporting information from Access to excel, sql etc.
## Platform
Win2k or XP
## Deadline information
Must be completed by 6pm PST on Jan 10th