Menu

Easter special sale Get up to 45% OFF until 31st Marsee the offers

Menu
  • No products in the basket.

MS Access 2007 Basics Video Course

0( 0 REVIEWS )
105 STUDENTS
ACCREDITED BY
MS Access 2007 Basics Video Course

Overview:

Microsoft Access seems to intimidate people, and if you are one of them this course is the stepping stone to acquiring basic skills and knowledge of Microsoft Access 2007 Basic.  The course is perfect to get beginners started on how to create a database from scratch. It is a step- by step approach and hands-on training that is explained in a simple and straightforward manner.  The course is intended for beginner-level users who want to gain an understanding of the basic components of a database. You will learn how to enter information into a database and how to extract it. Getting certified in Microsoft Access 2007 Basic will make individuals competent to potential employees and companies as this is a must-have popular skill of Microsoft.

The Microsoft Access 2007 Basic course will teach learners how to create Forms, Queries and Reports. Individuals will gain an overview of the functions and features of Access 2007.

Microsoft Access is a core skill that will teach learners how to import existing data and export data into a database and onto a file. The course will help Individuals become proficient in Access 2007 for both business and personal use. It is an essential skill that can be applied to any job role. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Access 2007 Basic.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

  • Learn how to create a simple database.
  • Learn how to create a table in Access.
  • Learn how to create a form.
  • Learn how to navigate through a dashboard, tools and ribbons.
  • Learn how to create a Report.

Course Titles

  • Module 01: Getting Started
  • Module 02: Databases and Tables
  • Module 03: Fields and Records
  • Module 04: Data Entry Rules
  • Module 05: Basic Queries
  • Module 06: Using Forms
  • Module 07: Working with Reports

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Who is this Course aimed at?

  • The course is aimed at individuals who have no prior knowledge of Access 2007.
  • Students looking to expand their skills in Microsoft Office Access 2007.
  • The course is ideal for individuals who are web developers and analysts.
  • Anyone interested in developing their skills in Microsoft Office Access 2007.

Entry Requirements

  • You must be 16 or over
  • You should have a basic understanding of English and basic IT knowledge
  • You will need a computer or tablet with internet connection (or access to one)

Method of Assessment

At the end of the Microsoft Access 2007 Basic course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.

Certification

Those who successfully complete the exam will be awarded the certificate in Microsoft Access 2007 Basic.

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Progression and Career Path

Once you successfully complete Microsoft Access 2007 Basic you will be qualified to work in the following positions. The Microsoft Access 2007 Basic qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to https://www.payscale.com is given below.

  • Office Administrator – £17,158 per annum
  • Web Developer – £24,833 per annum
  • Project Assistant – £20,785 per annum
  • Business Executive – £23,667 per annum
  • Business Analyst – £35,543 per annum
  • Technical Support Analyst – £22,753per annum

