Microsoft Access Level 1
 
 
Course Number: Duration: 16 hours
 
Objectives
This course is designed to give you an understanding of some of the major features and functions within Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given, then the course will help students to build on their basic understanding of Access (Latest Version), in order to produce more comprehensive and robust database applications. Students will get experience in the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and reports.
Target Audience New, recent or intending users of Access who have little or no existing database knowledge.
Topics Getting Started with Access, Getting Assistance with Access, Adding and Editing Records, Designing a Table, Working with Data, Using a Form, Using a Select Query, Using a Report, Relational Database Management Systems, Table relationships, Modifying a table, Customizing queries, Customizing forms, Customizing reports, Database tools.
Prerequisites A knowledge of personal computer fundamentals, Experience in working within the Microsoft Windows environment.