About this lesson
Make great looking forms by changing colors, creating a close button and sorting or filtering columns.
Download this lesson’s related exercise files.Services_05_Start.accdb
588 KB Services_05_end.accdb
Access 05. Colors, Filter Data, Close Button
Access Options are a list of defaults for how Access will work that can be viewed and modified by choosing the File menu and then Options.
In the record selector box, an asterisk * signifies a new record.
Back Color is the property that controls the background color of an object.
Back Style is whether that background of an object will be solid or transparent.
A cell, in a layout, is a distinct square which can contain information or be empty.
The Builder Button is displayed to the right of a property when a helper is available. Press Ctrl-F2 to launch the builder.
The Button Tool is in the Controls group on the Design ribbon and enables you to add command buttons to forms and reports.
A 6 character code prefaced with # that specifies RGB (Red-Green-Blue) values. Each set of 2 characters represents a hex value from 00 (no color) to FF (all color). Color codes can be copied and pasted. Black is 000000. White is FFFFFF.
A combo box provides a convenient way to pick information from a list making the data more consistent and, therefore, more reliable.
A Command Button, or Button, is a control that can make something happen when the user clicks on it such as Close a form.
Command Button Wizard
A set of guided questions that help you build a macro for a command button..
Current Database is a set of Access defaults to specify information about the current database such as how the windows will appear, an Application Title, and what form will automatically display when the database is opened.
A default is the standard way something will behave, or a standard value something will have unless changed.
The design view of an object allows you to change its definition.
Document Window Options
Document Window Options is a section of defaults for the Current Database that allows you to specify if you want windows to appear as Overlapping windows or Tabbed Documents.
Tabbed Documents is the default choice for Document Window Options whereby each window takes all the working space and can be accessed using tabs across the top of the design space. In these lessons, this view is not being used.
Filter means to limit how many records will be displayed based on logical conditions.
Filter by Selection
Limit records displayed by applying logic based on the selected value.
Fore Color is the property that specifies the color of text.
Form Operations is a category of the Command Button Wizard specifying choices such as Close For, Open Form, and Print Form.
A layout is a pattern for objects on a form to line them up. Layouts are like tables with rows, columns, and cells.
An area on a form or report that contains a picture.
An action or set or actions that can be carried out.
Multiple Users means that more than one person is sharing and/or updating a database.
The Navigation Pane is an area on the left of the database window that enables you to open and design objects. It can be sorted and displayed by different categories. Object Type is the most common way to display objects in the Navigation Pane.
A logical word to call something that can be recalled and used later.
To see multiple windows at the same time, in the Access Defaults, choose:
File, Options, Current Database, Document window Options --> Overlapping Windows
A Palette is a visual example of colors to pick from. When choosing colors, if you want the color to change based on your Theme, choose a Theme color. If you want the color to be absolute, choose from Standard colors.
In the record selector box, a pencil means there are changes to the record that have not been saved. Records are automatically saved unless you undo them.
To refresh data in a table that was open when data was entered into it using a form (or by another user), choose Refresh All from the Home ribbon.
Record Selector Box
The record selector box is an area to the left of a record with indicators and the place to click to select a record.
To refresh records to show all changes, including changes made by others in a multi-user application, choose Refresh All from the HOME ribbon.
RGB stands for Red-Green-Blue, the 3 primary colors to specify colors on a computer monitor.
To select all the controls in a section, click and drag in the vertical (or horizontal) ruler.
Forms and reports have sections such as Header, Detail, and Footer. Section Bars are shown at the top of each section. To change properties for a section, you may click on the section bar to select it.
When you click on the Custom tab of the Colors dialog box, you will see a triangle pointer that you can drag up and down to make the shade of a color lighter or darker.
Sort means to arrange data in a particular order.
Split Horizontally is an icon in the Merge/Split group of the Arrange ribbon and splits a selected cell into 2 halves.
A subform is a special use of a form that is contained on another form. Subforms can be synchronized with mainforms using LinkMasterFields and LinkChildFields.
Toggle Filter is an icon in the Sort & filter group of the Home ribbon that allows you to apply and remove a data filter.
Toggle Selection Status
to toggle the selection status of an object. If the object is selected, it will become de-selected and vice-versa.
When something is transparent, you can see through it.
A list of choices that appears when you right-click the mouse. Shortcut menus detect position and provide a list appropriate to what the mouse pointer is on or where the pointer is.
Turn on the Property Sheet
- Right-Click on the design surface
- Choose Properties from the shortcut menu to toggle the display of the Property Sheet on or off
- Alternately, you can press (Alt-Enter)
Change Background Color of a Section
- Click on a section bar or a blank area of the section
- On the Property Sheet, click in the Back Color property.
- Choose the down arrow to select a Theme Color or the Builder Button to select a Standard Color.
- Alternately, you can right-click and choose Fill/Back Color from the shortcut menu to choose a Standard Color.
Change the Color Shade
- To change the shade of a color to lighter or darker, choose More Colors … from the bottom of the standard Colors palette.
- On the Custom tab, drag up or down
Copy Color to another Property (of same Control or a Different One)
- To copy a color, click on a color property on the Property Sheet
- Select the Color Number (i.e.: #FCE6D4) and Copy
- Paste the Color Number into the property where you want it to be
Save a Record
- If you have made changes to a record, the filled triangle will change to a pencil in the record selector box.
- Click in the record selector box to save, or press
Move to Next Control
- To move to the next control (with Tab Stop set to Yes) in a form or Datasheet, press
Move to Previous Control
- To move to the previous control (with Tab Stop set to Yes) in a form or Datasheet, press
Copy Value from Previous Record
- To copy the value in a field from the previous record, press (Ctrl-')
Sort or Filter a Column
- In Datasheet View, click the down arrow in a column label to get a menu to sort or filter
Remove a Filter
- To remove a filter (or set Filter to last filter used), click the Toggle Filter icon on the HOME ribbon
- or click the Filtered/Unfiltered icon by the navigation controls in the lower left.
Create a Close Button Using the Command Button Wizard to make a Macro
- On the ribbon, click the Button tool
- Click on the Form where you want the button.
- A button of default size will appear and the Command Button Wizard pops up.
- Under Categories, choose Form Operations.
- Under Actions, choose Close Form.
- Click Next
- Choose Text (instead of picture), if desired (or pick a picture) to say Close.
- Click Next
- Change the Name property of the button to --> cmd_Close
- Click Finish
Open an Object listed in the Navigation Pane
- To open an object, double-click its name in the Navigation Pane
Split Cell in a Layout
- To split a cell in a layout, choose Split Horizontally or Split Vertically on the Arrange Ribbon tab of the design tools
Remove a Layout
- To remove a layout, choose Remove Layout on the Arrange Ribbon tab of the design tools
Lesson notes are only available for subscribers.