Microsoft Access 2007
30 second training   -   TimOwens.Com

Click the underline sample below to view

Click the blue underlined samples

INTRODUCTION
Open Microsoft Access   0:20 seconds
Open the Microsoft provided database (North wind Traders)  0:32 seconds
Explore the access environment   0:37 seconds
Explore the ribbon   0:26 seconds
Customize the quick access toolbar   0:31 seconds
Navigate to a topic in the access help window   0:23 seconds
View the data in a table   0:23 seconds
Run a query   0:32 seconds
View data using a form
View a report   
 
BUILDING A DATABASE
 
Create a blank database              
Create a template based database
Create a blank table      
Create a table using a template               
Create a table based on the structure of an existing table in a different database           
Create a table based on the structure of an existing table in the same database              
Insert a field in a table 
Create a multivalued field         
Insert a record into a table         
Change the primary key of a table to a composite key  
Save a table as an xps file           
Delete a table  
Rename a table               
Add a description to a table       
Customize tables using the access options dialog box   
Create a table relationship        
Print a table relationship            
 
MANAGING DATA IN A TABLE    
 
Add a record to a table 
Find a record    
Replace data in a record              
Update data in a table  
Delete a record from a table     
Add the total row to a table       
Sort records in a table according to one field     
Sort records in a table according to two or more fields  
View data in subdatasheets       
Modify subdatasheets 
 
QUERYING A DATABASE
 
Filter records in a table
Save the filter as a query            
Remove the filter           
Create a select query using the query wizard    
Create a select query using the query design feature    
Add criteria to a query 
Add a calculated field to a query             
Perform calculations on a record grouping         
 
DESIGNING FORMS
 
View records using a form          
Add records to a table by using a form  
Search records based on criteria              
Create forms using various form creation tools
Create a form using the form wizard
Modify a form  
 
GENERATING REPORTS
 
Open an access report in different views            
View an access report in different views             
Navigate through an access report in print preview mode           
Create a blank report    
Create a report based on the data in a table      
Create a report using the report wizard
Add a custom calculated field to a report            
Format the control of a report  
Apply an autoformat style to a report in layout view     
Apply an autoformat style to a report in design view     
Preview a report             
Change the margin settings of a report
Change the proofing options    
 
CONTROLLING DATA ENTRY
 
Set field properties       
Add an input mask using the input mask wizard               
Create an input mask    
Manually add an input mask to a field  
Create a lookup column based on a table or a query      
 
JOINING TABLES
 
Create a join line between tables in query design view
Change the join type    
Join unrelated tables by adding a table to a query design           
Create a self join            
 
CREATING FLEXIBLE QUERIES
 
Create a query from more than one table           
Sort data in a query       
Show top or bottom values        
Show records that contain unique values            
Show unique records only          
Customize a query         
Create and run a parameter query
Find and replace data using wildcards within a query    
Create an action query to update records           
Create an action query to append records          
Create an action query to delete records            
Create a make table query         
Filter data in a query     
Remove the filter in a query     
 
IMPROVING FORMS
 
Design a form   
Anchor a group of controls         
Filter data in a form       
Remove the filter in a form       
Sort data in a form         
 
WORK WITH CONTROLS
 
Add an image   
Group form controls      
Ungroup form controls 
Display the form header/footer              
Apply conditional formatting    
Apply font properties   
Apply font properties   
Apply foreground color to a control
Add a combo box or list box control
Create an option group
Create command buttons using the wizard         
Create a subform using the wizard
 
CUSTOMIZING REPORTS
 
Create a blank report in design view
Create a report from an existing query using the report wizard
Create a report from an existing query using the report button
Add controls using the field list pane    
Add controls using the ribbon and bind them to fields 
Use the filters feature  
Sort and group the records in a report using the report wizard  
Group the records in a report using the group, sort, and total pane        
Sort the records in a report using the group, sort, and total pane             
Use the totals feature  
Format a report               
Modify the properties of a control
Control report pagination using design view     
Control report pagination using layout view      
Define a field summary field    
Create a subreport         
Create a report that prints mailing labels            
 
SHARING DATA ACROSS APPLICATIONS
 
Specify the source and destination of data to be imported or linked     
Import an excel worksheet        
Import a text file            
Import data from an access database
Link excel data with access         
Run import specifications
Export data        
Export data as a .csv file              
Run export specifications           
Create a chart in excel  
Create a chart with access data 
Export a query to a text file       
Export query data as a csv file   
Merge an access table or query with an existing word document             
 
STRUCTURING EXISTING DATA
 
Restructure table using the table analyzer wizard           
Create a junction table
Improve table structure              
 
WRITING ADVANCED QUERIES
 
Create a sub query in design view
Create a sub query n SQL view  
Create an unmatched query      
Create a duplicate query             
Summarize data using the criteria row  
Summarize data with a crosstab query  
Create a pivot table       
Create a pivot chart       
 
SIMPLIFYING TASKS WITH MACROS        
 
Create a macro
Attach a macro to a command button    
Restrict records using a where condition             
Made data entry mandatory using a macro         
Modify an existing macro to display a message box       
Specify a condition for automating data entry
 
MAKING EFFECTIVE USE OF FORMS
 
Add a calendar control to a form
Create a new form with tab pages
Create a pivot chart in a form    
Create a pivot table in a form   
 
MAKING REPORTS MORE EFFECTIVE
 
Add a chart to a report using the chart wizard    
Create a multiple-column report
Build and run a macro to cancel a report that contains no records            
Create a report snapshot            
 
MAINTAINING AN ACCESS DATABASE
 
Link tables to an access database
Set database properties              
Compact and repair a database
Determine object dependency
Use the database document tool
Analyze database performance               
 
INTEGRATING ACCESS INTO YOUR BUSINESS
 
Add a new contact to the outlook address book from an access table
View a contact added to the outlook address book         
Send an email using a smart tag               
Collect data through an email message
Add an attachment field to a table in datasheet view    
Add an attachment field to a table in design view           
Attach files to an attachment field in a record  
Export an attachment from a record
Open an attachment     
Remove an attachment from a record   
Add an attachment control to a form/report      
Navigate through attachments in a form/report              
Save a database as a previous version  
 
MANAGING SWITCHBOARDS
 
Create a database switchboard
Modify a database switchboard               
Set the startup options for a database
Modify the error checking options
 
DISTRIBUTING AND SECURING DATABASES
 
Split a database               
Add a new location to the trust center  
Remove a location from the trust center             
Open a database with shared access
Open a database with exclusive access
Set a database password             
Open a password-protected database
Unset a database password        
Set a vba password        
View the code in a password protected vba application               
Unset a vba password   
Convert an access database to an accde file       
Package a database with a digital signature        
Extract a signed package

top