Sacramento, California

Microsoft Access Database in Sacramento, California

Sacramento (/?sŠkr?'m?nto?/; Spanish:á[sak?a'mento]) is the capital city of the U.S. state of California and the seat of Sacramento County. It is at the confluence of the Sacramento River and the American River in the northern portion of California's expansive Central Valley, known as the Sacramento Valley. Its estimated 2016 population of 493,025 makes it the sixth-largest city in California, the fastest-growing big city in the state,[11] and the 35th largest city in the United States.[12][13] Sacramento is the cultural and economic core of the Sacramento metropolitan area, which includes seven counties with a 2010 population of 2,414,783.[10] Its metropolitan area is the fourth largest in California after the Greater Los Angeles area, the San Francisco Bay Area, and the San Diego metropolitan area, and is the 27th largest in the United States. In 2002, the Civil Rights Project at Harvard University conducted for Time magazine named Sacramento "America's Most Diverse City".[14] Sacramento became a city through the efforts of the Swiss immigrant John Sutter, Sr., his son John Augustus Sutter, Jr., and James W. Marshall. Sacramento grew quickly thanks to the protection of Sutter's Fort, which was established by Sutter. During the California Gold Rush, Sacramento was a major distribution point, a commercial and agricultural center, and a terminus for wagon trains, stagecoaches, riverboats, the telegraph, the Pony Express, and the First Transcontinental Railroad. The city was named after the Sacramento River, which forms its western border. The river was named by Spanish cavalry officer Gabriel Moraga for the SantÝsimo Sacramento (Blessed Sacrament), referring to the Catholic Eucharist. Today, the city is known for its diversity, tree canopy (largest in the U.S.), historic Old Sacramento, evolving contemporary culture as the most "hipster city" in California, sunny climate, state administration, and farm-to-fork dining. California State University, Sacramento, is the largest university in the city and a designated "Tree City USA" campus. The University of the Pacific is a private university with one of its three campuses, the McGeorge School of Law, in Sacramento. In addition, the University of California, Davis, 16 miles west of Sacramento, operates UC Davis Medical Center, a world-renowned research hospital, in the city of Sacramento. We performed Consulting, Design, Development, Installation and Training for a Property Management Access application.

Clients
  • LOMC, LLC / PrimeLegal
    LOMC LC / Prime Legal is a prepaid law firm. We built a web application to manage their referral network
  • GUSA Soccer
    GUSA Soccer is a Soccer league in Goochland, Virginia. We built a website to manage their player registations
  • At Home Care
    AT Home Health and Hospice Care is an established, full-service home health agency and hospice that provides a superior quality of services in a caring manner. We built a web application to manage their Doctor sign off process
  • Dominion Partners
    Dominion Partners desired an Access Guru to build an access database to manage their investment banking back office operations. They contracted us for this Access Database project.
  • Holiday Signs
    Holiday Signs need an expert Access Database consultant to revise their Customer Relationship Manager application. This is an Access database that provides at-your-fingertip pipeline data to help both the salesmen and sales managers keep track of ongoing sales leads. Metrics come out of this database to help evaluate and improve sales performance.

    We are also the PHP Developer and MySQL Consultant for Holiday signs. You may find more information about these services here: Data Bolt provides PHP and MySQL consulting
  • Maisonettes Apartments
    Maisonnettes Apartments runs an apartment complex and a trailer park. We upgraded their previous DOS based monthly rent collection application into an Access Database. Now all functionality of tracking tenants monthly rent is handled in Access. This database also provide the lease agreements and tracks historical tenants (tenants that have previously lived at the property)
  • API Services
    Precision measurement and tool calibration for manufacturing clients, we built (and Host) a MySQL database for API Sensor that tracks associates timesheets and expenses for management reporting and reimbursement/payroll. This is a backoffice application that runs the expense side of a company with geographically dispersed employees. They track their billable time and expenses, assigning both to projects/clients.
  • Strategic Technology Systems
    An Access database with a SQL Server back end was already in place at CeMark, STS's client. We were asked to migrate the data file to a new version of SQL Server.
  • ActivSupport
    ActivSupport contacted us to fix various SQL Server, and Sharepoint Databases for their clients in Charlottesville, VA.

    Active Support needed an expert database consulting company to support their clients without having to worry about the end results. Keeping their client happy was most important to ActivSupport. By supplying professional database developers to ActivSupport and their clients, we kept both our partner and their client happy

Here are some clients we have helped in Sacramento

Client

Project Description

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
  • Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database