Keystone Computer Keyboard manual Connecting to a database Option 2 Microsoft Access

Page 19

F. Connecting to a database (Option 2 - Microsoft Access)

1.To set up a new database in Access, an easy method is to first create your data in an

Excel Spreadsheet format (as shown below) and export the spreadsheet into Access.

RECORD #

DESCRIPTION

BARCODE #

123456

COTTON BALLS

12345678

654321

TRAY C SECTION

87654321

9876543

SYRINGE 10ML

98765432

Give the spreadsheet any name you want and save it on your computer.

IMPORTANT: Be sure to put the column names in ROW 1.

Make sure that the Access database containing the user database is closed before proceeding with using the Solo Studio software

Next, follow the detailed instructions on how to import the spreadsheet you just created into an Access database and give the database any name you want and save it on your computer.

How to import a Microsoft Excel spreadsheet into an Access database

Open Microsoft Access

Click on the top menu “File” and “New”

Select “Blank Database”

Assign an appropriate file name to the new Access database and save it to the desired directory

Click on the “Create” button

Click on top menu “File” and select “Get External Data” and select “Import”

Right click on “Tables” in the “Database - Objects” section

Locate the original spreadsheet containing the label data

Make sure to use the drop down menu under “Files of Type” and select “Microsoft Excel (*.xls)” files and click on the “Import” button

Make sure that the “First Row Contains Column headings” option is selected/checked

Click “Next”; select “In a New Table” when asked where would you like to store your data, click “Next” to continue

You will now see the Field Options screen and “Record #” selected as the “Field Name”, click on “Next”

For technical support, please call: 800-323-4840 ext. 290 (M - F 8 a.m. to 5 p.m CST)

19

 

 

Image 19
Contents Keystone Labeling System Page Unpacking Keystone Loading the Label Media Important Safety InstructionsLabel Media Sensor Adjustment Printer Coverage Equipment Service CoverageKeyboard Coverage Thermal Printhead CoverageSoftware Installation Installing the Labeling SoftwareReturns Type in the CD key # 42885, click on Next to continue Page Page Page Page Running the program Connecting the keyboard to the PCBaud 9,600 Communication settings on the keyboardBaud Rate 9,600 Baud 57,600Connecting to a database Option 1 Microsoft Excel Page Connecting to a database Option 2 Microsoft Access Page Page TM LBL Setting up the labels/building the label templatePage Tear-Off Map a Text label element to a Database Field Map a Barcode label element to a Database Field Map a Label element using the Keyboard User Input Other Label Setup Options Map a label element using Keyboard User Input Transferring labels to the Keyboard Data entry Keyboard User Input Keyboard does not respond or the screen is blank Keyboard communication settingsPrinter communication settings Datamax M-Class PC and Program SettingsBaUD 9,600 Parity None daTA BIT 8 Stop BIT Protocol Both Parity None Keyboard Internal DIP switches Default Communication Settings on the Printer Communication settings on the PCTo clean the printhead Cleaning the PrintheadTimeMed Labeling Systems, Inc

Computer Keyboard specifications

The Keystone Computer Keyboard has emerged as a notable contender in the realm of computer peripherals, combining practicality with advanced technology to enhance user experience. Designed for both gamers and professionals, this keyboard promises not only durability but also an array of features that cater to a wide audience.

One of the primary characteristics of the Keystone Keyboard is its mechanical switches, which are known for their responsiveness and tactile feedback. These switches provide a satisfying typing experience and are designed to withstand millions of keystrokes, ensuring longevity. The keyboard is often equipped with customizable RGB backlighting, allowing users to personalize their setup with a spectrum of colors and effects. This not only enhances the aesthetic appeal of the keyboard but also improves visibility in low-light conditions, a feature appreciated by both gamers and late-night workers.

In terms of build quality, the Keystone Keyboard typically boasts a sturdy construction, often featuring an aluminum chassis that adds to its premium feel and overall durability. The design is often ergonomic, with a comfortable key layout that minimizes strain during extended use. Some models also include features such as detachable cables for easier transport and maintenance, as well as programmable macro keys that enable users to execute complex commands swiftly.

A standout technology featured in the Keystone Keyboard is its onboard memory, which allows users to save their custom settings and profiles directly on the keyboard. This is a significant advantage for those who switch between different devices or setups, as it eliminates the need for software installation on every machine. Additionally, the keyboard often supports various operating systems, making it versatile and compatible with a wide range of devices.

Another noteworthy characteristic is the inclusion of anti-ghosting technology, which prevents missed inputs when multiple keys are pressed simultaneously. This feature is particularly beneficial in gaming scenarios, where quick access to multiple functions is crucial.

In conclusion, the Keystone Computer Keyboard blends functionality with cutting-edge technology, making it an excellent choice for anyone seeking a reliable and customizable typing solution. Its durable construction, mechanical switches, customizable lighting, and advanced features establish it as a top choice among both casual users and professionals alike. Whether for gaming or day-to-day tasks, the Keystone Keyboard meets the demands of the modern user, delivering performance and style in one package.