MS Access module, Office Admin ProgramMS Access Module: Desktop Databases

Microsoft Access combines relational database features with an easy interface to create small to medium size desktop applications quickly, then deploy and maintain them.

Book an appointment Call 847-350-9034

Office Admin ProgramWeekly quizzesFinal project

Ten parts of the course

From tables and queries to forms, reports and security. 1

Introduction

Databases, interface, new database, tables and data types.2

Building tables

Primary keys, validation, importing from Excel and CSV.3

Relationships

Relationships, referential integrity and data integrity.4

Querying data

Basic queries, criteria, sorting, calculated fields.5

Advanced queries

Parameter, crosstab and action queries; reports intro.6

Creating forms

Form design tools, data entry forms, controls.7

Custom forms

Combo boxes, sub forms, tab controls, form macros.8

Reports

Grouping, sorting, calculated controls, report macros.9

Data analysis

Exporting, PivotTables, Pivot Charts, Access with Excel.10

Security and VBA

User-level security, backup, VBA intro, review and Q&A.

Detailed course content

Topics in each part.

1 to 3. Tables and relationships

✓Understanding databases; the Access interface and ribbon✓Creating tables, setting primary keys, data validation✓Importing data from Excel and CSV✓Establishing relationships and enforcing integrity

4 and 5. Queries

✓Creating basic queries; criteria and sorting✓Calculated fields and expressions✓Parameter and crosstab queries✓Action queries (update, delete, append)

6 to 8. Forms and reports

✓Form design tools and data entry forms✓Form controls, navigation, combo boxes and list boxes✓Sub forms, tab controls and form macros✓Basic reports, grouping and sorting, calculated controls

9 and 10. Analysis and security

✓Exporting data; PivotTables and Pivot Charts✓Using Access with Excel; importing and exporting data✓User-level security, backup and maintenance✓Introduction to VBA (Visual Basic for Applications)

Course assessment

✓Weekly quizzes to assess understanding✓Hands-on projects to apply knowledge✓Final project: a professional document showcasing MS Access skills

Support and salient features

Career support and classroom features that come with the course.

Staffing support

✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and technology preparation✓Internship with internal project work✓Externship with client project work

Our salient features

✓Hands-on labs and homework✓Group discussion and case study✓Course project work✓Regular quiz and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed class

Ready to start build databases?

Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointment Call 847-350-9034 Education grant program

Ten parts of the course

From tables and queries to forms, reports and security.1

Introduction

Databases, interface, new database, tables and data types.2

Building tables

Primary keys, validation, importing from Excel and CSV.3

Relationships

Relationships, referential integrity and data integrity.4

Querying data

Basic queries, criteria, sorting, calculated fields.5

Advanced queries

Parameter, crosstab and action queries; reports intro.6

Creating forms

Form design tools, data entry forms, controls.7

Custom forms

Combo boxes, sub forms, tab controls, form macros.8

Reports

Grouping, sorting, calculated controls, report macros.9

Data analysis

Exporting, PivotTables, Pivot Charts, Access with Excel.10

Security and VBA

User-level security, backup, VBA intro, review and Q&A.

Detailed course content

Topics in each part.1

1 to 3. Tables and relationships

✓Understanding databases; the Access interface and ribbon✓Creating tables, setting primary keys, data validation✓Importing data from Excel and CSV✓Establishing relationships and enforcing integrity2

4 and 5. Queries

✓Creating basic queries; criteria and sorting✓Calculated fields and expressions✓Parameter and crosstab queries✓Action queries (update, delete, append)3

6 to 8. Forms and reports

✓Form design tools and data entry forms✓Form controls, navigation, combo boxes and list boxes✓Sub forms, tab controls and form macros✓Basic reports, grouping and sorting, calculated controls4

9 and 10. Analysis and security

✓Exporting data; PivotTables and Pivot Charts✓Using Access with Excel; importing and exporting data✓User-level security, backup and maintenance✓Introduction to VBA (Visual Basic for Applications)5

Course assessment

✓Weekly quizzes to assess understanding✓Hands-on projects to apply knowledge✓Final project: a professional document showcasing MS Access skills

Support and salient features

Career support and classroom features that come with the course.1

Staffing support

✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and technology preparation✓Internship with internal project work✓Externship with client project work2

Our salient features

✓Hands-on labs and homework✓Group discussion and case study✓Course project work✓Regular quiz and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed class

Ready to start build databases?

Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointment Call 847-350-9034 Education grant program