Microsoft Access 2013 / 2010: Level 1
Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
- An overview of the program user interface
- An overview of data models and database design
- Introducing Access objects
- Creating a sample data database
- Understanding data types
- Working with basic (SELECT) queries
- Producing basic forms
- Producing basic reports
Prerequisites
- Familiarity with personal computers and keyboard and mouse
- Basic Microsoft Windows Skills
- Knowledge of Excel data management (Optional)
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: Working with SELECT queries
- Topic B: Sort and Filter Data in a Query
- Lesson 4: Generating Forms
- Topic A: Create a Report
- Topic B: understanding layout view
- Topic C: creating a form using a wizard
- Topic D: Adding controls to a blank form
- Lesson 5: Generating Reports
- Topic A: Create a Report
- Topic B: Enhance the Appearance of a Report
- Topic C: Prepare a Report for Print
- Lesson 6: Customizing the Access Environment
- Topic A: The Access Options Dialog Box