Microsoft Access 2016
The curriculum extends the learning process to ensure that students have the opportunity to explore all areas of a program pertinent to the corresponding MOS certification objectives, or that have been identified as most important for users to understand, through the completion of individual activities. Through this extended practice, the curriculum provides provide a significant opportunity for the hands-on program experience that is expected and required of a successful certification candidate or power user.
This curriculum assumes that students are studying the program by using the associated Microsoft Imagine Academy course or other available curriculum, including but not limited to resources available on the Microsoft Office website, Microsoft Press books or e-books such as the MOS Study Guides, Microsoft Official Curriculum (MOC) courses, Microsoft Official Academic Curriculum (MOAC) courses, and other resources that are appropriate to and available within the student’s specific environment.
This content is divided into 15 lessons. Each lesson is designed to provide approximately 45 minutes of instruction and discussion. Each teaching lesson includes two or more sub-sections, couple of projects that can be completed in or out of class, and a quiz.
Instructors can organize the lesson instruction and project assignments as necessary to fit class schedules.
Objetivos
- Navigate through a Database
- Create and Modify Databases
- Create Tables
- Manage Relationships and Keys
- Navigate through a Database
- Manage Tables
- Manage Records in Tables
- Create and Modify Databases
- Manage Tables
- Create and Modify Fields
- Create a Form and Format a Form
- Create, Configure and format Report Controls
- Create and modify a Query
- Configure and format a Form
- Configure Report Controls
Duración
25 horas
Curso Online
Programa
-
Lesson 1: Database Essentials
-
Lesson 2: Creating Database Tables
-
Lesson 3: Working with Tables and Database Records
-
Lesson 4: Modifying Tables and Fields
-
Lesson 5: Creating Forms
-
Lesson 6: Creating Reports
-
Lesson 7: Creating and Modifying Queries
-
Lesson 8: Using Controls in Reports and Forms
-
Lesson 9: Advanced Tables
-
Lesson 10: Advanced Forms
-
Lesson 11: Advanced Reports
-
Lesson 12: Advanced Queries
-
Lesson 13: Displaying and Sharing Data
-
Lesson 14: Importing and Exporting Data
-
Lesson 15: Importing and Exporting Data