Microsoft Access Level 1 ACC-01

Module 1What Is A Relational Database

• What is a database
• l Level 1
• What makes data a database and not a spreadsheet
• What makes a relational database “relational”?
• What are the parts of a relational database

Module 2Exploring Microsoft Access

• Opening and viewing Microsoft Access
• Touring the Access Window
• Exploring the main parts of an Access database
• Using the Access Help features
• Using the navigation pane

Module 3Planning a Relational Database

• Planning a database
• Identifying classes
• Identifying class attributes
• Identifying objects
• Defining columns

Module 4Splitting Information Into Tables

• The first rule: Making sure every record is unique
• Breaking columns down to their lowest forms
• Another rule: Avoiding repeats of information
• Another rule: Avoiding multiples of the same column
• Another rule: Columns need to relate to a primary key
• Keeping historical data

Module 5Designing and Building a Database

• Building a database from an existing template
• Creating a database
• Testing tables in a database

Module 6Importing Data int o Access

• Importing Data from an Access Database
• Importing Data from Excel

Module 7Designing Database Tables

• Creating table lookups
• Using table field properties
• Using input masks
• Using validation rules
• Changing field structure in tables

Module 8Creating Table Relationshi ps

• Defining relationships between tables
• Establishing relationships between tables
• Using subdatasheets in tables

Module 9Creating Forms

• Creating a basic form
• Creating a form with the form wizard
• Creating a split form
• Creating subforms

Module 10Form Design

• Enhancing the appearance of a form
• Charging form layout
• Using form properties
• Adding comm a nd buttons to a form

Module 11Creating Basic Queries

• Creating as query with a wizard
• Creating a query from scratch
• Editing a query

Module 12Creating Basic Reports

• Creating a report from a table
• Creating a report from a query
• Examining report types
• Documenting the database