Home >
Microsoft Office >
Introduction to MS Access
Introduction to MS Access
| Course Code: |
OFFAC1 |
| Duration: |
2 days |
| Prerequisites: |
Good working knowledge of the Windows operating system.
|
| Objectives: |
Upon completion of this presentation, the participant should
be able to design and create an Access database, tables, queries, forms, and reports.
|
| Core Topics: |
Access Basics
- What is a relational database?
- Access database objects
- Working with an existing Access database
- Add, edit, delete a record using a table and a form
- Check spelling and AutoCorrect
- Find and replace data
- Sort data
- Filter data
- Print data
Database Design Concepts
- Organise data
- Normalization
- Relationships
- Referential integrity
- Primary key/foreign key
- Constraints
- Indexes
- Data types
Create an Access Database
- Using Wizards
- Defining relationships in Access
- Access data types
- Access database limitations
Access Table Design
- Using design view
- Adding and naming fields
- Assigning field types
- Assigning field properties
- Creating key fields
- Index considerations
Forms
- Using the Form Wizard
- Modifying the form design
- Using a form to locate and organise information
Queries
- Create a query in Design View
- Joining tables in a query
- Add criteria to a query
- Using wildcards
- Add calculations to a query
Reports
- AutoReport
- Report Wizard
- Modify a report
|
