Microsoft Office 2007 Access Beginners - Complete Video Course
499 Students
GET ACCESS TO THIS COURSE ALONG WITH 3000+ ONLINE COURSES FOR A YEAR FOR JUST £49. GET NOW
Save 93.71 % - Offer ENDS SOON
Access All Courses for Only £49
14-Day Money-Back Guarantee
-
1 Year
Access -
Beginner
Skill Level -
4 hours, 34 minutes
Duration
Description:
This Microsoft Office 2007 Access Beginners – Complete Video Course 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.
Assessment:
- At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.
- Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.
Certification:
- After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.
- Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
Who is this Course for?
Microsoft Office 2007 Access Beginners – Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it 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.
Requirements
Our Microsoft Office 2007 Access Beginners – Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
-
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
-
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
-
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
-
Setting Field Properties 00:04:00
-
Setting the Required Property 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
-
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
-
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
-
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
-
Order Your Certificates and Transcripts
Frequently Asked Questions
Most courses do not require prior qualifications unless stated otherwise on the course page. Please check the individual course description for any specific entry requirements.
Learners must usually be 16 years or older to enrol. However, learners under 16 may join with parental or guardian consent.
Yes, if you do not pass the exam on your first attempt, you may retake the exam up to 3 times, depending on the course terms.
You will normally have 1 year of access to your course from the date of enrolment. Course duration may vary, and the estimated study time is mentioned on the relevant course page.
Yes, our courses are available worldwide. You can enrol and study from any country as long as you have an internet-connected device.
