Access Training
Access Introduction
Course Objectives
Welcome to Seven Institute’s course for Microsoft Office Access, Microsoft’s flagship database software. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user.
This Introduction level is intended to help all novice computer users get up to speed quickly. This course will also help more experienced users who have little to no experience with Access and the ribbon interface.
This manual will cover different features of the interface, give a brief overview of all the tabs in the ribbon, show users how to design and construct a simple database, and cover the basics of using forms and reports. By the end of this manual, users should be comfortable with creating and using simple databases, entering new data, and then managing the existing data.
Who Should Attend
This manual assumes the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Students should also be comfortable navigating the file structure of their computer in order to create and manage files and folders. Understanding and experience with printing and using a Web browser is an asset, but not required.
Course Syllabus
GETTING STARTED
- Recognise some new features in Access
- Open and close Access
- Identify and understand basic database terminology
- Identify different interface features
- Use the Backstage View (File menu)
- Interact with the tabs and their commands
- Recognise different database warning messages
- Enable content when appropriate
- Open and configure the Help file
- Use the Help file to search for topics
- Browse the Help file’s table of contents
- Switch between Online and Offline Help
THE ACCESS INTERFACE
- Use commands on the Quick Access Toolbar
- Customize commands on the Quick Access Toolbar
- Recognise tabs, groups, option buttons, commands, and the ribbon
- Open additional dialog boxes
- Use the File (Backstage) menu
- Minimize the ribbon commands
- Commands in the Home tab
- Commands in the Create tab
- Commands in the External Data tab
- Commands in the Database Tools tab
CREATING A DATABASE
- Plan the basics of a database
- Create a new blank database
- Create a database from a template
- Open and view different database objects
- Set up the Navigation Pane
- Move around in a database
- Add, edit, and delete records
- Print records
CREATING TABLES IN ACCESS
- Create a new, blank table
- Add and edit the components of a table
- Add data to a table
- Format table fields
- Zoom in and out of different database objects
- Select different database components
- Cut, copy, and paste information
- Use the Format Painter
- Use Undo and Redo
- Check your spelling
CREATING FORMS IN ACCESS
- Create a basic form
- Create a form using the wizard
- Modify a form in Design view
- Use the Form Design Tools contextual tabs
- Use forms to view and/or enter data
CREATING A QUERY IN ACCESS
- Create a query with the wizard
- Modify a query using Design view
- Use the Query Design Tools contextual tab
- Use queries to extract information from your data
CREATING REPORTS IN ACCESS
- Create a report with the wizard
- Modify the layout of a report using Design view
- Use the Report Design Tools contextual tabs
- Use reports to display information
DOING MORE WITH YOUR ACCESS DATABASE
- Use Find and Replace to track down information
- Sort the data in a table or query results
- Use filters to quickly narrow large numbers of query results
- Use the different object views
- Switch between multiple database objects
- Close individual database objects
- Print database objects
- Use the Print dialog box
- Use Print Preview
- Recognise the difference between printing and exporting