MS Access - Database Design (ACS2)

Microsoft, Databases

This course helps users manage data effectively using MS Access. You will learn the program environment, how to modify existing databases, and how to work with core database objects to build practical solutions for everyday data tasks.

The course covers tables and relationships, queries for selection and actions, forms and reports, plus macros and data exchange with other programs. Exercises focus on creating reliable, maintainable database solutions.

Location, current course term

Contact us

Custom

Customized Training (date, location, content, duration)

The course:

Hide detail

• Basic database concepts
1. MS Access environment
2. Basic database objects

• Tables and relationships
1. Table design view
2. Primary key of a table
3. Field data types and their use
4. Field properties
5. Data validation
6. Field indexing
7. Data analysis and splitting into tables
8. Creating relationships
9. Types of relationships and when to use them

• Select and action queries
1. Query design view
2. Using criteria in queries
3. Parameter queries
4. Adding calculated fields
5. Update queries
6. Append queries
7. Delete queries
8. Make-table (create) queries

• Forms and design
1. Creating forms with subforms
2. Editing forms in design view
3. Using controls on forms and their properties

• Reports
1. Creating reports based on queries
2. Sorting and grouping data in a report
3. Working in report design view
4. Preparing a report for printing

• Macros
1. Creating macros with the macro editor
2. Using macros on form controls
3. Setting events using macros

• Working with other programs
1. Importing and linking data from other applications

Assumed knowledge:

User-level database knowledge equivalent to the ACS1 course.

Recommended previous course:

MS Access - Working with Data in Relational Databases (ACS1)

Recommended subsequent course:

MS Access - Application Development (ACS3)

Schedule:

2 days (9:00 AM - 5:00 PM )

Language: