Knowing how to change field captions, change field data types and field sizes, set default values and using input masks are skills that are not only helpful in maintaining a database, but are skills that will most likely be covered on the Access 2010 MOS
- [Instructor] The behavior of a field…is defined and controlled by the properties you assign…and also the data type that's applied to that field.…On the Access 2010 MOS exam, you will be asked to insert…a new field, to create a field,…to change captions for that field, change the data type,…change the field size, and to set default values.…In this video I'll focus on…how to assign properties to a field…and we'll make sure in focus on the different properties…that may be covered on the Access 2010 MOS exam.…
I have the 03 02 exercise file open so let's get started.…So in this database,…we have several tables that have been created.…We're going to focus on the Order Information table.…I'll double-click to open it up.…And we'll just take a quick look.…We have an OrderID, CustomerID, EmployeeID, OrderDate etc.…When we enter information into this database,…we need to make sure…that we always enter the CustomerID field.…Therefore we should make that field a required field.…
Let's go into Design View…and I'll show you how to make that change.…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.