Other Benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Excellent Tutor Support Service (Monday to Friday)
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Quizzes, tests mock exams, practice exams to ensure you are 100% ready
  • Eligible for a NUS discount card
  • Free Career Support Service
  • 25% Discount on personal Statement and covering letter writing service
  • Free Access to Over 150 courses for 2 days (48 hours)
  • Free access to course before you purchase (For selected courses only)

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 175
➤ Module 1: Getting Started
1.0 Topic A: Database Concepts
1.1 Database Components
1.2 Demo – A-1: Identifying Database Components
1.3 Relational Database
2.0 Topic B: Exploring the Access Environment
2.1 Access Environment
2.2 Demo – B-1: Starting Access and Examining the Access Window
2.3 Opening Databases
2.4 Demo – B-2: Opening a Database
2.5 The Navigation Pane
2.6 Open a Database Table
3.0 Topic C: Getting Help
3.1 Microsoft Access Help Online
3.2 Access Help Offline
3.3 Demo – C-1: Using Help
3.4 Unit 01 Review
➤ Module 02- Databases and Tables
1.0 Topic A: Planning and Designing Databases
1.1 Planning a Database
1.2 Rules for Names
1.3 Database Templates
1.4 Demo – A-1: Creating a Database from a Template
1.5 Creating Blank Databases
1.6 Demo – A-2: Creating a Blank Database
2.0 Topic B: Exploring Tables
2.1 Views
2.2 Datasheet View
2.3 Navigating in Datasheet View
2.4 Record Selector
2.5 Demo – B-1: Navigating in a Table in Datasheet View
2.6 Table in Design View
2.7 Demo – B-2: Examining a Table in Design View
3.0 Topic C: Creating Tables
3.1 Fields in the Events Template
3.2 Demo – C-1: Creating a Table by Using the Table Templates
3.3 Creating Tables in Design View
3.4 Demo – C-2: Creating a Table in Design View
3.5 Demo – C-3: Adding Fields and Descriptions to a Table
3.6 Setting the Primary Key
3.7 Demo – C-4: Setting the Primary Key
3.8 The Save As Dialog box
3.9 Demo – C-5: Saving the Table
3.10 Adding a Record
3.11 Demo – C-6: Adding a Record
3.12 Paste Table As Dialog Box
3.13 Demo – C-7: Copying, Modifying, and Deleting a Table
3.14 Composite Key
3.15 Demo – C-8: Creating a Composite Key
3.16 Unit 02 Review
➤ Module 03 - Fields and Records
1.0 Topic A: Changing the Design of a Table
1.1 Ineffective Field Names
1.2 Demo – A-1: Modifying Field Names
1.3 Selecting a Field
1.4 Deleting and Inserting Fields
1.5 Demo – A-2: Deleting and Inserting Fields
1.6 Moving Fields
1.7 Demo – A-3: Moving a Field
1.8 Attachment Data Type
1.9 The Attachments Dialog Box
1.10 Demo – A-4: Using the Attachment Data Type
1.11 Using a Total Row
1.12 Demo – A-5: Adding a Total Row
2.0 Topic B: Finding and Editing Records
2.1 Find and Replace Dialog Box
2.2 Demo – B-1: Finding and Replacing a Value
2.3 Undoing Changes
2.4 Demo – B-2: Undoing Changes
3.0 Topic C: Organizing Records
3.1 Sorting Records by a Single Field
3.2 Demo – C-1: Sorting Records by a Single Field
3.3 Sorting Records by Multiple Fields
3.4 Demo – C-2: Sorting Records by Multiple Fields
3.5 Filter by Selection
3.6 Filter from the Shortcut Menu
3.7 Demo – C-3: Using Filter by Selection
3.8 Filter by Form
3.9 Demo – C-4: Using Filter by Form
3.10 Filter Excluding Selection
3.11 Demo – C-5: Using Filter Excluding Selection
3.12 Advanced Filter/Sort
3.13 Demo – C-6: Using Advanced Filter/Sort
3.14 Deleting Records
3.15 Demo – C-7: Deleting a Record
3.16 Unit 03 Review
➤ Module 4 - Data Entry Rules
1.0 Topic A: Setting Field Properties
1.1 Field Properties
1.2 Required Property
1.3 Demo – A-1: Setting the Required Property
1.4 Allow Zero Length Property
1.5 Demo – A-2: Using the Allow Zero Length Property
1.6 Field Size Property
1.7 Demo – A-3: Setting the Field Size Property
1.8 Append Only Property
1.9 History Dialog Box
1.10 Demo – A-4: Setting the Append Only Property
2.0 Topic B: Working with Input Masks
2.1 Input Mask Definition: Sections
2.2 Creating Input Masks
2.3 Demo – B-1: Creating an Input Mask
2.4 Using the Input Mask Wizard
2.5 Demo – B-2: Working with the Input Mask Wizard
3. Topic C: Setting Validation Rules
3.1 Creating Validation Rules
3.2 Demo – C-1: Creating Validation Rules
3.3 Setting Validation Text
3.4 Demo – C-2: Setting Validation Text
3.5 Unit 04 Review
➤ Module 05 - Basic Queries
1.0 Topic A: Creating and Using Queries
1.1 Queries
1.2 The Simple Query Wizard
1.3 Demo – A-1: Using the Query Wizard
1.4 Creating Queries in Design View
1.5 Demo – A-2: Creating a Query in Design View
1.6 Saving and Running a Query
1.7 Demo – A-3: Saving and Running the Query
1.8 Sorting Results of a Query
1.9 Demo – A-4: Sorting Query Results
1.10 Filtering Query Results
1.11 Demo – A-5: Filtering a Query by Adding Criteria
1.12 Creating Queries from Filters
1.13 Demo – A-6: Creating a Query from a Filter
2.0 Topic B: Modifying Query Results and Queries
2.1 Editing Query Results
2.2 Demo – B-1: Editing Query Results
2.3 Modifying the Query Design
2.4 Demo – B-2: Adding Fields to a Query
2.5 Searching for Null Values
2.6 Demo – B-3: Finding Records with Empty Fields
3.0 Topic C: Performing Operations in Queries
3.1 Using Comparison Operators
3.2 Demo – C-1: Using Comparison Operators
3.3 Using the OR Condition
3.4 Demo – C-2: Using the OR Condition
3.5 Using the AND Condition
3.6 Demo – C-3: Using the AND Condition
3.7 Wildcard Operators
3.8 Demo – C-4: Using the * Wildcard
3.9 Using Calculations
3.10 Demo – C-5: Using Calculations in a Query
3.11 Totaling a Group of Records
3.12 Demo – C-6: Totaling a Group of Records
3.13 Avg and Count Functions
3.14 Demo – C-7: Using the Avg and Count Functions
3.15 Unit 05 Review
➤ Module 6 - Using Forms
1.0 Topic A: Creating Forms
1.1 A Sample Form
1.2 Form in Design View
1.3 Form Tools on the Design Tab
1.4 Form Tools on the Layout Tab
1.5 Demo – A-1: Examining a Form
1.6 The Form Feature
1.7 A Basic Columnar Form
1.8 Demo – A-2: Creating a Basic Form
1.9 The Form Wizard
1.10 Demo – A-3: Creating a Form Using the Form Wizard
2.0 Topic B: Using Design View
2.1 Creating Forms in Design View
2.2 Demo – B-1: Creating a Form in Design View
2.3 Adding a Control
2.4 Demo – B-2: Adding Controls
2.5 Property Sheet
2.6 Modifying Section Properties
2.7 Demo – B-3: Modifying Properties
2.8 Conditional Formatting
2.9 Demo – B-4: Applying Conditional Formatting
3.0 Topic C: Sorting and Filtering Records
3.1 Sorting Records
3.2 Demo – C-1: Using a Form to Sort Records
3.3 Filtering Records
3.4 Demo – C-2: Using a Form to Filter Records
3.5 Unit 06 Review
➤ Module 7 - Working with Reports
1.0 Topic A: Reports
1.1 Print Preview
1.2 Demo – A-1: Examining a Report
1.3 Basic Reports
1.4 Demo – A-2: Creating a Basic Report
1.5 Using the Report Wizard
1.6 Sample Report Preview
1.7 Demo – A-3: Creating a Report Using the Report Wizard
1.8 Sections in Design View
1.9 Demo – A-4: Creating a Report Using Design View
2.0 Topic B: Modifying and Printing Reports
2.1 Modifying Reports
2.2 Demo – B-1: Modifying Reports in Design View
2.3 Layout View
2.4 Demo – B-2: Modifying Reports in Layout View
2.5 Grouping Records in a Report
2.6 Group, Sort, and Total Pane
2.7 Demo – B-3: Grouping, Sorting, and Filtering a Report
2.8 Adding Summary Fields
2.9 The Summary Options Dialog Box
2.10 Demo – B-4: Adding Summary Fields Using the Report Wizard
2.11 Modifying Layout and Style
2.12 Demo – B-5: Modifying the Layout and Style of a Report
2.13 The Page Layout Group
2.14 Unit 07 Review
WhatsApp chat