Duration
3 days
Course Description
The main purpose of the course is to give users a good understanding of basic database concepts. It is designed for users who are used to manage data in spreadsheets but wish to understand why and how a database will provide a better solution. The course includes create databases, construct data tables, design relationship and queries, develop forms, and generate reports.
Audience
The primary audience for this course is for individuals who have no knowledge with Access 2019 or more experienced Access users who want to learn the topics covered in this course using the Microsoft Office Access 2019 interface.
Prerequisites
- Familiarity with using a personal computer, mouse, and keyboard.
- Comfortable in the Windows environment.
- Ability to launch and close programs, navigate to information stored on the computer, and manage files and folders.
Learning Objectives
After completing this course, students will be able to:
- Build an Access Database from scratch
- Create Tables to store and organize all data
- View records in organized layout using Forms
- Use a Query to search and retrieve data fast
- Generate professional looking Reports
- Perform Import and Export data for collaboration
Course Outline
BASIC LEVEL
Lesson 1: Database Essentials
- Working in the Access Interface
- Selecting Tools and Commands
- Defining Data Needs and Types
Lesson 2: Creating Database Tables
- Creating a Database
- Creating a Table
Lesson 3: Working With Tables And Database Records
- Navigating Among Records
- Entering, Editing, and Deleting Records
- Working with Primary Keys
- Finding and Replacing Data
- Sorting and Filtering Data
- Setting Field Viewing Options within a Table
- Understanding Table Relationships
Lesson 4: Modifying Tables And Fields
- Modifying a Database Table
- Creating Fields and Modifying Field Properties
Lesson 5: Creating Form
- Creating Forms
- Sorting and Filtering Data within a Form
Lesson 6: Creating Reports
- Creating Reports
- Applying a Theme
- Working with Reports
INTERMEDIATE LEVEL
Lesson 7: Creating And Modifying Queries
- Creating a Query
- Modifying a Query
- Sorting and Filtering Data within a Query
Lesson 8: Using Controls In Reports And Forms
- Adding Controls
- Defining Control Tab Order
- Formatting Controls
- Arranging Control Alignment, Size, and Position
- Adjusting Page Margins and Changing Page Orientation for Forms and Reports
Lesson 9: Advanced Tables
- Creating a Custom Table
- Summarizing Table Data
Lesson 10: Advanced Forms
- Creating Advanced Forms
- Using Application Parts to Create Blank Forms
- Creating and Modifying a Navigation Form
Lesson 11: Advanced Reports
- Defining Groups
- Creating a Subform on a Report
- Creating the Print Layout
ADVANCED LEVEL
Lesson 12: Advanced Queries
- Creating Crosstab Queries
- Creating a Subquery
- Saving a Filter as a Query
- Creating Action Queries
- Understanding Advanced Query Modification
Lesson 13: Displaying And Sharing Data
- Creating a Chart Using the Chart Wizard
- Formatting a Chart
- Saving a Database Object as Another File Type
- Printing a Database Object
Lesson 14: Importing And Exporting Data
- Importing Data
- Exporting Data
Lesson 15: Database Tools
- Maintaining a Database
- Saving a Database as a Template
- Encrypting a Database
- Configuring Database Options
- Using Database Tools
Programme scope, delivery arrangements and suitability are confirmed during enquiry.