This [course_title] 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
This course does not involve any written exams. Students need to answer 5 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.
Certification
Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.
Having an Official Edukite Certification is a great way to celebrate and share your success. You can:
- Add the certificate to your CV or resume and brighten up your career
- Show it to prove your success
Course Credit: Edukite
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 | ||
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 | ||
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 | |||
Submit Your Assignment | 00:00:00 | ||
Certification | 00:00:00 |
Course Reviews
No Reviews found for this course.