Chat with us, powered by LiveChat

Microsoft Office 2007 Access Beginners

4.9( 7 REVIEWS )
539 STUDENTS

Description:

This Microsoft Office 2007 Access Beginners will allow you to get started quickly with prebuilt applications that can modify or adapt to changing business needs. Collect information through form in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Sharing information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permission, and back up your information at regular intervals.

This series will provide you an overview of the features and functions of Microsoft Office Access 2007. If you are interested to learn all the basics of Microsoft Access 2007, then you should join this course now.

So, if you want to learn beginning level Access 2007 Skills.

Who is this Course for?

Microsoft Office 2007 Access Beginners is perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Entry Requirement:

  • This course is available to all learners, of all academic backgrounds.
  • Learners should be aged 16 or over to undertake the qualification.
  • Good understanding of English language, numeracy and ICT are required to attend this course.

Assessment:

This course does not involve any MCQ exams. Students need to answer 3 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Course Curriculum

Getting Started
Database Concepts 00:05:00
Indentifying Database Components 00:04:00
Exploring the Access Environment 00:03:00
Starting Access and Examining the Access Window 00:06:00
Opening a Database 00:04:00
Getting Help 00:01:00
Using Help 00:03:00
Databases and Tables
Planning and Designing Databases 00:05:00
Creating a Database from a Template 00:01:00
Creating a Blank Database 00:01:00
Exploring Table 00:01:00
Navigating in a Table in Datasheet View 00:05:00
Examining a Table in Design View 00:04:00
Creating Tables 00:05:00
Creating a Table by Using the Table Templates 00:06:00
Creating a Table in Design View 00:02:00
Adding Fields and Descriptions to a Table 00:05:00
Setting the Primary Key 00:01:00
Saving the Table 00:01:00
dding a Record 00:02:00
Copying, Modifying, and Deleting a Table 00:03:00
Creating a Composite Key 00:03:00
Fields and Records
Changing the Design of a Table 00:05:00
Modifying Field Names 00:01:00
Deleting and Inserting Fields 00:02:00
Moving a Field 00:01:00
Using the Attachment Data Type 00:04:00
Adding a Total Row 00:03:00
Finding and Editing Records 00:02:00
Finding and Replacing a Value 00:03:00
Undoing Changes 00:01:00
Organizing Records 00:04:00
Sorting Records by a Single Field 00:01:00
Sorting Records by Multiple Fields 00:02:00
Using Filter by Selection 00:02:00
Using Filter by Form 00:02:00
Using Filter Excluding Selection 00:01:00
Using Advanced FilterSort 00:02:00
Deleting a Record 00:02:00
Data Entry Rules
Setting Field Properties 00:04:00
Using the Allow Zero Length Property 00:03:00
Setting the Field Size Property 00:02:00
Setting the Append Only Property 00:03:00
Working with Input Masks 00:02:00
Creating an Input Mask 00:03:00
Working with the Input Mask Wizard 00:03:00
Setting Validation Rules 00:01:00
Creating Validation Rules 00:03:00
Setting Validation Text 00:02:00
Basic Queries
Creating and Using Queries 00:05:00
Using the Query Wizard 00:04:00
Creating a Query in Design View 00:02:00
Saving and Running the Query 00:01:00
Sorting Query Results 00:01:00
Filtering a Query by Adding Criteria 00:01:00
Creating a Query from a Filter 00:03:00
Modifying Query Results and Queries 00:02:00
Editing Query Results 00:02:00
Adding Fields to a Query 00:01:00
Finding Records with Empty Fields 00:01:00
Performing Operations in Queries 00:04:00
Using Comparison Operators 00:01:00
Using the OR Condition 00:01:00
Using the AND Condition 00:01:00
Using the Wildcard 00:01:00
Using Calculations in a Query 00:03:00
Totaling a Group of Records 00:02:00
Using the Avg and Count Functions 00:01:00
Using Forms
Creating Forms 00:05:00
Examining a Form 00:03:00
Creating a Basic Form 00:01:00
Creating a Form Using the Form Wizard 00:02:00
Using Design View 00:04:00
Creating a Form in Design View 00:01:00
Addings Controls 00:03:00
DModifying Properties 00:06:00
Applying Conditional Formatting 00:03:00
Sorting and Filtering Records 00:01:00
Using a Form to Sort Records 00:01:00
Using a Form to Filter Records 00:01:00
Working with Reports
Reports 00:03:00
Examining a Report 00:01:00
Creating a Basic Report 00:01:00
Creating a Report Using the Report Wizard 00:02:00
Creating a Report Using Design View 00:04:00
Modifying and Printing Reports 00:05:00
Modifying Reports in Design View 00:03:00
Modifying Reports in Layout View 00:03:00
Grouping, Sorting, and Filtering a Report 00:02:00
Adding Summary Fields Using the Report Wizard 00:02:00
Modifying the Layout and Style of a Report 00:01:00
Assessment
Course Certification
Order your Certificate 00:00:00

Course Reviews

4.9

4.9
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

Instructors

539 STUDENTS ENROLLED

Video Courses

© Course Gate Edukite Ltd, Reg no: 11378092