Microsoft Access 2013
Access is Microsoft’s powerful database tool. Using Access you will learn to store, retrieve, and report on information. You will be able to sort, make queries, create reports, and understand all the functions of a relational database.
Course Length
75 hours
Text Book
- Microsoft Office Specialist Access 2013, , C., 2013, ISBN: 0-13-363945-2
Courseware Download: http://ccilearning.com
On CCI Learning Web Page Enter Courseware #: 3245
Method of Evaluation
- Practical Exercises 20%
- Participation 20%
- Final Exam 60% (minimum 65%=pass)
Competencies
Knowledge
- Understand the use of databases for business research and predicting trends
- Understand the use of different functions in Access
- Understand the use of different fundraising
- Understand the use of different job search and employer contacts
- Understand how tables, forms, reports, and queries differ and how they can be
used to make business decisions
Skills
- Able to use an ERD and Data dictionary, to design tables using the right data types
and assign the primary key - Relate tables and choose the proper specifications for the relationships
- Create and modify Queries
- Create and modify forms and reports
- Create reports which allow for business decisions to be made