Introduction to Databases with Access
CIS 153B
2-day workshop, $215 +tax
9:00 am-4:00 pm
Students
will learn how to design and create databases, tables, queries, forms,
and reports. Training will be delivered in a student-directed, case-based,
classroom-delivery learning model. Students should understand the basics
of Microsoft Windows. Students will acquire the Access basics with the
LearnPro and QuickSkill CBT tutorials.
Skills developed in this course:
| Add graphics to reports | Group records in reports |
| Add records to a table | Import data into an Access table |
| Add totals to a report | Join tables in a query |
| Add, insert and move fields in table design | Merge Access with a Word document |
| Change table column widths | Modify table data |
| Create a command button on a form | Move controls and labels |
| Create a database by using a wizard | Open Access objects |
| Create a simple macro | Sort table records |
| Create forms and enter data | Use AutoReport |
| Create queries with a calculated field | Use Find in a table |
| Create queries with multiple criteria | Use the Report Wizard |
| Customize an order-entry form | Use the Table Wizard |
| Delete records from a table | Use Undo |
| Export data to Excel | View objects in Design |
| Format reports |
 |
|
 |
|
 |
|