Yawn-proof software training

ACCESS - Quick Buttons and Definitions

A single month is not nearly enough time to fully delve into all of the aspects of Microsoft Access, though we hope we've given you some of the basics to get started in experimenting on your own. For today's blog, we'll be defining some terms and explaining a few buttons on the ribbon that ought to make your database practice a little easier. Remember, Access databases can be large and complex - always keep a back up of your data, and ask for help if you need it.

 

Definitions:

Navigation Pane: The collapsible frame to the left of your Access working window. The navigation pane outlines all saved tables, forms, and queries contained in the database file.

ACCESS---Navigation-Pane

 

Query: A designated search or "question" for your database.  Queries may be a simple search for single entry or term, or they may be elaborate, evaluating variables and numerous criteria. Repetitive searches should be saved as queries in your database for time saving one-click results.

ACCESS-query-design-options

 

Buttons:

(Auto) Form: With a data table highlighted in your navigation pane, clicking this button will automatically generate a simple form from the data fields contained in the table.  This form may then be edited/customized to the user's preferences.

ACCESS---Quick-Form

Import Buttons: The external data import fields make it easy to transition your existing data to your new Access database. If you've kept records in a previous version of Microsoft Access, in Excel, or other data management system, you can use the Import Wizard to bring your information into the database.  Many online contact management systems allow users to export data in text or CSV (comma separated values) format - both of these are easily imported and interpreted by Access.

Export Buttons:  Conversely, if you were looking to export your contact emails (with permission, of course) to an online electronic newsletter service, you may elect to export only the names and email addresses of the contacts to a text or CSV file type.  These simple files types are widely accepted by online e-marketing services.

ACCESS---Import-Export

 

Create Email: Access grants users the ability to email forms to contacts in order to collect or update data. This can be a handy tool to ensure your contact lists are up-to-date, allowing you to maintain a stronger connection with existing and potential customers.

ACCESS---Create-Email

ACCESS---Create-Email-Wizard

If you would like more information on how to create and maintain your own Access database, we'd be happy to provide you and/or your staff with customized training opportunities. Connect with us today.

 

Getting Our Geek On For Christmas!
ACCESS - Querying a Database

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, 17 January 2020

Captcha Image

Book

How To Choose a Software Trainer They'll Thank You For

Survey says: "Sitting through software training is painful".

Knowing how to use MS Office and knowing how to train people to use it are two different things. Download this Special Report and discover how to choose a trainer that leaves your employees feeling useful.

  • Claire Langfield, Executive Assistant

    Chippewas of Rama First Nation

    The majority of my computer training focused on Publisher. I have received positive comments and feedback from several of my colleagues on the changes between my first attempt and current expertise creating the monthly internal newsletter for my department. They enjoy the updated format and the way in which the information is presented. 

    Deborah assisted me through a learning curve, as I had not previously had any exposure to this program prior to joining Rama. She also provided me with a refresher course on PowerPoint and Excel.  Deborah is a patient teacher and tailored the training to suit my job requirements.