Course Outline

Database Fundamentals

  • 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

Records and operations records

  • Adding and editing a record
  • setting the record
  • Search record
  • Copying tables

Create a relational database

  • Keys
  • Relations tables
  • Dependencies

Queries

  • Create queries
  • Using the Query Wizard
  • Operations on the results of the query
  • criteria query
  • Calculations and operators in queries

Forms and controls

  • 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

Reports

  • Create reports.
  • Using AutoReport
  • Using the Report Wizard (Report Wizard)
  • Sections
  • Properties reports

Additional tools for forms and reports

  • AutoFormat
  • Special Effects
  • Open a form at runtime database
  • Adding graphics, spell check
  • Switchboards

Exporting, importing and linking data

Security

  • Passwords
  • Database encryption
  • Security Wizard

Backups

Requirements

Knowledge of Windows.

  21 Hours
 

Related Courses

Related Categories