MICROSOFT ® ACCESS
INTRODUCTION & INTERMEDIATE TRAINING
Microsoft ® Access is a popular database program enabling the user to manipulate data in a number of ways. Data can be analysed and sorted, specific information can be searched for, and the results can be used to produce reports, lists and more.
This course will be of great interest to all business, finance and IT professionals who create and work with databases. Participants will see how creating a database makes handling data much easier and you will be able to maximize the functionality of the data and reduce data redundancy.
Who is the target audience?
- Anyone new to Microsoft Access
- No previous knowledge of MS Access required. This course is created for absolute beginners.
- Anyone new to the data management role
- Anyone who wants to learn data management and Microsoft Access
- Users of earlier versions of Access looking to update their skills.
Microsoft Access Course Outline:
- Getting started with MS Access
- Create a Blank Database
- Create & Manage Tables & Fields
- Designing Database
- Designate Primary & Foreign Keys
- Determine Table Relationship
- Enter & Modify Data Records
- Import Table into Access from Excel
- Create Queries
- Saving Queries
- Creating forms
- Using Form Wizard
- Modify the design of a form
- Generating Reports
- Creating Report Wizard
- View an access report
- Creating Mailing Label
