Details
Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Access can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.
This course focuses on the design and construction of an Access database - viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Outline
- Launch Access and Open a Database
- Use Tables to Store Data
- Use Queries to Combine, Find, Filter, and Sort Data
- Use Forms to View, Add, and Update Data
- Use Reports to Present Data
- Get Help and Configure Options in Microsoft Access
Module 2: Creating Tables
- Plan an Access Database
- Start a New Access Database
- Create a New Table
- Establish Table Relationships
Module 3: Creating Queries
- Create Basic Queries
- Add Calculated Columns in a Query
- Sort and Filter Data in a Query
Module 4: Creating Forms
- Start a New Form
- Enhance a Form
Module 5: Creating Reports
- Start a New Report
- Enhance Report Layout
Our goal is to offer quality and up-to-date training courses, while following the latest trends in technology and applications. These are courses that target the real and concrete needs of our customers, ensuring that the knowledge acquired is put into practice. Additionally, many prepare our participants for certification exams with the brands we are accredited with - Microsoft, EC-Council, CompTIA, and PeopleCert.
Eccentrix has the most comprehensive offer in terms of Microsoft accredited trainings. In addition, a complete set of benefits comes with each enrollment to our trainings. Since the very beginning of our operations, Eccentrix has been a Microsoft Partner in learning following the numerous changes in the learning paths and programs, notably for certification-based courses.
EC-Council
Eccentrix has the highest level of EC-Council partnership, delivering the complete portfolio of EC-Council cybersecurity courses since 2017. With an EC-Council course comes a set of benefits that greatly help our participants get certified. EC-Council is a key vendor for Eccentrix, since we have a strong focus on cybersecurity courses and that relationships just gets better over the years. ...