Microsoft Certified Application Specialist:
Microsoft Access 2007


Courseware utilized addresses Microsoft Certified Application Specialist skills for Microsoft Office.
The following indicate where Access 2007 skills are covered. For example, "Identify fields apporopriate
for Boolean operators "1" is the Level, 3-B indicates the lesson
and topic applicable to that skill and 3-2 indicates the activity number.


1. Structuring a Database

Objective        Level   -     Topic(s)   -     Activity(s)
1.1        Define data needs and types                         
1.1.1        Define table fields                        
•        Establish which data needs to be stored and which should be calculated at run time        1   3-B        
•        Identify fields appropriate for Boolean operators        1        3-B        3-2
1.1.2        Define appropriate table field data types for fields in each table                        
•        Select a text or number field for the appropriate situation1 3-B        3-2
•        Select the correct number type        1        3-B        
•        Determine when to use currency versus number        1        3-B        3-2
•        Determine when to use a memo field        1        3-B        
•        Multi-value fields        1        3-B        3-2
1.1.3        Define tables in databases                        
•        Define tables based on available data        1        2-C        
•        Define 3NF tables        3        1-A        
•        Decide whether data should be linked to or imported from external sources        3        6-A        6-1
•        Create tables that do not contain repeating groups        1        2-F        
1.2        Define and print table relationships                        
1.2.1        Create relationships                        
•        One to one        1        2-H, 3-D        
•        One to many                2-H, 3-D        
1.2.2        Modify relationships                        
•        Enforce referential integrity        1        3-D        3-6
•        Cascade update        1        3-D        
•        Cascade delete        1        3-D        
•        Define join type (Not ad-hoc joins created in the query editor)        2        2A        
1.2.3        Print table relationships        1                3-6
1.3        Add, set, change, or remove primary keys                        
1.3.1        Define and modify primary keys                        
•        Default AutoNumber key        1        3-B        3-2
•        Define a data field as the primary key        1        3-B        3-2
1.3.2        Define and modify multi-field primary keys        1        2-G        
1.4        Split databases                        
•        To overcome size restrictions        4        4-A        
•        For multi-user applications        4        4-A        

