In this course, you will learn how to use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. For others, data management may consist of an incidental job responsibility, such as time reporting or recording a sale.
A relational database application such as Microsoft Access can help you and your organisation collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool, or you can use it as a construction set to develop applications for an entire department or organisation.
Target Audience:
The target students for this course are delegates who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.
Prerequisites
- Use a mouse
- Type and use a keyboard
- Navigate through Windows files and folders
- Work with Windows – minimise, maximise, open and close
Delegates will learn how to
At the end of this course you will be able to:
- Identify the basic components of an Access database
- Build the structure of a database
- Manage data in tables
- Query a database
- Generate reports
- Customise the Access environment
Outline
Lesson 1: Getting Started with Access
- Topic A: Orientation to Microsoft Access
- Topic B: Create a Simple Access Database
- Topic C: Get Help in Microsoft Access
Lesson 2: Working with Table Data
- Topic A: Modify Table Data
- Topic B: Sort and Filter Records
- Topic C: Create Lookups
Lesson 3: Querying a Database
- Topic A: Join Data from Different Tables in a Query
- Topic B: Sort and Filter Data in a Query
- Topic C: Perform Calculations in a Query
Lesson 4: Creating Advanced Queries
- Topic A: Create Parameter Queries
- Topic B: Create Action Queries
- Topic C: Create Unmatched and Duplicate Queries
- Topic D: Summarise Data
Lesson 5: Generating Reports
- Topic A: Create a Report
- Topic B: Add Controls to a Report
- Topic C: Enhance the Appearance of a Report
- Topic D: Prepare a Report for Print
Lesson 6: Customising the Access Environment
- Topic A: The Access Options Dialog Box