Course not currently available
Access - Data Base Designing Training Course
Course
Online
Description
-
Type
Course
-
Methodology
Online
The course participants will learn how to design a database and how to adapt it to work with the end user.
About this course
Knowledge of Windows.
Reviews
Subjects
- Printing
- Graphics
- Access
- Database
- Database training
- Design
Course programme
- Analysis of the current system
- Define database items
- Normalization
- Relations between the elements
- Naming standards
- Create a database
- Methods for creating arrays (Design View, Wizard, Inputting Data)
- Data types
- Field properties
- Adding and editing a record
- setting the record
- Search record
- Copying tables
- Keys
- Relations tables
- Dependencies
- Create queries
- Using the Query Wizard
- Operations on the results of the query
- criteria query
- Calculations and operators in queries
- Types of controls
- Using AutoForm
- Using the wizard forms (Form Wizard)
- Properties of controls and forms
- Printing forms.
- Create a subform (Subform)
- Headers and footers
- Create reports.
- Using AutoReport
- Using the Report Wizard (Report Wizard)
- Sections
- Properties reports
- AutoFormat
- Special Effects
- Open a form at runtime database
- Adding graphics, spell check
- Switchboards
- Passwords
- Database encryption
- Security Wizard
Additional information
Access - Data Base Designing Training Course