Course not currently available

Access - Data Base Designing Training Course

Nobleprog Limited

Course

In Birmingham ()

£ 3,100 VAT inc.

The best Access courses

See all

See all

Description

  • Type

    Course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access
  • Database
  • Database training
  • Design

Course programme

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

Additional information

21 hours (usually 3 days including breaks)

See related categories

Access - Data Base Designing Training Course

£ 3,100 VAT inc.

The best Access courses

See all

See all