Access - Data Base Designing

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

• 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