Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

Access 2010 - Part 2

Základní info

Duration
Classroom Learning - 2 Day(s)
Mentored Learning - Flexible
Online LIVE - 2 Day(s)

Overview
Students will expand their knowledge of Microsoft® Access® 2010 to include relational database design, writing advanced queries, structuring existing data, sharing data across applications, and customizing reports.

Who Should Attend
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

At Course Completion
Upon successful completion of this course, students will be able to: - restructure data into appropriate tables to ensure data dependency and minimize redundancy. - write advanced queries to analyze and summarize data. - create and revise Microsoft® Office Access® 2010 macros. - customize reports by using various Microsoft® Office Access® 2010 features. - maintain their databases using Microsoft® Office Access® 2010 tools. 

Prerequisite(s) or equivalent knowledge
Access 2010 - Part 1
Suggested Next Steps
Access 2010 - Level 3
Outline
Lesson 1: Advanced Form Design
Adding Controls to Forms 
Creating Subforms 
Organizing Information with Tab Pages 
Displaying a Summary of Data in a Form 
Applying Conditional Formatting
Lesson 2: Data Validation
Field and Record Validation 
Form Validation
Lesson 3: Using Macros to Improve User Interface Design
Creating a Macro 
Restricting Records Using a Condition 
Validating Data Using a Macro 
Automating Data Entry Using a Macro 
Converting a Macro to VBA
Lesson 4: Advanced Database Management
Linking Tables to External Data Sources 
Managing a Database 
Determining Object Dependency 
Documenting a Database 
Analyzing the Performance of a Database
Lesson 5: Distributing and Securing a Database
Preparing a Database for Multiple User Access 
Implementing Security 
Setting Passwords 
Converting an Access Database to an ACCDE File 
Packaging a Database with a Digital Signature
Lesson 6: Managing Switchboards
Creating a Database Switchboard 
Modifying a Database Switchboard 
Setting Startup Options

Access 2010 - Part 2

Vybraný termín:

2.10.2014 –  3.10.2014 Upřesnující informace k termínu

Cena
8 400 Kč + 21% DPH

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je šest a jedna ? Součet zapište číslicemi.