2. Creating and Formatting Database Elements
2.1        Create databases                        
2.1.1        Create databases using templates        1        3-A        3-1
2.1.2        Create blank databases        1        3-A        3-1
2.2        Create tables                        
2.2.1        Create custom tables in Design view        1        3-B        3-2
2.2.2        Create tables by copying the structure of other tables        1        3-B        3-4
2.2.3        Create tables from templates        1        3-B        3-3
2.3        Modify tables                        
2.3.1        Modify table properties        1        3-C        3-5
2.3.2        Evaluate table design using the Table Analyzer        3        1-A        1-1
2.3.3        Rename tables        1        3-C        3-5
2.3.4        Delete tables        1        3-C        3-5
2.3.5        Summarize table data by adding a Total  row        1        4-A        4-1
2.4        Create fields and modify field properties                        
2.4.1        Create commonly used fields                        
•        Text fields        1        3-B        3-2
•        Number fields        1        3-B        3-2
•        Date/Time fields        1        3-B        3-2
•        Currency fields        1        3-B        3-2
•        AutoNumber field        1        3-B        3-2
•        Yes/No fields        1        3-B        3-2
•        Memo fields        1        3-B        
2.4.2        Modify field properties                        
•        Define input masks for fields        2        1-B        1-2
•        Define text length        2        1-A        1-1
•        Allow zero length        2        1-A        1-1
•        Set memo fields as append only        2        1-A        1-1
•        Set data validation rules        2        1-A        1-1
•        Enter captions        2        1-A        1-1
2.4.3        Create and modify multivalued fields
NOTE: Issue with upsizing; could cause problems        1        3-B        3-2
2.4.4        Create and modify attachment fields                        
•        Multiple attachments        1        3-B        3-2
•        Assign attachment data type to a field        1        3-B        3-2
2.5        Create forms                        
2.5.1        Create forms using Design view        1        6-B        6-2
2.5.2        Create datasheet forms        1        6-B        
2.5.3        Create multiple item forms        1        6-B        6-2
2.5.4        Create split forms        1        6-B        6-2
2.5.5        Create subforms        2        4-E        4-5
2.5.6        Create PivotTable forms        3        4-C        4-4
2.5.7        Create forms using Layout view        1        6-B        
2.5.8        Create simple forms        1        6-B        6-2
2.6        Create reports                        
2.6.1        Create reports as a simple report        1        7-B        7-2
2.6.2        Create reports using the Report Wizard        1        7-B        7-3
2.6.3        Create reports using Design view        1, 2        7-B, 5-A        5-1
2.6.4        Define group headers        2        5-A        5-1
2.6.5        Create aggregate fields        1        7-B        7-3
2.6.6        Set the print layout                        
•        Avoid excess pages, etc., basic print and layout skills        2        5-D        5-4
•        Keep data together in a printed report        2        5-D        5-4
•        Design and arrange a report in Layout view        2        4-A        4-1
2.6.7        Create labels using the Label Wizard        2        5-G        5-7
2.7        Modify the design of reports and forms        1        6-C, 7-E        6-4, 7-6
2.7.1        Add controls                        
•        Add fields from tables as controls        1        6-B        6-2
•        Add controls using the Ribbon        2        5-A        5-1
2.7.2        Bind controls to fields        2        4-C        4-3
2.7.3        Define the tab order of controls        1        6-C        6-4
2.7.4        Format controls                        
•        Change control formatting (for example, number to currency)        1        7-D        7-5
•        Change font color        2        4-B        4-2
•        Change foreground color        2        4-B        4-2
2.7.5        Arrange controls                        
•        Group and ungroup controls        1        6-C        6-4
•        Align controls        1        6-C        6-4
•        Anchor controls        2        4-A        4-1
2.7.6        Apply and change conditional formatting on controls        2        4-B        4-2
2.7.7        Apply AutoFormats to forms and reports        1        7-E        7-6

3. Entering and Modifying Data
3.1        Enter, edit, and delete records                        
•        Edit records        1        4-A        4-1
•        Delete records        1        4-A        4-1
3.2        Navigate among records                        
•        Move to a specific record        1        6-A        6-1
•        Move to the first or last record        1        6-A        6-1
3.3        Find and replace data        2        3-B        3-2
•        Find using criteria        2        3-B        3-2
•        Find using wildcards        2        3-B        3-2
•        Replace data        1        4-A        4-1
3.4        Attach documents to and detach from records                        
•        Attach multiple attachments to records        1        3-B        3-2
•        Attach files to records        1        3-B        3-2
•        Detach attachments from records        1        3-B        
•        Export attachments        1        3-B        3-2
•        Navigate attachments        1        3-B        
3.5        Import data                        
3.5.1        Import data from a specific source                        
•        Import Microsoft Excel data        2        6-A        6-1
•        Import CSV data        2        6-A        6-2
3.5.2        Link to external data sources        2        6-A        
•        Link to Excel spreadsheets        2        6-A        
3.5.3        Save and run import specifications        2        6-A        6-1

4. Creating and modifying queries
4.1        Create queries        2        3-B        3-2
4.1.1        Create queries based on single tables                        
•        Add fields to queries        1        5-B        5-2
•        Add all fields from a table to a query        2        3-C        3-3
•        Find duplicates        3        2-B        2-2
4.1.2        Create queries based on more than one table                        
•        Identify which table to draw a field from when two tables have fields with the same name        2        2-C        2-3
•        Find unmatched records        3        2-B        2-2
4.1.3        Create action queries                        
•        MAKE TABLE        2        3-C        3-3
•        INSERT        2        3-C        3-3
•        APPEND        2        3-C        3-3
•        DELETE        2        3-C        3-3
4.1.4        Create crosstab queries        3        2-D        2-4
4.1.5        Create subqueries        3        2-A        2-1
4.1.6        Save filters as queries        1        5-A        5-1
4.2        Modify queries                        
4.2.1        Add tables to and remove tables from queries                        
•        Add tables to queries        1        5-B        5-2
•        Remove tables from queries        1                5-4
•        Add a second copy of a table to a query        2        2-C        2-3
4.2.2        Add criteria to queries                        
•        Hard-coded criteria        2        3-A        
•        Parameters        2        3-B        3-2
4.2.3        Create joins                        
•        INNER (Join Properties dialog box:
option 1)        2        2-A        2-1
•        LEFT (Join Properties dialog box:
option 2)        2        2-A        2-1
•        RIGHT (Join Properties dialog box:
option 3)        2        2-A        2-1
4.2.4         Create calculated fields in queries                        
•        Add fields to calculations        1        5-D        5-5
•        Use arithmetic operators (ex. *, +, -)        1        5-D        5-5
4.2.5        Add aliases to query fields        2        2-C        2-3
4.2.6        Create sum, average, min, max, and count queries                        
•        Sum queries        1        5-E        5-6
•        Average queries        1        5-E        5-6
•        Min/max queries        1        5-E        
•        Count queries        1        5-E        

5. Presenting and Sharing Data
5.1        Sort data                        
5.1.1        Sort data within tables        1        4-B        4-2
5.1.2        Sort data within queries        2        3-A        3-1
5.1.3        Sort data within reports        2        5-A        5-1
5.1.4        Sort data within forms        2        4-A        4-1
5.2        Filter data                        
5.2.1        Filter data within tables        1        5-A        5-1
5.2.2        Filter data within queries        2        3-C        3-3
5.2.3        Filter data within reports        2        5-A        5-1
5.2.4        Filter data within forms        2        4-A        4-1
5.2.5        Remove filters        2        3-C        3-3
5.3        Create and modify charts                        
5.3.1        Create charts        3        5-A        5-1
5.3.2        Format charts        3        5-A        5-1
5.3.3        Change chart types        3        5-A        5-1
5.4        Export data        2        6-B        6-3
5.4.1        Export data from tables        2        6-B        6-3
5.4.2        Export data from queries        2        6-B        6-3
5.4.3        Save and run export specifications        2        6-B        6-3
5.5        Save database objects as other file types                        
•        Save as an XPS file        1        3-B        3-2
5.6        Print database objects                        
•        Print all        1        7-F        
•        Print selections        1        7-F        

6. Managing and Maintaining Databases
6.1        Perform routine database operations                        
6.1.1        Open databases                        
•        Exclusively        4        4-C        4-3
•        With shared access        4        4-C        4-3
6.1.2        Back up databases        3        6-B        6-2
6.1.3        Compact and repair databases        3        6-B        6-2
6.1.4        Save databases as a previous version        1        3-E        3-7
6.2        Manage Databases                        
6.2.1        Encrypt databases using passwords        4        4-C        4-3, 4-4
6.2.2        Configure database options                        
•        Enable error checking        4        3-C        
•        Show/Hide navigation pane        4        3-C        3-4
•        Set up startup display form        4        3-C        3-4
6.2.3        Set database properties                        
•        Populate a property        3        6-B        6-2
•        Create a custom property        3        6-B        6-2
6.2.4        Identify object dependencies                        
6.2.4.1        Database tools tab        3        6-C        6-3
6.2.5        Print database information using the Database Documenter        3        6-D        6-4
6.2.6        Reset or refresh table links using the Linked Table Manager        3        6-A        6-1
1994-2010 ConnecTotal All rights reserved.
What our customers say...

"Makes me comfortable when
questioning everything!!"

"Very on track with pace of class."

"Fantastic class.  I like the small
group and hands on."

"Very patient and clear instruction."

"This class has been a great help in
furthering my knowledge."

"I learned a lot and refreshed what I
already knew."