In this course, students will learn how to use Access to manage data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.
Upon successful completion of this course, students will be able to:
- identify the basic components of an Access database.
- build the structure of a database.
- manage data in tables.
- query a database.
- design forms.
- generate reports.
- streamline data entry and maintain data integrity.
- join tables to retrieve data from unrelated tables.
- create flexible queries to retrieve data and modify tables.
- improve the functionality of Access forms.
- customize reports to organize the displayed information and produce specific print layouts.
- share data between Access and other applications.
- Lesson 1: Getting Started with Access 2010
- Lesson 2: Building The Structure of a Database
- Lesson 3: Managing Data in a Table
- Lesson 4: Querying a Database
- Lesson 5: Designing Forms
- Lesson 6: Generating Reports
- Lesson 7: Controlling Data Entry
- Lesson 8: Joining Tables
- Lesson 9: Creating Flexible Queries
- Lesson 10: Improving Forms
- Lesson 11: Customizing Reports
- Lesson 12: Sharing Data Across Applications
Founded and headquartered in Anaheim, California, New Horizons Learning Centers was named the world's largest independent training company by IDC.
The Company is both an operator and franchisor of training centers that offer a broad range of Technical Training, Desktop Application, Business Skills and English Language courses for all levels of users in multiple delivery methods and formats.
New Horizons provides approximately three million student days of instruction annually with location around the globe.
New Horizons sets the pace of innovative training programs that meet the changing needs of the industry. With 2400 qualified instructors in over 2100 classrooms at 300 centers in 60 counters around the world.
New Horizons offers more courses, at more times, in more delivery methods than any other training company.See all New Horizons Egypt courses