|
Provided by: Act Training Access Level 1Computer |
 |
Training
Provided by Act Training
Beginners level one day instructor led course on Microsoft Access. Topics include: Overview of Access, Creating Tables, Working with Tables, Creating and Using Select Queries, Creating and Using Forms, Creating and Using Reports.
The only prerequisite for this course is having a basic knowledge of Windows.
Related Software Programs or Products: Microsoft Access
|
|
||||||||||||
Access Level 1
Lesson 1: Overview of Access
Introduction to Database Concepts and Terminology
Introduction to Access
Database Planning and Design
Lesson 2: Creating Tables
Examining a Table
Creating a Table With the Table Wizard
Creating a Table in Design View
Types of Primary Keys
Lesson 3: Working with Tables
Modifying a Table Using Design View
Finding and Editing Records
Filtering and Sorting Records
Lesson 4: Creating and Using Select Queries
Creating a Select Query to View Specific Fields
Specifying Criteria in a Query to View Specific Records
Using Queries to Perform Calculations
Joining Tables in a Query
Lesson 5: Creating and Using Forms
Creating a Form With the Form Wizard
Modifying the Form Design
Using a Form to Locate and Organize Information
Multiple-Table Forms
Lesson 6: Creating and Using Reports
Creating a Report With the Report Wizard
Creating a Report That Contains Totals
Introduction to Database Concepts and Terminology
Introduction to Access
Database Planning and Design
Lesson 2: Creating Tables
Examining a Table
Creating a Table With the Table Wizard
Creating a Table in Design View
Types of Primary Keys
Lesson 3: Working with Tables
Modifying a Table Using Design View
Finding and Editing Records
Filtering and Sorting Records
Lesson 4: Creating and Using Select Queries
Creating a Select Query to View Specific Fields
Specifying Criteria in a Query to View Specific Records
Using Queries to Perform Calculations
Joining Tables in a Query
Lesson 5: Creating and Using Forms
Creating a Form With the Form Wizard
Modifying the Form Design
Using a Form to Locate and Organize Information
Multiple-Table Forms
Lesson 6: Creating and Using Reports
Creating a Report With the Report Wizard
Creating a Report That Contains Totals
About The Training Provider: Act Training
Act Training - We provide training in Computer Applications such as Microsoft Word, Excel, PowerPoint, Access, Outlook, Sage Accounts and Sage Payroll; Professional IT subjects such as CompTIA A plus, CompTIA N plus, MCP, MCSA, MCSE and CISCO; Office skills such as Bookkeeping, Accounting, Pitman & Teeline Shorthand, OCR Text Processing and Keyboard skills.
These subjects are taught on site for individuals...
